forum.lissyara.su

Код: Выделить всё

$query = "SELECT menu_id
                      FROM menu
                      WHERE deleted = 0";
            $result = mysql_query($query) or die("Query failed : " . mysql_error());;
            while ($row = mysql_fetch_array($result)){
                   $menu_id = $row['menu_id'];
                   $query2 = "SELECT sum(sales_count) AS sales_count_sum 
                              FROM `sales` 
                              WHERE `user_sale_date` = '".$_POST['user_sale_date']."' 
                              AND menu_id = '$menu_id'
                              AND user_id = '".$_POST['user_id']."'
                              AND deleted = '0'";
                   $result2 = mysql_query($query2) or die("Query failed : " . mysql_error());;
                   $row = mysql_fetch_assoc($result2);
                   $sales_count_sum = $row['sales_count_sum'];
                   if($sales_count_sum == NULL){
                       $sales_count_sum = 0;
                   }
                   $query3 = "INSERT INTO sales_day (sales_day_id, user_id, menu_id, sales_date, sales_count, deleted)
                              VALUES (NULL, '".$_POST['user_id']."',$menu_id,'".$_POST['user_sale_date']."' ,$sales_count_sum, 0)";
                   mysql_query($query3) or die("Query failed : " . mysql_error());
                   $query4 = "UPDATE `sales` 
                              SET closed = '1'
                              WHERE `user_sale_date` = '".$_POST['user_sale_date']."' 
                              AND menu_id = '$menu_id'
                              AND user_id = '".$_POST['user_id']."'
                              AND deleted = '0'";
                   mysql_query($query4) or die("Query failed : " . mysql_error());
            }
            $query5 = "UPDATE users 
                       SET user_sale_date = DATE_ADD('".$_POST['user_sale_date']."', interval 1 day)
                       WHERE user_id = '".$_POST['user_id']."'";
            mysql_query($query5) or die("Query failed : " . mysql_error());