VM1 Скрипт создания и печати экселевских форм ф113, ф113а и ф7 Почты Росси из списка заказов админки - Коммерческие расширения для VirtueMart

$q = "SELECT a.*, #__{vm}_order_user_info.user_email, #__{vm}_order_user_info.first_name, #__{vm}_order_user_info.last_name, #__{vm}_order_user_info.middle_name, #__{vm}_order_user_info.address_1, #__{vm}_order_user_info.city, #__{vm}_order_user_info.zip, #__{vm}_order_user_info.state, #__{vm}_order_user_info.country
	 FROM #__{vm}_orders a , #__{vm}_order_user_info
	 WHERE a.order_id=#__{vm}_order_user_info.order_id 
	 AND a.order_id='$order_id'";
	$db->query($q);

$q = "SELECT a.*, #__{vm}_order_user_info.user_email, #__{vm}_order_user_info.first_name, #__{vm}_order_user_info.last_name, #__{vm}_order_user_info.middle_name, #__{vm}_order_user_info.address_1, #__{vm}_order_user_info.city, #__{vm}_order_user_info.zip, #__{vm}_order_user_info.state, #__{vm}_order_user_info.country
	 FROM #__{vm}_orders a , #__{vm}_order_user_info
	 WHERE a.order_id=#__{vm}_order_user_info.order_id 
	 AND a.order_id='$order_id'";
	$db->query($q);
	$dbstl = new ps_DB();
	$q = "SELECT state_name FROM #__{vm}_state WHERE #__{vm}_state.country_id = ";
	$q .= "(SELECT country_id FROM #__{vm}_country WHERE #__{vm}_country.country_3_code = '".$db->f('country')."') ";
	$q .= "AND #__{vm}_state.state_2_code = '".$db->f('state')."' ";
	$dbstl->query($q);
	$dbstl->next_record();

<input type="hidden" name="state" value="'.$db->f('state').'" /> 

<input type="hidden" name="state" value="'.$dbstl->f( 'state_name' ).'" />