Warning: Cannot use a scalar value as an array in /home/admin/public_html/forum/include/fm.class.php on line 757

Warning: Invalid argument supplied for foreach() in /home/admin/public_html/forum/include/fm.class.php on line 770
Форумы портала PHP.SU :: Версия для печати :: Помогите обьединить запросы
Форумы портала PHP.SU » PHP » SQL и Архитектура БД » Помогите обьединить запросы

Страниц (1): [1]
 

1. sav2907 - 07 Декабря, 2016 - 16:40:51 - перейти к сообщению
PHP:
скопировать код в буфер обмена
  1. $result = $connection->query("select teil, pps, poz from `ZS_v2` where `del` = '0' and `status` != '0' group by teil");
  2. while ($row = mysqli_fetch_assoc($result)) {
  3.  
  4. $count = $connection->query("SELECT a.pps, a.teil, a.poz, a.id, SUM(IF(b.status = 1, b.kilk, 0-b.kilk)) AS quantity FROM `Preproduction`.`ZS_v2` AS a LEFT JOIN `Preproduction`.`ZS_v2` AS b ON b.del != '1' and b.perer ='0' AND b.pps = a.pps WHERE a.del = 0 AND a.status != 0 and a.teil = '$row[teil]' GROUP BY a.pps HAVING quantity > 0");
  5. $result_count = mysqli_num_rows($count);
  6.  
  7. $count2 = $connection->query("SELECT a.pps, a.teil, a.poz, a.id, SUM(IF(b.status = 2, b.kilk, 0-b.kilk)) AS quantity FROM `Preproduction`.`ZS_v2` AS a LEFT JOIN `Preproduction`.`ZS_v2` AS b ON b.del != '1' and b.perer ='1' AND b.pps = a.pps WHERE a.del = 0 AND a.status != 0 and a.teil = '$row[teil]' GROUP BY a.pps HAVING quantity > 0");
  8. $result_count2 = mysqli_num_rows($count2);
  9.  
  10. $result_2 = $connection->query("SELECT SUM(IF(status = 2, kilk, 0-kilk)) AS quantity, SUM(if(status = 2, 1, 0)) - sum(if(status = 0, 1, 0)) as count FROM `Preproduction`.`ZS_v2` WHERE del != '1' and perer ='1' AND teil = '$row[teil]'");  
  11. $row_2 = mysqli_fetch_assoc($result_2);
  12.  
  13. $result_3 = $connection->query("SELECT SUM(IF(status = 1, kilk, 0-kilk)) AS quantity, SUM(if(status = 1, 1, 0)) - sum(if(status = 0, 1, 0)) as count, part FROM `Preproduction`.`ZS_v2` WHERE del != '1' and perer ='0' AND teil = '$row[teil]'");  
  14. $row_3 = mysqli_fetch_assoc($result_3);
  15.  
  16. }

 

Powered by ExBB FM 1.0 RC1