public function update($id) { $cLog = CollectionLog::find($id); $cLog->update(['status' => 'done']); return redirect()->action('DashboardController@index'); }
public function delivered($id) { $salesInvoice = SalesInvoice::find($id); if ($salesInvoice->Client->payment_terms == "PDC" || $salesInvoice->Client->payment_terms == "PDC 30" || $salesInvoice->Client->payment_terms == "PDC 45" || $salesInvoice->Client->payment_terms == "PDC 60" || $salesInvoice->Client->payment_terms == "PDC 90") { $salesInvoice->update(['status' => "Check on Hand", 'date_delivered' => Carbon::now()]); } else { $salesInvoice->update(['status' => "Delivered", 'date_delivered' => Carbon::now()]); if ($salesInvoice->Client->payment_terms == "Cash") { $salesInvoice->update(['due_date' => Carbon::now()]); } else { if ($salesInvoice->Client->payment_terms == "7 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(7)]); } else { if ($salesInvoice->Client->payment_terms == "15 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(15)]); } else { if ($salesInvoice->Client->payment_terms == "30 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(30)]); } else { if ($salesInvoice->Client->payment_terms == "45 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(45)]); } else { if ($salesInvoice->Client->payment_terms == "60 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(60)]); } else { if ($salesInvoice->Client->payment_terms == "75 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(75)]); } else { if ($salesInvoice->Client->payment_terms == "90 Days") { $salesInvoice->update(['due_date' => Carbon::now()->addDays(90)]); } } } } } } } } } //create 2 collection logs $DueDate_Components = DB::SELECT("SELECT YEAR(due_date) as Year, MONTH(due_date) as Month, DAYOFMONTH(due_date) as Day FROM sales_invoices\n WHERE sales_invoices.id = '{$id}'"); $clientId = $salesInvoice->client_id; $status = $salesInvoice->status; $mondayOf = Carbon::create($DueDate_Components[0]->Year, $DueDate_Components[0]->Month, $DueDate_Components[0]->Day)->startOfWeek()->subweek(); $thusOf = Carbon::create($DueDate_Components[0]->Year, $DueDate_Components[0]->Month, $DueDate_Components[0]->Day)->startOfWeek()->addDays(3); $siclsId = SalesInvoiceCollectionLog::where('sales_invoice_id', $id)->lists('collection_log_id'); foreach ($siclsId as $collectionlogIDs) { $cLog = CollectionLog::find($collectionlogIDs)->delete(); } $cLog = new CollectionLog(); $cLog->date = $mondayOf; $cLog->action = 'Call and Send SOA'; $cLog->client_id = $salesInvoice->client_id; $cLog->status = 'To Do'; $cLog->save(); $sicl = new SalesInvoiceCollectionLog(); $sicl->sales_invoice_id = $id; $sicl->client_id = $cLog->client_id; $sicl->collection_log_id = $cLog->id; $sicl->save(); // $collectionToDo = new SalesInvoiceCollectionLog; $cLog2 = new CollectionLog(); $cLog2->date = $thusOf; $cLog2->action = 'Confirm Collection'; $cLog2->client_id = $salesInvoice->client_id; $cLog2->status = 'To Do'; $cLog2->save(); $sicl2 = new SalesInvoiceCollectionLog(); $sicl2->sales_invoice_id = $id; $sicl2->client_id = $cLog2->client_id; $sicl2->collection_log_id = $cLog2->id; $sicl2->save(); Activity::log('Sales Invoice ' . $salesInvoice['si_no'] . ' was delivered'); return redirect()->action('SalesInvoicesController@index'); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id, $client_id) { $sicls = SalesInvoiceCollectionLog::where('sales_invoice_collection_logs.collection_log_id', $id)->delete(); $cLog = CollectionLog::find($id); $cLog->delete(); return redirect()->action('CollectionLogsController@index', [$client_id]); }