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())]];
}
