|
|
0 and catalogs_orders.mktime > ".mktime(0, 0, 0, $m_b, 1, date("Y"))." and catalogs_orders.mktime < ".mktime(0, 0, 0, $m_e, 1, date("Y"))."";
}
else
{
$ls_sql="SELECT sum(catalogs_orders_products.count) FROM catalogs_orders_products inner join catalogs_modifications on catalogs_orders_products.product_id = catalogs_modifications.id inner join catalogs_products on catalogs_modifications.product_id = catalogs_products.id inner join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where catalogs_products.rubric_id = $id_1 and catalogs_orders.total <> 0";
}
$result_3 = mysql_query($ls_sql);
$row_3 = mysql_fetch_row($result_3);
$catalog_sum = $row_3[0];
echo $catalog_sum;
?>
|
0 and catalogs_orders.mktime > ".mktime(0, 0, 0, $m_b, 1, date("Y"))." and catalogs_orders.mktime < ".mktime(0, 0, 0, $m_e, 1, date("Y"))."";
}
else
{
$ls_sql="SELECT sum(catalogs_orders.total) FROM catalogs_orders_products inner join catalogs_modifications on catalogs_orders_products.product_id = catalogs_modifications.id inner join catalogs_products on catalogs_modifications.product_id = catalogs_products.id inner join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where catalogs_products.rubric_id = $id_1 and catalogs_orders.total <> 0";
}
$result_4 = mysql_query($ls_sql);
$order_sum = mysql_result($result_4, '0');
echo "Âñåãî: ".$order_sum." ãðí.
Èç íèõ:
";
if(!isset($_REQUEST['oll_orders']))
{
$ls_sql="SELECT catalogs_orders.status, sum(catalogs_orders.total) FROM catalogs_orders_products inner join catalogs_modifications on catalogs_orders_products.product_id = catalogs_modifications.id inner join catalogs_products on catalogs_modifications.product_id = catalogs_products.id inner join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where catalogs_products.rubric_id = $id_1 and catalogs_orders.total <> 0 and catalogs_orders.mktime > ".mktime(0, 0, 0, $m_b, 1, date("Y"))." and catalogs_orders.mktime < ".mktime(0, 0, 0, $m_e, 1, date("Y"))." group by catalogs_orders.status";
}
else
{
$ls_sql="SELECT catalogs_orders.status, sum(catalogs_orders.total) FROM catalogs_orders_products inner join catalogs_modifications on catalogs_orders_products.product_id = catalogs_modifications.id inner join catalogs_products on catalogs_modifications.product_id = catalogs_products.id inner join catalogs_orders on catalogs_orders_products.order_id = catalogs_orders.id where catalogs_products.rubric_id = $id_1 and catalogs_orders.total <> 0 group by catalogs_orders.status";
}
$result_5 = mysql_query($ls_sql);
$num_results_5 = mysql_num_rows($result_5);
for ($k = 0; $k < $num_results_5; $k++)
{
$row_5 = mysql_fetch_array($result_5);
$status = htmlspecialchars(stripcslashes($row_5["status"]));
$order = htmlspecialchars(stripcslashes($row_5["sum(catalogs_orders.total)"]));
status_name($status, &$status_name);
echo $status_name.": ".$order." ãðí.
";
}
?>
|