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');
}
