public static function getBookingno() { $booking_no = OrderService::createOrderno(); $booking_count = MemberBooking::find()->where(['booking_no' => $booking_no])->count(); if ($booking_count > 0) { return OrderService::getBookingno(); } else { return $booking_no; } }
public function actionUpdateProductCheckInventory() { $this->setauth(); //检查有无权限 $p_db = Yii::app()->p_db; $code = isset($_POST['code']) ? $_POST['code'] : ''; $name = isset($_POST['name']) ? $_POST['name'] : ''; $status = isset($_POST['status']) ? $_POST['status'] : ''; $inventory_old = isset($_POST['inventory_old']) ? $_POST['inventory_old'] : ''; $inventory = isset($_POST['inventory']) ? $_POST['inventory'] : ''; $time = date('Y-m-d H:i:s', time()); $this_user_name = Yii::app()->user->name; $flag = 0; if ($code != '') { $transaction = $p_db->beginTransaction(); try { $check_code = OrderService::createOrderno(); //新增盘点记录 $sql = "INSERT INTO `vcos_product_check` (check_code,check_time,check_type,check_people) VALUES ('{$check_code}','{$time}','{$status[0]}','{$this_user_name}')"; Yii::app()->p_db->createCommand($sql)->execute(); for ($i = 0; $i < count($code); $i++) { $sql = "INSERT INTO `vcos_product_check_detail` (check_code,product_name,inventory_num,check_num,product_code) VALUES ('{$check_code}','{$name[$i]}','{$inventory_old[$i]}','{$inventory[$i]}','{$code[$i]}')"; Yii::app()->p_db->createCommand($sql)->execute(); $sql = "UPDATE `vcos_product` SET inventory_num='{$inventory[$i]}' WHERE product_code='{$code[$i]}'"; Yii::app()->p_db->createCommand($sql)->execute(); } $transaction->commit(); $flag = 1; } catch (Exception $e) { $transaction->rollBack(); $flag = 0; } } if ($flag == 1) { Helper::show_message(yii::t('vcos', '提交成功。'), Yii::app()->createUrl("Product/product_check")); } else { Helper::show_message(yii::t('vcos', '提交失败。'), Yii::app()->createUrl("Product/product_check")); } }