/** * 参数必须严格按照格式要求输入,不然不插入数据而且还不报错 * @param string $category [description] * @param string $reference [description] * @param string $val [description] * @param boolean $update_plus_one [description] * @return [type] [description] */ public static function handleData($category, $reference, $val = 'SYSTEM') { $dic_id = $category . ":" . $reference; $dictionary = Dictionary::findOne($dic_id); if (is_null($dictionary)) { self::insertLine($category, $reference, $val); } else { if ($val == 'SYSTEM') { $connection = \Yii::$app->db; $command = $connection->createCommand('UPDATE ' . self::tableName() . ' SET auto= auto + 1 WHERE dic_id = "' . $dic_id . '"'); $command->execute(); } else { if ($dictionary->val != 'SYSTEM') { $dictionary->val = $val; $dictionary->save(); } } } }
/** * start MPDF */ protected function createMpdf($view, $isfac = false) { $data = Yii::$app->request->get(); if (isset($data['order_id'])) { $order_id = $data['order_id']; $connection = \Yii::$app->db; $command = $connection->createCommand('SELECT * FROM orders WHERE order_id=' . $order_id); $order = $command->queryOne(); $user = $connection->createCommand('SELECT * FROM customer WHERE id =' . $order['action_user'])->queryOne(); $ordergoods = $connection->createCommand('SELECT * FROM order_goods WHERE order_id =' . $order_id)->queryAll(); if ($isfac && $order['fac_no'] == 0) { Dictionary::handleData("system", "factory_no"); $dic = Dictionary::findOne("system:factory_no"); $fac_no = $dic->auto; $order_model = Orders::findOne($order_id); $order_model->fac_no = $fac_no; $order_model->save(); $order['fac_no'] = $fac_no; } $mpdf = new Pdf(); $header = $this->renderPartial('mpdf/header', ['title' => 'nagoya']); $footer = $this->renderPartial('mpdf/footer'); $mpdf->setHeader($header); //设置PDF页眉内容 $mpdf->setFooter($footer); //设置PDF页脚内容 $content = $this->renderPartial($view, ['order' => $order, 'ordergoods' => $ordergoods, 'user' => $user]); $mpdf->Output($content); exit; } else { echo "缺少参数"; exit; } }