我是 Laravel 的初學者。我在我的項目 Laravel 6 中使用。我有 2 個輸入:<input maxlength="5" type="text" name="hours_worked" class="form-control edited valid" value="" required="" onkeypress="return isNumberKey(event)"><input type="text" name="minutes_worked" class="form-control edited valid" value="" required="" onkeypress="return isNumberKey(event)">我用以下代碼保存到數據庫:WorkingTime::create( $this->request->all()例如,當有人在字段中輸入時,我會遇到問題?!?0”分鐘。我在數據庫中保存了 90 分鐘 - 我想節省 1 小時 30 分鐘。我怎樣才能用我的代碼實現這個目標?我的架構:Schema::create('working_times', function (Blueprint $table) { $table->increments('id'); $table->integer('client_id')->unsigned(); $table->foreign('client_id')->references('id')->on('clients')->onDelete('cascade'); $table->integer('case_id')->unsigned(); $table->foreign('case_id')->references('id')->on('case_instances')->onDelete('cascade'); $table->integer('user_id')->unsigned(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->smallInteger('hours_worked'); $table->smallInteger('minutes_worked'); $table->string('name'); $table->string('appearance')->nullable(); $table->longText('description')->nullable(); $table->softDeletes(); $table->timestamps(); });
1 回答

MYYA
TA貢獻1868條經驗 獲得超4個贊
這是一個粗略的解決方案,但不是這樣做:
WorkingTime::create($this->request->all());
做:
$data = $this->request->all();
$hours = (int) $data['hours_worked'];
$minutes = (int) $data['minutes_worked'];
$overMinutes = $minutes % 60;
$hours += (int) (($minutes - $overMinutes) / 60);
$minutes = $overMinutes;
$data['hours_worked'] = $hours;
$data['minutes_worked'] = $minutes;
WorkingTime::create($data);
- 1 回答
- 0 關注
- 157 瀏覽
添加回答
舉報
0/150
提交
取消