public function actionView() { $id = (int) Yii::$app->request->get('id'); $card = Card::findOne(['id' => $id]); $serial = Serial::findOne(['id' => $card->serial_id]); return $this->render('view', ['card' => $card, 'serial' => $serial]); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { if (!empty($request->path())) { $demand = new Demand(); //需求编号需要一个生成规则,日期+流水号 // $demand_no = date("Ymd",strtotime("now")).'-'.'A'.'001'; $cur_serial_key = date("Ymd", strtotime("now")); $cur_serial = DB::table('serial')->where('serial_key', $cur_serial_key)->get(); if (empty($cur_serial)) { $serial = new Serial(); $serial->serial_key = date("Ymd", strtotime("now")); $serial->serial_value = 1; $serial->save(); $demand_no = date("Ymd", strtotime("now")) . '-' . 'A' . '001'; } else { $cur_serial_value = $cur_serial[0]->serial_value + 1; if ($cur_serial_value < 10) { $cur_serial_value_str = 'A00' . $cur_serial_value; } if ($cur_serial_value >= 10 && $cur_serial_value < 100) { $cur_serial_value_str = 'A0' . $cur_serial_value; } if ($cur_serial_value > 100) { $cur_serial_value_str = 'A' . $cur_serial_value; } $demand_no = $cur_serial[0]->serial_key . '-' . $cur_serial_value_str; Serial::where('id', $cur_serial[0]->id)->update(['serial_value' => $cur_serial_value]); } $demand->demand_no = $demand_no; $demand->demand_name = $request->demand_name; $demand->acceptance = $request->acceptance; $demand->comment = $request->comment; $demand->status = $request->status; // print_r($demand->toArray()); // Log::info('执行'.time()); $demand->save(); return $demand->toJson(); // die; } }
public function studentPdf(Request $request) { $post = $request->all(); $user = $post['student']; $std = student::where('studentNo', '=', $user)->first(); $charge = charges::where('students_studentNo', '=', $user)->first(); $serial = Serial::where('students_studentNo', '=', $user)->first(); if ($charge->total == 0) { $html = PDF::make($std, $serial); } else { $html = PDF::create($std, $charge, $serial); } $mpdf = new mpdf(); $mpdf->WriteHTML($html); $mpdf->Output(); }
public function up() { $tableOptions = null; if ($this->db->driverName === 'mysql') { $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB'; } // * серия карты // * номер карты // * дата выпуска карты // * дата окончания активности карты // * дата использования // * сумма // * статус карты (не активирована/активирована/просрочена) $this->createTable('{{%serial}}', ['id' => $this->primaryKey(), 'serial' => $this->string(20)->notNull(), 'release_date' => $this->dateTime()->notNull(), 'duration' => "enum ('" . implode("','", array_keys(Serial::getDurations())) . "') not null"], $tableOptions); $this->createIndex('serial_uniq', '{{%serial}}', ['serial'], true); $this->createTable('{{%card}}', ['id' => $this->primaryKey(), 'serial_id' => $this->integer()->notNull(), 'number' => $this->integer()->notNull(), 'begin_date' => $this->dateTime()->defaultValue(null), 'end_date' => $this->dateTime()->defaultValue(null), 'amount' => $this->money()->notNull()->defaultValue(0), 'status' => "enum ('" . implode("','", array_keys(Card::getStatuses())) . "') not null default '" . Card::STATUS_NEW . "'"], $tableOptions); $this->createIndex('serial_number_uniq', '{{%card}}', ['serial_id', 'number'], true); $this->addForeignKey('FK_card_serial', '{{%card}}', 'serial_id', '{{%serial}}', 'id'); }
</h2> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($formModel, 'serial'); ?> <?php echo $form->field($formModel, 'quantity'); ?> <?php echo $form->field($formModel, 'duration')->dropDownList(Serial::getDurations()); ?> <div class="form-group"> <?php echo Html::submitButton('Save', ['class' => 'btn btn-primary']); ?> <span style="margin-left: 10px;"> <?php echo HTML::a('Отменить', Yii::$app->getUser()->getReturnUrl()); ?> </span> </div> <?php ActiveForm::end();
public function rules() { return [[['id', 'number'], 'integer'], ['serialSerial', 'string', 'max' => 20], [['serialReleaseDate', 'begin_date', 'end_date'], 'date', 'format' => 'y-m-d'], ['status', 'in', 'range' => array_keys(Card::getStatuses())], ['serialDuration', 'in', 'range' => array_keys(Serial::getDurations())]]; }