function translate($s_text, $s_lang, $d_lang){
$post_data['q']=$s_text;
$post_data['langpair']=$s_lang.'|'.$d_lang;
$query=http_build_query($post_data);
$url = 'http://ajax.googleapis.com/ajax/services/language/translate?v=1.0';
$b=file_get_contents($url.'&'.$query);
$json = json_decode($b, true);
if ($json['responseStatus'] != 200)return false;
return $json['responseData']['translatedText'];
}
global $alias;
if($alias==''){
$alias = translate($_POST['pagetitle'], 'ru', 'en');
$alias = html_entity_decode($alias);
$alias = strtolower($alias);
$patterns = array(' ', ',', '.', '!', '?', '"', '& #39;', '%');
$replacements = array ('_', '', '', '', '', '', '', 'percent');
$alias = str_replace($patterns, $replacements, $alias);
}
<?php
$dbname = $modx->db->config['dbase'];
$dbprefix = $modx->db->config['table_prefix'];
$mod_table = $dbprefix."manager_shopkeeper";
$mod_config_table = $dbprefix."manager_shopkeeper_config";
$theme = $modx->config['manager_theme'];
$charset = $modx->config['modx_charset'];
$manager_language = $modx->config['manager_language'];
$text="";
$user_id=$modx->getLoginUserID();
$count_query = mysql_query("SELECT COUNT(*) FROM $mod_table WHERE userid='".$user_id."'");
$total = mysql_result($count_query, 0);
global $modx, $langTxt;
$langTxt = array(
"noOrders" => "Заказов нет",
"currency" => "Валюта",
"currencyDefault" => "руб.",
"phase1" => "Новый",
"phase2" => "В процессе выполнения",
"phase3" => "Отправлен",
"phase4" => "Выполнен",
"phase5" => "Возникли проблемы",
"phase6" => "Оплата получена"
);
if($total>0){
$data_query = $modx->db->select("id, short_txt, content, allowed, addit, price, currency, status, DATE_FORMAT(date,'%d.%m.%Y %k:%i') AS date", $mod_table, "userid='".$user_id."'", "id DESC", "");
$summa=0;
$num = 1;
$text1='';
while ($data = mysql_fetch_array($data_query)){
$descr = $data['content'];
$L1 = unserialize($descr);
$result = count($L1);
$text1.='<tr>';
$text1.='<td rowspan="'.$result.'" width="20" align="center">'.$data["id"].'</td>';
$text1.='<td rowspan="'.$result.'" width="100">'.$data["date"].'</td>';
$text1.='<td rowspan="'.$result.'" width="160" class="status'.$data['status'].'" align="center">'.$langTxt['phase'.$data['status']].'</td>';
foreach ($L1 as $i => $value) {
$document_tvs=$modx->getTemplateVarOutput(true, $value[0]);
$pagetitle=$document_tvs['pagetitle'];
$sum = $value[1] * $value[2];
$text1.='<td width="50%"><a href="[~'.$value[0].'~]">'.$pagetitle.'</a></td>';
$text1.='<td align="center">'.$value[1].'</td>';
$text1.='<td align="center">'.$value[2].''.$data['currency'].'</td>';
$text1.='<td align="center">';
$text1.= $sum;
$text1.= $data['currency'];
$text1.='</td>';
$text1.='</tr>';
$summa = $summa + $sum;
++$num;
}
}
//подгружаем чанк
$txt = $modx->parseChunk('producthistory', array(
'ShopHistory' => $text1,
'SummaOrder' => $summa
),
'[+',
'+]'
);
echo($txt);
}
else{
echo '<div class="nogood">'.$langTxt['noOrders'].'</div>';
}
?><table>
<tr><th>№</th><th>Дата</th><th>Статус</th><th>Состав заказа</th><th>Кол-во</th><th>Цена за 1 ед.</th><th>Общая сумма</th></tr>
[+ShopHistory+]
</table>
Общая стоимость всех заказов: [+SummaOrder+] руб.
