/** * Execute the job. * * @return void */ public function handle() { //Log::info("Handle Purchase Count Job ".$this->tanggal); $tanggal = $this->tanggal; $pembelian = PembelianBayar::where("tanggal", $tanggal)->select([DB::raw("SUM(nominal)total")])->groupBy("tanggal")->first(); if ($pembelian) { $total = $pembelian->total; if ($total >= 1) { $account = AccountSaldo::where('tanggal', $tanggal)->where('account_id', 1)->first(); if (!$account) { //create new AccountSaldo::create(['tanggal' => $tanggal, 'account_id' => 1, 'type' => 'kredit', 'nominal' => $total]); } else { // update value if ($account->nominal != $total) { AccountSaldo::find($account->id)->update(['nominal' => $total]); } } } } //Log::info("Handle Purchase Count Job ".$pembelian->total); }