function edit_sale($id) { $loguser = $_SESSION['user_id']; $sale_select = App\sale::where('id', $id)->first(); $row = $sale_select; if ($_POST['status'] != $row->status) { $sql_status = "INSERT INTO `status_history`(`sales_id`, `new_status`, `old_status`,`changed_by`) VALUES ('{$id}','{$_POST['status']}','{$row['status']}','{$loguser}')"; DB::insert(DB::raw($sql_status)); } $sql = "UPDATE `sales` SET `status`='{$_POST['status']}' , `date`='{$_POST['date']}' , `remark`='{$_POST['remark']}' ,`group_id`='{$_POST['group_id']}' , `assignedto`='{$_POST['assignedto']}' ,`modified_by`='{$loguser}',`modified_time`=SYSDATE(), `total`='{$_POST['sub_total']}' WHERE `id` = '{$id}' "; DB::update(DB::raw($sql)); //$log = new crm_log; //$log->add_log("sales",$id,"update"); // add a log $sql5 = "DELETE FROM `sales_product` WHERE `sale_id` = '{$id}'"; DB::delete(DB::raw($sql5)); $sql4 = "SELECT * FROM `cart` WHERE `user` = '{$loguser}' "; $cart_details = DB::select(DB::raw($sql4)); foreach ($cart_details as $row4) { // select data from cart table $sql5 = "INSERT INTO `sales_product`(`id`, `category`, `product`,`price`,`sale_id`, `qty`, `tax`, `discount`) VALUES(NULL,'{$row4->category}','{$row4->product}','{$row4->price}','{$id}','{$row4->qty}','{$row4->tax}','{$row4->discount}')"; DB::insert(DB::raw($sql5)); // add data to sales product table $sql5 = "DELETE FROM `cart` WHERE `user` = '{$loguser}'"; DB::insert(DB::raw($sql5)); // delete data from cart } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { session_start(); $log = new Log(); $data = Request::all(); $loguser = $_SESSION['user_id']; $call_log_detials = App\call_log::where('deleted', '0')->find($id); if ($call_log_detials->call_type == "Sales") { $sales_detail = App\sale::where('call_log_id', $id)->first(); $row = $sales_detail; if ($_POST['status'] != $row->status) { $data_status = ['sales_id' => $row->id, 'new_status' => $data['status'], 'old_status' => $row->status, 'changed_by' => $loguser]; App\status_history::create($data_status); } $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $data['modified_by'] = $loguser; App\sale::find($row->id)->update($data); $log->add_log("sales", $row->id, "update"); // add a log id must change } elseif ($call_log_detials->call_type == "Inquiry") { $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $inquiry_detail = App\inquiry::where('call_log_id', $id)->first(); $row = $inquiry_detail; if ($data['status'] == "complete") { $endtime = date('Y-m-d H:i:s'); } else { $endtime = NULL; } $data['inquiry_end_time'] = $endtime; App\inquiry::find($row->id)->update($data); $log->add_log("inquiry", $row->id, "update"); // add a log } elseif ($call_log_detials->call_type == "Tickets") { $data_call_log = ['call_modified_by' => $loguser, 'assignedto' => $data['assignedto'], 'group_id' => $data['group_id']]; App\call_log::find($id)->update($data_call_log); $log->add_log("call_log", $id, "update"); // add a log $ticket_detail = App\ticket::where('call_log_id', $id)->first(); $row = $ticket_detail; $data['modified_by'] = $loguser; App\ticket::find($row->id)->update($data); $log->add_log("ticket", $row->id, "update"); // add a log if ($data['problem'] != '') { $data_ticket_problem = ['ticket_id' => $row->id, 'problem' => $data['problem'], 'owner' => $loguser]; App\ticket_problem::create($data_ticket_problem); } } return redirect('call_log'); }