middleware('permission:orders-create', ['only' => ['create']]);
$this->middleware('permission:orders-edit', ['only' => ['edit']]);
$this->middleware('permission:orders-view', ['only' => ['view']]);
$this->middleware('permission:orders-delete', ['only' => ['delete']]);
}
/** construct */
/** index */
public function index(Request $request){
if($request->ajax()){
$data = DB::table('orders as o')
->select('o.id', 'o.order_id', 'o.status' ,'o.obf_id', 'b.name as branch_name','ob.status as obf_status','o.invoice_no','o.invoice_date','ob.customer_name','car_model.name as carmodel','car_varient.name as carvarient',DB::raw("CONCAT(us.first_name,' ',us.last_name) AS kec_name"),'inventory.allocation_count','inventory.aging_days')
->leftjoin('branches as b', 'b.id', 'o.branch_id')
->leftjoin('obf as ob', 'ob.id', 'o.obf_id')
->leftjoin('users','users.id','o.customer_id')
->leftjoin('users as us','us.id','ob.sales_person_id')
->leftjoin('products','products.id','ob.product_id')
->leftjoin('inventory','inventory.id','o.inventory_id')
->leftjoin('car_model','car_model.id','products.car_model')
->leftjoin('car_varient','car_varient.id','products.veriant')
->orderBy('o.id' ,'desc')
->get();
return Datatables::of($data)
->addIndexColumn()
->addColumn('action', function($data){
$return = '';
if(auth()->user()->can('orders-view')){
$return .= '
';
}
$obf_data = DB::table('obf_finance')->select('finance_required')->where('obf_id',$data->obf_id)->first();
$finance_required = 'yes';
if($obf_data)
$finance_required=$obf_data->finance_required;
if($data->status != 'delivered'){
$return .= '
';
$return .= '
";
echo "finance_discount==>".$finance_discount;
echo "
";
echo "net_disbusment==>".$net_disbusment;
echo "
";
echo "trade_car_value==>".$trade_car_value;
echo "
";
echo "cash_receipt_amount==>".$cash_receipt_amount;
echo "
";
echo "on_road_price==>".$on_road_price;
echo "
";
echo "total_amount_get==>".$total_amount_get;
echo "
";
die('stp[');*/
// return redirect()->route('order')->with(['error' => 'Your Payment is Pending!']);
}else{
$update = Order::where(['id' => $id])->update(['status' => $request->status, 'updated_at' => date('Y-m-d H:i:s'), 'updated_by' => auth()->user()->id]);
}
//notification insert
$data = OBF::where(['id' => $id])->first();
$tamplate_name = '';
if($request->status == 'finance_apporve'){
$tamplate_name = 'finance_apporve';
}elseif ($request->status == 'disbursement') {
$tamplate_name = 'disbursement';
}elseif ($request->status == 'all_payment_done') {
$tamplate_name = 'all_payment_done';
}elseif ($request->status == 'cancled') {
$tamplate_name = 'Cancelled';
}elseif ($request->status == 'pdi_approve') {
$tamplate_name = 'pdi_approve';
}elseif ($request->status == 'pdi_reject') {
$tamplate_name = 'pdi_reject';
}
if($tamplate_name != ''){
// DB::enableQueryLog();
$notification_template_master_data = DB::table('notification_template_master')->select('*')->where(['template_name' => $tamplate_name,'status' => 'active'])->first();
// dd(DB::getQueryLog());
// var_dump($notification_template_master_data);
if(!empty($notification_template_master_data)){
$customer_name = $data->customer_name ?? null;
$car_name_get = '';
$product_id = 0;
if($data->product_id != null && $data->product_id != ''){
$product_id = $data->product_id;
}
if($product_id != null){
$Cardata_get = Product::select('car_model.name as car_name','products.id as car_id','car_varient.name as varient_name','exteriorcolor.name as exterior_color', 'interiorcolor.name as interior_color')
->leftjoin('car_model', 'car_model.id', 'products.car_model')
->leftjoin('car_varient', 'car_varient.id', 'products.veriant')
->leftjoin('interiorcolor', 'interiorcolor.id', 'products.interior_color')
->leftjoin('exteriorcolor', 'exteriorcolor.id', 'products.exterior_color')
->where('products.status', '=', 'active')
->where('products.id', '=', $product_id)
->first();
if(!empty($Cardata_get)){
if(!empty($Cardata_get->car_name) && $Cardata_get->car_name != '' && $Cardata_get->car_name != NULL){
$car_name_get .= '('.$Cardata_get->car_name;
$car_name_get .= ' , '.$Cardata_get->varient_name.')';
}
}
}
$customer_name_with_car_detail = '';
if($customer_name != null){
$customer_name_with_car_detail = $customer_name;
}
if($customer_name != null){
$customer_name_with_car_detail .= ' '.$car_name_get;
}
$data_new = str_replace("[customer_name_with_car_detail]",$customer_name_with_car_detail,$notification_template_master_data->template_data);
$notification_data = [
'user_id' => auth()->user()->id,
'notification_text' => $data_new,
'notification_link' => route('obf_approval.view', ['id' => base64_encode($id)]),
'created_by' => auth()->user()->id,
];
DB::table('notifications')->insert($notification_data);
// var_dump($notification_data);
}
}
//notification insert
// die('sss--');
// die('ssss000');
if ($update) {
return response()->json(['code' => 200]);
} else {
return response()->json(['code' => 201]);
}
} else {
return response()->json(['code' => 201]);
}
}
/** change-status */
/** payment_pending_detail */
public function payment_pending_detail(Request $request)
{
$pending_payment_data = [];
if(isset($request->obf_id)){
$finance_discount = 0;
$net_disbusment = 0;
$trade_car_value = 0;
$on_road_price = 0;
$obf_data = OBF::where(['id' => $request->obf_id])->first();
if($obf_data){
$trade_car_value = (int) $obf_data->trade_car_value;
$on_road_price = (int) $obf_data->on_road_price;
}
$finance_data = DB::table('obf_finance')->where(['obf_id' => $request->obf_id])->first();
if($finance_data){
$finance_discount = (int) $finance_data->finance_discount;
$net_disbusment = (int) $finance_data->net_disbusment;
}
$cash_receipt_amount = DB::table('cash_receipt')->where(['obf_id' => $request->obf_id,'status' => 'accepted'])->sum('amount');
$total_amount_get = $finance_discount + $net_disbusment + $trade_car_value + $cash_receipt_amount;
if($total_amount_get >= $on_road_price){
//payment done
$pending_payment_data = array(
'payment_status' => 1
);
}else{
//pending payment
$pending_payment = $on_road_price - $total_amount_get;
$pending_payment_data = array(
'finance_discount' => $finance_discount,
'net_disbusment' => $net_disbusment,
'trade_car_value' => $trade_car_value,
'cash_receipt_amount' => $cash_receipt_amount,
'on_road_price' => $on_road_price,
'total_amount_get' => $total_amount_get,
'pending_payment' => $pending_payment,
'payment_status' => 0
);
}
}
/*echo "";
var_dump($request->obf_id);
var_dump($pending_payment_data);
die('st[p');*/
return view('order.payment_pending_detail')->with(['pending_payment_data' => $pending_payment_data]);
}
/** payment_pending_detail */
/** Create */
public function invoice_create(Request $request)
{
$obf_id = base64_decode($request->id);
$order_id = base64_decode($request->order_id);
$data = OBF::where(['id' => $obf_id])->first();
/*$cash_receipt_data = [];
if(isset($request->cash_receipt_id) && !empty($request->cash_receipt_id)){
$cash_receipt_id = base64_decode($request->cash_receipt_id);
$cash_receipt_data = CashReceipt::where(['id' => $cash_receipt_id])->first();
}*/
//'cash_receipt_data' => $cash_receipt_data
if ($data) {
$finance_name = '';
$finance_discount = '';
$obf_finance = [];
$obf_finance_data = DB::table('obf_finance')->where(['obf_id' => $obf_id])->first();
if($obf_finance_data){
$obf_finance = $obf_finance_data;
$finance_discount = $obf_finance_data->finance_discount;
if($obf_finance->finance_name != NULL && $obf_finance->finance_name > 0){
$finance_data = DB::table('finance')->where(['id' => $obf_finance->finance_name])->first();
$finance_name = $finance_data->name;
}
}
$current_date = Carbon::now()->format('d-m-Y');
$product_name_get = '';
$hsn_code = '';
$tex_master_gst = 1;
$tex_master_compensation_cess = 1;
$product_data_get = Product::select('products.*','car_model.name as car_name', 'exteriorcolor.name as exterior_color', 'interiorcolor.name as interior_color', 'car_varient.name as varient_name' , 'car_varient.hsn_code as hsn_code')
->leftJoin('car_model','car_model.id','=','products.car_model')
->leftJoin('exteriorcolor','exteriorcolor.id','=','products.exterior_color')
->leftJoin('interiorcolor','interiorcolor.id','=','products.interior_color')
->leftJoin('car_varient','car_varient.id','=','products.veriant')
->where('products.status', 'active')
->where('products.id', $data->product_id)
->first();
/* var_dump($product_data_get->car_name);
die('st');*/
if($product_data_get){
$product_name_get = 'Price of One '.$product_data_get->car_name.' ** '.$product_data_get->varient_name.' '.$product_data_get->exterior_color.' '.$product_data_get->interior_color;
$hsn_code = $product_data_get->hsn_code;
$veriant_id = 0;
if($product_data_get->veriant != NULL)
$veriant_id = $product_data_get->veriant;
$Carvarient_data = Carvarient::where(['id' => $veriant_id,'status' => 'active'])->first();
$tex_master_id = 0;
if($Carvarient_data)
$tex_master_id = $Carvarient_data->tex_master_id;
if($tex_master_id > 0){
$Texmaster_data = Texmaster::where(['id' => $tex_master_id,'status' => 'active'])->first();
if($Texmaster_data->gst != null)
$tex_master_gst = $Texmaster_data->gst;
if($Texmaster_data->compensation_cess != null)
$tex_master_compensation_cess = $Texmaster_data->compensation_cess;
}
}
$inventory_data = [];
$inventory_get = DB::table('inventory')->where('id', $data->inventory_id)->first();
if($inventory_get){
$inventory_data = $inventory_get;
}
$orders_data = [];
$orders_data_get = DB::table('orders')->where('id', $order_id)->first();
if($orders_data_get){
$orders_data = $orders_data_get;
}
return view('order.invoice_create')->with(['inventory_data' => $inventory_data,'product_name_get' => $product_name_get,'current_date' => $current_date,'finance_name' => $finance_name,'finance_discount' => $finance_discount,'hsn_code' => $hsn_code,'orders_data' => $orders_data,'data' => $data,'order_id' => $order_id,'tex_master_gst' => $tex_master_gst,'tex_master_compensation_cess' => $tex_master_compensation_cess]);
} else {
return view('order.invoice_create')->with('error', 'No record found!');
}
}
/** Create */
/** edit */
public function invoice_edit(Request $request)
{
$obf_id = base64_decode($request->id);
$order_id = base64_decode($request->order_id);
$orders_data = [];
$orders_data_get = DB::table('orders')->where('id', $order_id)->first();
if($orders_data_get){
$orders_data = $orders_data_get;
}
$tex_master_gst = 1;
$tex_master_compensation_cess = 1;
$data = OBF::where(['id' => $obf_id])->first();
if($data){
$product_data_get = Product::select('products.*')
->where('products.status', 'active')
->where('products.id', $data->product_id)
->first();
$veriant_id = 0;
if($product_data_get->veriant != NULL)
$veriant_id = $product_data_get->veriant;
$Carvarient_data = Carvarient::where(['id' => $veriant_id,'status' => 'active'])->first();
$tex_master_id = 0;
if($Carvarient_data)
$tex_master_id = $Carvarient_data->tex_master_id;
if($tex_master_id > 0){
$Texmaster_data = Texmaster::where(['id' => $tex_master_id,'status' => 'active'])->first();
if($Texmaster_data->gst != null)
$tex_master_gst = $Texmaster_data->gst;
if($Texmaster_data->compensation_cess != null)
$tex_master_compensation_cess = $Texmaster_data->compensation_cess;
}
}
if ($orders_data) {
return view('order.invoice_edit')->with(['orders_data' => $orders_data,'tex_master_gst' => $tex_master_gst,'tex_master_compensation_cess' => $tex_master_compensation_cess]);
} else {
return view('order.invoice_edit')->with('error', 'No record found!');
}
}
/** edit */
/** insert */
public function insert(Request $request){
if($request->ajax()) { return true; }
$id = $request->order_id;
$obf_id = $request->id;
$crud = [
'dealer_gst' => $request->dealer_gst,
'dealer_pan_number' => $request->dealer_pan_number,
'bill_to' => $request->bill_to,
'address' => $request->address,
'ship_to' => $request->ship_to,
'finance_name' => $request->finance_name,
'customer_gst' => $request->customer_gst ?? null,
'customer_id' => $request->customer_id,
'invoice_no' => $request->invoice_no,
'phone_no' => $request->phone_no,
'pan_number' => $request->pan_number,
'place_of_supply' => $request->place_of_supply,
'product_name' => $request->product_name,
'on_road_price' => $request->on_road_price,
'discount' => $request->discount,
'selling_price' => $request->selling_price,
'cgst' => $request->cgst,
'sgst' => $request->sgst,
'compensation_cess' => $request->compensation_cess,
'total' => $request->total,
'tcs_tax' => $request->tcs_tax,
'grand_total' => $request->grand_total,
'vin_number' => $request->vin_number,
'chassis_number' => $request->chassis_number,
'engine_number' => $request->engine_number,
'key_number' => $request->key_number,
'hsn_code' => $request->hsn_code,
'status' => 'pdi_approve',
'updated_by' => auth()->user()->id,
'updated_at' => date('Y-m-d H:i:s')
];
/* echo "";
print_r($crud);
die('st');*/
if($request->invoice_date != '' && $request->invoice_date != NULL){
$crud['invoice_date'] = date("Y-m-d",strtotime($request->invoice_date));
}
// \DB::enableQueryLog();
$update = Order::where(['id' => $id])->update($crud);
// dd(DB::getQueryLog());
// die('stop');
if ($update){
return redirect()->route('order.invoice_pdf', ['id' => base64_encode($obf_id),'order_id' => base64_encode($id)]);
// return redirect()->route('order')->with(['success' => 'Invoice Create successfully']);
}else{
return redirect()->back()->with(['error'=>'Faild Invoice Create!'])->withInput();
}
}
/** insert */
/** update */
public function update(Request $request){
if($request->ajax()) { return true; }
$id = $request->order_id;
$obf_id = $request->id;
$crud = [
'bill_to' => $request->bill_to,
'address' => $request->address,
'ship_to' => $request->ship_to,
'updated_by' => auth()->user()->id,
'updated_at' => date('Y-m-d H:i:s')
];
// \DB::enableQueryLog();
$update = Order::where(['id' => $id])->update($crud);
// dd(DB::getQueryLog());
// die('stop');
if ($update){
// $this->invoice_pdf($request);
return redirect()->route('order.invoice_pdf', ['id' => base64_encode($obf_id),'order_id' => base64_encode($id)]);
}else{
return redirect()->back()->with(['error'=>'Faild Invoice Create!'])->withInput();
}
}
/** update */
// this function directly downloads the PDF.
public function pdf_sample()
{
// die('stp[');
ini_set('memory_limit', '2048M');
$html_content = 'Generate a PDF using TCPDF in laravel
by
Learn Infinity
';
PDF::SetTitle('Sample PDF');
PDF::AddPage();
PDF::writeHTML($html_content, true, false, true, false, '');
/*$guest_view = \View::make('pdf/guest_pdf', ['site_details'=>$site_details]);
PDF::writeHTML($html_content, true, false, true, false, '');
/*$guest_view = \View::make('guest_pdf', ['site_details'=>$site_details]);
$guest_html = $guest_view->render();
$heading_title = "Guest Post";
PDF::AddPage('P','A4');
PDF::SetFont('dejavusans', '', 10);
PDF::SetTextColor(0, 0, 0);
PDF::setCellPaddings(0, 1.5, 0, 1.5);
PDF::SetLeftMargin(7);
PDF::writeHTML($guest_html, true, false, true, false, '');*/
//PDF::Output(uniqid().'_SamplePDF.pdf', 'D');
PDF::Output(uniqid().'_SamplePDF.pdf');
}
public function invoice_pdf(Request $request)
{
/*$path = public_path('assets\img\kia.jpg');
var_dump($path);
die('stp');*/
ini_set('memory_limit', '2048M');
$obf_id = base64_decode($request->id);
$order_id = base64_decode($request->order_id);
$orders_data = [];
$orders_data_get = DB::table('orders')->where('id', $order_id)->first();
if($orders_data_get){
$orders_data = $orders_data_get;
}
// var_dump($orders_data->dealer_gst);
PDF::SetAuthor('Nicola Asuni');
PDF::SetTitle('Invoice');
PDF::SetSubject('Invoice');
PDF::setImageScale(PDF_IMAGE_SCALE_RATIO);
PDF::AddPage();
PDF::Image(public_path('assets/img/kia.jpg'), 16, 11, 40, 10, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
PDF::SetFont('freeserif', '', 8);
PDF::SetTextColor(50, 50, 50);
$content = "Savan IB Automotive Private Limited";
PDF::SetXY(80, 12);
PDF::Cell(0, 0, $content);
$content = "Savan IB Cars Pvt Ltd, Revenue Survey";
PDF::SetXY(79, 15);
PDF::Cell(0, 0, $content);
$content = "No. 41/1. Gondal Ahmedabad By-Pass Circle, Gondal Road,";
PDF::SetXY(68, 18);
PDF::Cell(0, 0, $content);
$content = "NH-88, At: Village Vavdi, Rajkot, 360004";
PDF::SetXY(78, 21);
PDF::Cell(0, 0, $content);
$content = "Ph.: 72280 80803";
PDF::SetXY(88, 25);
PDF::Cell(0, 0, $content);
$content = "GST No./PAN No.: ".$orders_data->dealer_gst."/".$orders_data->dealer_pan_number;
PDF::SetXY(70, 28);
PDF::Cell(0, 0, $content);
$content = "IRN No.:";
PDF::SetXY(50, 32);
PDF::Cell(0, 0, $content);
PDF::SetXY(10, 39);
$customer_gst_label = '';
$customer_gst = '';
$customer_gst_dot = '';
if($orders_data->customer_gst != NULL){
$customer_gst_label = 'Customer GST No.';
$customer_gst = $orders_data->customer_gst;
$customer_gst_dot = ':';
}
$tbl = '
| Vehicle Tax Invoice |
| Dealer GST / PAN No |
: |
24ABACS4515J1ZH/ABACS4515J |
'.$customer_gst_label.' |
'.$customer_gst_dot.' |
'.$customer_gst.' |
| Bill To |
: |
'.$orders_data->bill_to.' |
Customer Id |
: |
'.$orders_data->customer_id.' |
| Address |
: |
'.$orders_data->address.' |
Invoice No |
: |
'.$orders_data->invoice_no.' |
|
|
Invoice Date |
: |
'.date("d/m/Y",strtotime($orders_data->invoice_date)).' |
|
|
Phone No |
: |
'.$orders_data->phone_no.' |
| Ship To |
: |
'.$orders_data->ship_to.' |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PAN No |
: |
'.$orders_data->pan_number.' |
| Financed by/Hypo. by |
: |
'.$orders_data->finance_name.' |
Place of Supply |
: |
GUJARAT |
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::SetXY(10, 110);
$tbl = '
| PARTICULARS |
AMOUNT(Rs) |
| 1) '.$orders_data->product_name.' |
'.$orders_data->on_road_price.' |
| 2) Discount |
'.$orders_data->discount.' |
| 3) Net Selling Price |
'.$orders_data->selling_price.' |
| 4.1) CGST 14 % |
'.$orders_data->cgst.' |
| 4.2) SGST 14 % |
'.$orders_data->sgst.' |
| 4.3) Compensation Cess 20 % |
'.$orders_data->compensation_cess.' |
| TOTAL |
'.$orders_data->total.' |
| TCS @1% |
'.$orders_data->tcs_tax.' |
| GRAND TOTAL |
'.$orders_data->grand_total.' |
';
/*
|
0.00 |
*/
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::SetFont('freeserif', '', 10);
$content = "Vehicle Particulars";
PDF::SetXY(15, 200);
PDF::Cell(0, 0, $content);
PDF::SetXY(10, 205);
$tbl = '
Vin No.
'.$orders_data->vin_number.' |
Chassis No.
'.$orders_data->chassis_number.' |
Engine No.
'.$orders_data->engine_number.' |
Key No.
'.$orders_data->key_number.' |
HSN No
'.$orders_data->hsn_code.' |
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::SetFont('freeserif', '', 8);
$content = "“Terms & condition apply “";
PDF::SetXY(15, 225);
PDF::Cell(0, 0, $content);
PDF::SetFont('freeserif', '', 12);
$content = "Applied Promotion:";
PDF::SetXY(15, 230);
PDF::Cell(0, 0, $content);
PDF::SetFont('freeserif', '', 12);
$content = "For Savan IB Automotive Private Limited";
PDF::SetXY(110, 235);
PDF::Cell(0, 0, $content);
PDF::SetXY(10, 265);
$tbl = '
| Signature of Customer |
|
Authorised Signatory |
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::Output('example_009.pdf', 'I');
}
public function get_pass_pdf(Request $request)
{
ini_set('memory_limit', '48M');
/* PDF::setFooterCallback(function($pdf)
{
PDF::SetFont('dejavusansb', '', 15);
PDF::SetTextColor(50, 50, 50);
$content = "Savan IB Automotive Private Limited";
PDF::SetXY(20, 275);
PDF::Cell(0, 0, $content);
PDF::Image(public_path('assets/img/logo.jpg'), 130, 273, 20, 12, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
PDF::SetFont('dejavusans', '', 10);
PDF::SetTextColor(50, 50, 50);
$content = "No. 41/1. Gondal Ahmedabad By-Pass Circle, Gondal Road, NH-88, At: Village Vavdi, Rajkot, 360004";
PDF::SetXY(20, 285);
PDF::Cell(0, 0, $content);
});*/
$obf_id = base64_decode($request->id);
$order_id = base64_decode($request->order_id);
$crud = [
'status' => 'ready_to_deliver',
'updated_by' => auth()->user()->id,
'updated_at' => date('Y-m-d H:i:s')
];
$update = Order::where(['id' => $order_id])->update($crud);
$data = OBF::where(['id' => $obf_id])->first();
//notification insert
$notification_template_master_data = DB::table('notification_template_master')->select('*')->where(['template_name' => 'gate_gass_create','status' => 'active'])->first();
if(!empty($notification_template_master_data)){
$customer_name = $data->customer_name ?? null;
$car_name_get = '';
$product_id = 0;
if($data->product_id != null && $data->product_id != ''){
$product_id = $data->product_id;
}
if($product_id != null){
$Cardata_get = Product::select('car_model.name as car_name','products.id as car_id','car_varient.name as varient_name','exteriorcolor.name as exterior_color', 'interiorcolor.name as interior_color')
->leftjoin('car_model', 'car_model.id', 'products.car_model')
->leftjoin('car_varient', 'car_varient.id', 'products.veriant')
->leftjoin('interiorcolor', 'interiorcolor.id', 'products.interior_color')
->leftjoin('exteriorcolor', 'exteriorcolor.id', 'products.exterior_color')
->where('products.status', '=', 'active')
->where('products.id', '=', $product_id)
->first();
if(!empty($Cardata_get)){
if(!empty($Cardata_get->car_name) && $Cardata_get->car_name != '' && $Cardata_get->car_name != NULL){
$car_name_get .= '('.$Cardata_get->car_name;
$car_name_get .= ' , '.$Cardata_get->varient_name.')';
}
}
}
$customer_name_with_car_detail = '';
if($customer_name != null){
$customer_name_with_car_detail = $customer_name;
}
if($customer_name != null){
$customer_name_with_car_detail .= ' '.$car_name_get;
}
$data_new = str_replace("[customer_name_with_car_detail]",$customer_name_with_car_detail,$notification_template_master_data->template_data);
$notification_data = [
'user_id' => auth()->user()->id,
'notification_text' => $data_new,
'notification_link' => route('obf_approval.view', ['id' => base64_encode($obf_id)]),
'created_by' => auth()->user()->id,
];
DB::table('notifications')->insert($notification_data);
}
//notification insert
/*var_dump($order_id);
die('s');*/
$orders_data = [];
$orders_data_get = DB::table('orders')->where('id', $order_id)->first();
if($orders_data_get){
$orders_data = $orders_data_get;
}
$obf_data = [];
$obf_data_get = DB::table('obf')->where('id', $obf_id)->first();
if($obf_data_get){
$obf_data = $obf_data_get;
}
$product_id = isset($obf_data->product_id) ? $obf_data->product_id : 0;
$sales_person_id = isset($obf_data->sales_person_id) ? $obf_data->sales_person_id : 0;
$varient_name = '';
$color_name = '';
if($product_id > 0){
$product_data_get = Product::select('products.*','car_model.name as car_name', 'exteriorcolor.name as exterior_color', 'interiorcolor.name as interior_color', 'car_varient.name as varient_name')
->leftJoin('car_model','car_model.id','=','products.car_model')
->leftJoin('exteriorcolor','exteriorcolor.id','=','products.exterior_color')
->leftJoin('interiorcolor','interiorcolor.id','=','products.interior_color')
->leftJoin('car_varient','car_varient.id','=','products.veriant')
->where('products.status', 'active')
->where('products.id', $obf_data->product_id)
->first();
$product_data = [];
if($product_data_get){
$product_data = $product_data_get;
}
$varient_name = isset($product_data->varient_name) ? $product_data->varient_name : '';
$exterior_color = isset($product_data->exterior_color) ? $product_data->exterior_color : '';
$interior_color = isset($product_data->interior_color) ? $product_data->interior_color : '';
$color_name = $exterior_color.' | '.$interior_color;
}
$sales_person_name = '';
$sales_person_contact_number = '';
if($sales_person_id > 0){
$user_data = [];
$user_data_get = DB::table('users')->select('id' , 'contact_number' , DB::raw("CONCAT(first_name,' ',last_name) AS sales_person_name"))->where(['status' => 'active','id' => $obf_data->sales_person_id])->first();
if($user_data_get){
$user_data = $user_data_get;
}
$sales_person_name = isset($user_data->sales_person_name) ? $user_data->sales_person_name : '';
$sales_person_contact_number = isset($user_data->contact_number) ? $user_data->contact_number : '';
}
PDF::SetAuthor('Nicola Asuni');
PDF::SetTitle('Gate Pass');
PDF::SetSubject('Gate Pass');
PDF::setImageScale(PDF_IMAGE_SCALE_RATIO);
PDF::AddPage();
//PDF::Image(public_path('assets/img/logo.jpg'), 15, 18, 20, 12, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
PDF::Image(public_path('assets/img/new_kia.jpg'), 150, 11, 50, 19, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
PDF::Image(public_path('assets/img/ib_logo.jpeg'), 10, 11, 100, 15, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
/*PDF::SetFont('dejavusansb', '', 20);
PDF::SetTextColor(50, 50, 50);
$content = "MARUTI SUZUKI";
PDF::SetXY(35, 20);
PDF::Cell(0, 0, $content);
PDF::SetFont('dejavusans', '', 20);
PDF::SetTextColor(50, 50, 50);
$content = "NEXA";
PDF::SetXY(100, 20);
PDF::Cell(0, 0, $content);*/
PDF::SetFont('dejavusans', '', 10);
PDF::SetXY(10, 35);
$tbl = '
| DELIVERY CHALLAN |
| No |
: |
DLN-'.$obf_id.' |
Model |
: |
'.$varient_name.' |
| Date |
: |
'.date("d/m/Y",strtotime($orders_data->invoice_date)).' |
Color |
: |
'.$color_name.' |
| Invoice No. |
: |
'.$orders_data->invoice_no.' |
Vehicle No. |
: |
SSF5S6D5D21W96D5Q |
| Invoice Date |
: |
'.date("d/m/Y",strtotime($orders_data->invoice_date)).' |
Chassis No. |
: |
'.$orders_data->chassis_number.' |
| Order No. |
: |
ORD-'.$orders_data->id.' |
Engine No. |
: |
'.$orders_data->engine_number.' |
| Order Date |
: |
'.date("d/m/Y",strtotime($orders_data->created_at)).' |
Key No. |
: |
'.$orders_data->key_number.' |
| Customer ID |
: |
'.$orders_data->customer_id.' |
Registration No. |
: |
REG-'.$orders_data->id.' |
| Name |
: |
'.$orders_data->bill_to.' |
Registration Date |
: |
'.date("d/m/Y",strtotime($orders_data->created_at)).' |
| Address |
: |
'.$orders_data->address.' |
Hypothecated To |
: |
'.$orders_data->finance_name.' |
| Sales Executive |
: |
'.$sales_person_name.' |
| Phone No.(M) |
: |
'.$sales_person_contact_number.' |
| Phone No.(O) |
: |
|
Invoice |
: |
'.$orders_data->grand_total.' |
| Phone No.(R) |
: |
|
Delivery |
: |
'.$orders_data->grand_total.' |
| Phone No.(M) |
: |
'.$orders_data->phone_no.' |
Gate Pass |
: |
|
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::SetXY(10, 120);
$tbl = '
| Standard Delivery |
Tools and Accesories |
| 1. Duplicate Key |
1. CMVR Kit |
| 2. iCATS Key |
2. Insurance Cover Note/Policy |
| 3. Manual Issued |
3. PDI Copy |
| 4. R.C. Book |
4. POP Survey Form |
| 5. RTO Challan |
5. Type of Registration |
| 6. Sales Invoice |
6. SSI Feedback Card |
| 7. Sales Letter |
7. Taxi/Ambulance/Normal |
| 8. Tool Kit |
|
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::SetFont('dejavusans', '', 10);
$content = "Terms & condition apply";
PDF::SetXY(10, 180);
PDF::Cell(0, 0, $content);
PDF::SetFont('dejavusans', '', 12);
$content = "For Mr ".$orders_data->bill_to;
PDF::SetXY(10, 200);
PDF::Cell(0, 0, $content);
PDF::SetFont('dejavusans', '', 12);
$content = "For Savan IB Automotive Private Limited";
PDF::SetXY(110, 200);
PDF::Cell(0, 0, $content);
PDF::SetFont('dejavusans', '', 12);
$content = "(Customer Name & Signature)";
PDF::SetXY(10, 220);
PDF::Cell(0, 0, $content);
PDF::SetFont('dejavusans', '', 12);
$content = "(Authorized Signature)";
PDF::SetXY(110, 220);
PDF::Cell(0, 0, $content);
PDF::Output('get_pass_pdf.pdf', 'I');
}
/*public function delivery_receipt_pdf()
{
ini_set('memory_limit', '2048M');
PDF::SetAuthor('ATUL MOTORS JAM LLP');
PDF::SetTitle('DELIVERY RECEIPT');
PDF::SetSubject('DELIVERY RECEIPT');
PDF::setImageScale(PDF_IMAGE_SCALE_RATIO);
PDF::AddPage('L', 'A4');
PDF::Image(public_path('assets/img/atul-logo.jpg'), 15, 18, 23, 24, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
PDF::Image(public_path('assets/img/maruti-suzuki-logo.jpg'), 220, 20, 60, 17, 'JPG', '', '', true, 150, '', false, false, 0, false, false, false);
$tbl = '
ATUL MOTORS JAM LLP
( Authorised Dealer :- Maruti Suzuki India Ltd.)
| E-mail:- sales@atulmotors.com - service@atulmotors.com |
Toll Free 1800 3000 3838 |
Website:- atulmotors.com |
| Delivery Receipt |
Invoice Number :- NXA/22-23/0056
Invoice Date : 16/05/2022
Name : ZEEL VIMALBHAI PATEL
Mobile No. : 96876 12560
Address :-
401 SHRINIVAS COLONY-1 SUMERCLUB ROAD Jamnagar
Delivery Location :- Jamnagar NEXA Showroom |
Gatepass Number :- JMJ/INT?/02519
Delivery Time:- 16/05/2022
Current Time:-
|
| Tools & Accesories |
PARTICULARS OF VEHICLE
MODEL :- Baleno Alpha Petrol Autometic
Color :- Celestial Blue
CHASSIS NO. :-147142
Engine No. :-7043526
Key No. :-
|
Mamory Card
Rear Side View Mirror
Warranty & Service Booklet
Remote For MP3
Invoice
Insurance Policy
SSI/CSI Feedback Card
Service Booklet
|
Carpet With Padding
First Aid Kit & Tool Kit
Jack & Jack Handle
Spare Type
Duplicate Key
Owners Manual
Antina
Extended Warrenty Book
|
(Customer`s Signature) |
Customer Signature |
';
PDF::writeHTML($tbl, true, false, false, false, '');
PDF::Output('delivery_receipt.pdf', 'I');
}*/
}