Код
Код: Выделить всё
$sql = "CREATE TEMPORARY TABLE `temp`
SELECT t2.id_orders,t1.total_sum FROM order_service_product as t2
JOIN orders AS t1
ON t1.id = t2.id_orders
AND t1.data_begin BETWEEN DATE_FORMAT(\"2018-06-20\", \"%Y-%m-%d\")
AND DATE_FORMAT(\"2018-06-22\", \"%Y-%m-%d\")
WHERE t2.id_services IS NULL GROUP by t2.id_orders; SELECT SUM(temp.total_sum)total_sum from temp;";
$count = Yii::$app->db->createCommand($sql)->queryAll();
PDOException: SQLSTATE[HY000]: General error in D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\db\Command.php:1156
Stack trace:
#0 [internal function]: PDOStatement->fetchAll(2)
#1 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\db\Command.php(1156): call_user_func_array(Array, Array)
#2 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\db\Command.php(399): yii\db\Command->queryInternal('fetchAll', 2)
#3 D:\OSPanel\domains\bloknotapp\models\Services.php(109): yii\db\Command->queryAll()
#4 D:\OSPanel\domains\bloknotapp\views\report\tbl_services.php(20): app\models\Services->getReceiptForServicesByTime('2018-06-22', '2018-06-24')
#5 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\View.php(336): require('D:\\OSPanel\\doma...')
#6 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\View.php(254): yii\base\View->renderPhpFile('D:\\OSPanel\\doma...', Array)
#7 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\web\View.php(212): yii\base\View->renderFile('D:\\OSPanel\\doma...', Array, Object(app\controllers\ReportController))
#8 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\web\Controller.php(49): yii\web\View->renderAjax('tbl_services', Array, Object(app\controllers\ReportController))
#9 D:\OSPanel\domains\bloknotapp\controllers\ReportController.php(121): yii\web\Controller->renderAjax('tbl_services', Array)
#10 [internal function]: app\controllers\ReportController->actionReportServices()
#11 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array)
#12 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#13 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\Module.php(528): yii\base\Controller->runAction('report-services', Array)
#14 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('report/report-s...', Array)
#15 D:\OSPanel\domains\bloknotapp\vendor\yiisoft\yii2\base\Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#16 D:\OSPanel\domains\bloknotapp\web\index.php(14): yii\base\Application->run()
#17 {main}