|
Ìåòêà
|
Çàêàçîâ, øò.
|
Íà ñóììó, ãðí.
|
Çàêàçàíî òîâàðîâ, øò.
|
Óíèêàëüíûõ òîâàðîâ, øò.
|
".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and label = $label order by id";
$result_1 = mysql_query($ls_sql);
$mysql_fetch_1 = mysql_result($result_1, '0');
$ls_sql = "select total from catalogs_orders where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and label = $label order by id";
$result_1 = mysql_query($ls_sql);
$num_results_1 = mysql_num_rows($result_1);
$ls_sql = "select product_id from catalogs_orders_products left join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and catalogs_orders.label = $label";
$result_2 = mysql_query($ls_sql);
$num_results_2 = mysql_num_rows($result_2);
$ls_sql = "select product_id from catalogs_orders_products left join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and catalogs_orders.label = $label group by catalogs_orders_products.product_id";
$result_3 = mysql_query($ls_sql);
$num_results_3 = mysql_num_rows($result_3);
status_name($label, &$status_name);
if (empty($mysql_fetch_1))
{
$mysql_fetch_1 = 0;
}
echo "| ".$status_name." | ". $num_results_1." | ".$mysql_fetch_1." | ". $num_results_2 ." | ". $num_results_3." | ";
$all_num_results_1 = $all_num_results_1 + $num_results_1;
$all_mysql_fetch_1 = $all_mysql_fetch_1 + $mysql_fetch_1;
?>
".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))."";
$result_2 = mysql_query($ls_sql);
$num_results_2 = mysql_num_rows($result_2);
$ls_sql = "select product_id from catalogs_orders_products left join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." group by catalogs_orders_products.product_id";
$result_3 = mysql_query($ls_sql);
$num_results_3 = mysql_num_rows($result_3);
echo "| Âñåãî: | ". $all_num_results_1." | ".$all_mysql_fetch_1." | ". $num_results_2 ." | ". $num_results_3." | ";
?>
|
|
Ïðè÷èíà
|
Çàêàçîâ, øò.
|
Íà ñóììó, ãðí.
|
";
cause_number($i, &$cause_number);
$ls_sql = "select sum(total) from catalogs_orders where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and cause = $cause_number and label = 9 order by id";
$result_1 = mysql_query($ls_sql);
$mysql_fetch_1 = mysql_result($result_1, '0');
$ls_sql = "select total, id from catalogs_orders where mktime > ".mktime(0, 0, 0, $m_b, $da_b, date("Y"))." and mktime < ".mktime(0, 0, 0, $m_e, $da_e, date("Y"))." and cause = $cause_number and label = 9 order by id";
$result_1 = mysql_query($ls_sql);
$num_results_1 = mysql_num_rows($result_1);
cause_name($cause_number, &$cause_name);
$all_num_results_1 = $all_num_results_1 + $num_results_1;
$all_mysql_fetch_1 = $all_mysql_fetch_1 + $mysql_fetch_1;
echo "".$cause_name." | ". $num_results_1." | ".$mysql_fetch_1." | ";
echo "";
}
echo "| Âñåãî: | ". $all_num_results_1." | ".$all_mysql_fetch_1." | ";
?>
|