get(); return view('contact', compact('app_setting')); } public function getDashboard() { return view('dashboard'); } public function getHistory() { if (Auth::guard('customer')->check()) { $user = Auth::guard('customer')->user(); // $orders = Orders::where('ordCustID', $user->pmID) // ->with(['Brand', 'Customer', 'Model']) // ->orderBy('ordID','DESC') // ->get(); $commonData = new \App\Library\RPCommanData(); $acy_id = $commonData->get_active_accounting_year(); $outstanding = $commonData->Outstanding_Amount_bycust($user->pmID, 0, $acy_id); return view('history', compact('outstanding')); } else { return Redirect::route('home'); } } public function postInquiry(Request $request) { $eqName = $request->get('eqName'); $eqEmail = $request->get('eqEmail'); $eqMobile = $request->get('eqMobile'); $eqMessage = $request->get('eqMessage'); $success = true; $error = array(); if ($eqName == '') { $success = false; } if ($eqEmail == '') { $success = false; } if ($eqMobile == '') { $success = false; } if ($eqMessage == '') { $success = false; } $return = array('success' => false, 'message' => 'Please fill all fields.'); if ($success) { $res = new Inquiry(); $res->eqName = $request->get('eqName'); $res->eqEmail = $request->get('eqEmail'); $res->eqMobile = $request->get('eqMobile'); $res->eqMessage = $request->get('eqMessage'); $res->eqDate = date('Y-m-d'); if ($res->save()) { $bodymessage = file_get_contents(asset('assets/email_template/email_template_inquiry.html')); $bodymessage_admin = file_get_contents(asset('assets/email_template/email_template_inquiry_admin.html')); $logo_url = asset('assets/email_template/Company-Logo.png'); $icon_url = asset('assets/email_template/Company-icon.png'); $facebook_url = asset('assets/email_template/facebook.jpg'); $email_url = asset('assets/email_template/email.jpg'); $website_url = asset('assets/email_template/website.jpg'); $inqdata = '

Name: ' . $eqName . '

'; $inqdata .= '

Email: ' . $eqEmail . '

'; $inqdata .= '

Mobile: ' . $eqMobile . '

'; $inqdata .= '

Message: ' . $eqMessage . '

'; $subject_customer = 'Your enquiry has been successfully sent to the ' . SITE_NAME; $subject_admin = 'New Inquiry From ' . SITE_NAME . ' Website'; $variablese = array( '{{rp_businessname}}' => ucfirst($eqName), '{{rp_inquiry_data}}' => $inqdata, '{{company_logo}}' => $logo_url, '{{company_icon}}' => $icon_url, '{{company_email}}' => $email_url, '{{company_name}}' => SITE_NAME, '{{company_website}}' => $website_url, '{{company_mail}}' => company_email, '{{company_website_link}}' => company_website, ); $message = str_replace(array_keys($variablese), array_values($variablese), $bodymessage); $message_admin = str_replace(array_keys($variablese), array_values($variablese), $bodymessage_admin); $headers = ''; $headers .= 'Content-Type: text/html; charset=UTF-8' . PHP_EOL; $headers .= 'From: ' . SITE_NAME . ' <' . header_email . '>' . PHP_EOL; $send = mail($eqEmail, $subject_customer, $message, $headers); $send = mail(admin_email, $subject_admin, $message_admin, $headers); $return = array('success' => true, 'message' => 'Thankyou for connecting us. Your inquery successfully submited.'); } } return response()->json($return); } public function custOutstanding() { if (Auth::guard('customer')->check()) { $user = Auth::guard('customer')->user(); $commonData = new \App\Library\RPCommanData(); $acy_id = $commonData->get_active_accounting_year(); $outstanding = $commonData->Outstanding_Amount_bycust($user->pmID, 0, $acy_id); return view('cust_outstanding', compact('outstanding')); } else { return Redirect::route('home'); } } /* * Pass data through ajax call */ public function data(Request $request) { $user = Auth::guard('customer')->user(); $data = JobWork::select('jwID', 'jwNum', 'jwDate', 'jwDispacheDate', 'jwPmID', 'jwType', 'jwTotal') ->has('JobWorkDetail') ->where('jwPmID', $user->pmID); $commonData = new \App\Library\RPCommanData(); $activeYear = $commonData->get_active_accounting_year(); $url = asset('storage/uploads/job/'); $jobUrl = asset('storage/uploads/job/' . $activeYear . '/thumb/'); $destinationPath = storage_path() . '/uploads/job/' . $activeYear . '/thumb/'; return Datatables::of($data) ->editColumn('jwDate', function($data) { return Convert_Date_To_DD_MM_YYYY($data->jwDate); }) ->editColumn('jwDispacheDate', function($data) { return isset($data->jwDispacheDate) && !empty($data->jwDispacheDate) ? Convert_Date_To_DD_MM_YYYY($data->jwDispacheDate) : '-'; }) ->editColumn('JobWorkDetail', function($data) { $actions = $data->JobWorkDetail[0]->jwdItemName; return $actions; }) ->addColumn('frontImage', function($data) use($jobUrl, $destinationPath, $url) { $imagename = isset($data->JobWorkDetail[0]->jwdFrontImage) && !empty($data->JobWorkDetail[0]->jwdFrontImage) ? $data->JobWorkDetail[0]->jwdFrontImage : 'Noimage.jpg'; if (file_exists($destinationPath . $imagename)) { $imagename = $jobUrl . '/' . $imagename; } else { $imagename = $url . '/' . 'Noimage.jpg'; } return ''; }) ->addColumn('backImage', function($data) use($jobUrl, $destinationPath, $url) { $imagename = isset($data->JobWorkDetail[0]->jwdBackImage) && !empty($data->JobWorkDetail[0]->jwdBackImage) ? $data->JobWorkDetail[0]->jwdBackImage : 'Noimage.jpg'; if (file_exists($destinationPath . $imagename)) { $imagename = $jobUrl . '/' . $imagename; } else { $imagename = $url . '/' . 'Noimage.jpg'; } return ''; }) ->editColumn('jwTotal', function($data) { $actions = $data->JobWorkDetail[0]->jwdQty; return $actions; }) ->rawColumns(['frontImage', 'backImage']) ->make(true); } public function getPurchaseHistory(Request $request) { if (Auth::guard('customer')->check()) { $user = Auth::guard('customer')->user(); $data = SalesBill::with('Sbjob')->select('sbID', 'sbDate', 'sbNum', 'sbGrandTotal', 'sbJobId') ->where('sbMainType', '1') ->where('sbCustomerID', $user->pmID); $totalAmount = SalesBill::where('sbMainType', '1')->where('sbCustomerID', $user->pmID)->sum('sbGrandTotal'); return Datatables::of($data) ->editColumn('sbDate', function($data) { return Convert_Date_To_DD_MM_YYYY($data->sbDate); }) ->editColumn('sbGrandTotal', function($data) { return number_format($data->sbGrandTotal, 2, '.', ''); }) ->editColumn('Sbjob', function($data) { return isset($data->Sbjob->jwNum) && !empty($data->Sbjob->jwNum) ? $data->Sbjob->jwNum : '-'; }) ->addColumn('actions', function($data) { $actions = 'View'; return $actions; }) ->rawColumns(['actions']) ->with([ "totalAmount" => number_format($totalAmount, 2, '.', ''), ]) ->make(true); } } public function getPaymentHistory(Request $request) { if (Auth::guard('customer')->check()) { $user = Auth::guard('customer')->user(); $data = PaymentReceived::with('PaymentMode')->select('prID', 'prDate', 'prNum', 'prAmount', 'prPaymentMode') ->where('prPmID', $user->pmID); $totalAmount = PaymentReceived::where('prPmID', $user->pmID)->sum('prAmount'); return Datatables::of($data) ->editColumn('prDate', function($data) { return Convert_Date_To_DD_MM_YYYY($data->prDate); }) ->editColumn('PaymentMode', function($data) { return $data->PaymentMode->pymName; }) ->editColumn('prAmount', function($data) { return number_format($data->prAmount, 2, '.', ''); }) ->addColumn('actions', function($data) { $actions = 'View'; return $actions; }) ->with([ "totalAmount" => number_format($totalAmount, 2, '.', ''), ]) ->rawColumns(['actions']) ->make(true); } } public function getOrder() { $brand = DB::table(brands)->where('brType', '1')->where('brStatus', '1')->get(); $brands = array('' => 'Select Brand'); foreach ($brand as $data) { $brands[$data->brID] = $data->brName; } return view('order', compact('brands')); } public function extraItems() { $brand = DB::table(brands)->where('brType', '2')->get(); $brands = array('' => 'Select Brand'); foreach ($brand as $data) { $brands[$data->brID] = $data->brName; } return view('extra', compact('brands')); } public function postOrder(Request $request) { //chech validation $jwOrderType = $request->get('jwOrderType'); $jwOrderType = isset($jwOrderType) && $jwOrderType == 2 ? 2 : 1; $brand_Image_upload = $request->get('brand_Image_upload'); $brand_Image_upload = isset($brand_Image_upload) && $brand_Image_upload == 2 ? 2 : 1; if (Auth::guard('customer')->check()) { $validator = Validator::make($request->all(), [ 'jwdBrandID' => 'required', 'jwdItemId' => 'required', 'jwdQty' => 'required', ]); $user = Auth::guard('customer')->user(); // If validation fails, we'll exit the operation now. if ($validator->fails()) { return Redirect::back()->withInput()->withErrors($validator); } $commonData = new \App\Library\RPCommanData(); $auto_bill = $commonData->get_option('auto_bill', 'no'); $auto_bill_type = $commonData->get_option('auto_bill_type', 'retail'); $job_delivery_days = $commonData->get_option('job_delivery_days', '3'); $folder_structure_enable = $commonData->get_option('folder_structure_enable', 'no'); $stock_update_after = $commonData->get_option('stock_update_after', 'job_add'); $job_number_format = $commonData->get_option('job_number_format', 'default'); $check_outstanding = $commonData->get_option('check_outstanding', 'no'); $activeYear = $commonData->get_active_accounting_year(); $folderNameJob = ''; DB::beginTransaction(); try { $customerData = CustomerMaster::with('Ccity')->where('pmID', $user->pmID)->first(); if ($check_outstanding == 'yes') { if (isset($customerData) && !empty($customerData)) { if ($customerData->pmOutstandingLimit != 0) { $outstanding = $commonData->check_Outstanding($request, $user->pmID, $customerData->pmInvoceType, $customerData->pmStnplID, $customerData->pmState); if ($customerData->pmOutstandingLimit <= $outstanding) { return Redirect::route('order')->withInput()->with('error', "Outstanding limit is crossed so you can not process the new order."); } } } } if ($job_number_format == 'custom') { $job_number_start = $commonData->get_option('job_number_start', '10000'); $jwNum = $job_number_start + 1; } else { $max_job_num = JobWork::select(DB::raw('max(jwNum) as jwNum'))->where(DB::raw('LEFT(jwNum,4)'), date("Y"))->withTrashed()->first(); if (isset($max_job_num->jwNum) && !empty($max_job_num->jwNum)) { $jwNum = $max_job_num->jwNum + 1; } else { $jwNum = date("Y") . sprintf("%'.06d", 1); } } // $res_mdl = Modelmaster::where('mdlID', $request->get('mdlID')) // ->get(); $downloadAvailable = 1; if($jwOrderType == 2){ $downloadAvailable = $brand_Image_upload; } $res = new JobWork(); $res->jwPmID = $user->pmID; $res->jwNum = $jwNum; $res->jwDate = date('Y-m-d'); $res->jwTime = date('H:i:s'); $res->jwDeliveryDate = date('Y-m-d', strtotime(date('Y-m-d') . ' + ' . $job_delivery_days . ' days')); $res->jwPriorityId = 1; $res->jwPrefixID = 2; $res->jwType = 1; $res->jwTotal = 1; $res->jwOrderType = $jwOrderType; $res->jwDownloadAvailable = $downloadAvailable; $safeNameFront = ''; $safeNameBack = ''; $folderName = '/uploads/job/' . $activeYear . '/'; $thumbFolderName = '/uploads/job/' . $activeYear . '/thumb/'; $destinationPath = storage_path() . $folderName; $thumbDestinationPath = storage_path() . $thumbFolderName; if ($file = $request->file('ordImage')) { $fileName = $file->getClientOriginalName(); $extensionFront = $file->getClientOriginalExtension() ?: 'png'; $safeName = ap_generate_unique_imgname(1,$user->pmID) . '.' . $extensionFront; $allowedfileExtension = array('jpeg', 'jpg', 'png'); if (!in_array(strtolower($extensionFront), $allowedfileExtension)) { return Redirect::back()->withInput()->with('error', 'Upload only image file.'); } if (!is_dir($destinationPath)) { mkdir($destinationPath, 0777, true); } if (!is_dir($thumbDestinationPath)) { mkdir($thumbDestinationPath, 0777, true); } $img = Image::make($file->getRealPath())->orientate(); $img->save($destinationPath . $safeName, 100); $img->resize(null, 150, function ($constraint) { $constraint->aspectRatio(); }); $img->save($thumbDestinationPath . $safeName, 80); //$file->move($destinationPath, $safeName); $safeNameFront = $safeName; } if ($file = $request->file('ordImage2')) { $fileName = $file->getClientOriginalName(); $extensionBack = $file->getClientOriginalExtension() ?: 'png'; $safeName = ap_generate_unique_imgname(2,$user->pmID) . '.' . $extensionBack; $allowedfileExtension = array('jpeg', 'jpg', 'png'); if (!in_array(strtolower($extensionBack), $allowedfileExtension)) { return Redirect::back()->withInput()->with('error', 'Upload only image file.'); } if (!is_dir($destinationPath)) { mkdir($destinationPath, 0777, true); } if (!is_dir($thumbDestinationPath)) { mkdir($thumbDestinationPath, 0777, true); } $img = Image::make($file->getRealPath())->orientate(); $img->save($destinationPath . $safeName, 100); $img->resize(null, 150, function ($constraint) { $constraint->aspectRatio(); }); $img->save($thumbDestinationPath . $safeName, 80); //$file->move($destinationPath, $safeName); $safeNameBack = $safeName; } $jwNumNew = $commonData->mp_number_unique($jwNum, 'job'); if ($safeNameFront != '') { $oldName = $safeNameFront; $newName = $jwNumNew . '-1' . 'F.' . $extensionFront; rename($destinationPath . $oldName, $destinationPath . $newName); rename($thumbDestinationPath . $oldName, $thumbDestinationPath . $newName); $safeNameFront = $newName; } if ($safeNameBack != '') { $oldName = $safeNameBack; $newName = $jwNumNew . '-1' . 'B.' . $extensionBack; rename($destinationPath . $oldName, $destinationPath . $newName); rename($thumbDestinationPath . $oldName, $thumbDestinationPath . $newName); $safeNameBack = $newName; } $res->jwNum = $jwNumNew; if ($res->save()) { if ($job_number_format == 'custom') { $commonData->update_option('job_number_start', $jwNumNew); } $emboss = $request->get('jwdEmboss'); $emboss = $emboss == '1' ? ' Emboss ' : ''; if ($folder_structure_enable == 'yes') { $folderNameJob .= $jwNum . ' ' . $customerData->pmCompName . ' ' . $customerData->Ccity->city_name . ' '; $folderNameJob .= $request->get('jwdBrandName') . ' ' . $request->get('jwdItemName') . ' ' . $request->get('jwdSizeName') . ' ' . $request->get('jwdColorName') . $emboss . ' - ' . $request->get('jwdQty'); } $jobDetail = [ 'jwdJwID' => $res->jwID, 'jwdItemNo' => $jwNum . '-' . 1, 'jwdBrandID' => $request->get('jwdBrandID'), 'jwdBrandName' => $request->get('jwdBrandName'), 'jwdItemId' => $request->get('jwdItemId'), 'jwdItemName' => $request->get('jwdItemName'), 'jwdSizeId' => $request->get('jwdSizeId'), 'jwdSizeName' => $request->get('jwdSizeName'), 'jwdColorId' => $request->get('jwdColorId'), 'jwdColorName' => $request->get('jwdColorName'), 'jwdQty' => $request->get('jwdQty'), 'jwdEmboss' => $request->get('jwdEmboss'), ]; if ($safeNameFront != '') $jobDetail['jwdFrontImage'] = $safeNameFront; if ($safeNameBack != '') $jobDetail['jwdBackImage'] = $safeNameBack; JobWorkDetail::insert($jobDetail); if ($stock_update_after == 'job_add') { $jwdSizeId = $request->get('jwdSizeId'); $typeID = $commonData->getParentType($jwdSizeId); $get_Items = SaleableitemRelation::select('sarStock', 'sarID')->where('sarSamID', $request->get('jwdItemId'))->where('sarSizeID', $typeID)->where('sarClrID', $request->get('jwdColorId'))->first(); if (isset($get_Items) && !empty($get_Items)) { $updateStock['sarStock'] = $get_Items->sarStock - $request->get('jwdQty'); DB::table(saleabletypecolorrelation)->where('sarID', $get_Items->sarID)->update($updateStock); } } $jobWork = ['jwTotal' => $request->get('jwdQty'), 'jwFolderName' => $folderNameJob]; JobWork::where('jwID', $res->jwID)->update($jobWork); if ($auto_bill == 'yes') { if ($auto_bill_type == 'retail') { $commonData->generateAutoRetail($request, $res->jwID, 0, $res->jwDate, $user->pmID); } } DB::commit(); return Redirect::route('history')->with('success', 'Order placed successfully.'); } } catch (\Exception $e) { DB::rollback(); Log::info($e); if ($jwOrderType == '2') return Redirect::route('extraItems')->withInput()->with('error', 'Your Internet Connection interrupted.Please try again.'); else return Redirect::route('order')->withInput()->with('error', 'Your Internet Connection interrupted.Please try again.'); } } return Redirect::route('order')->withInput()->with('error', 'Your Internet Connection interrupted.Please try again.'); } public function getPaymentDetail(Request $request) { $return = array('success' => false, 'message' => 'Payment Not Found'); if (Auth::guard('customer')->check()) { $user = Auth::guard('customer')->user(); $prID = $request->get('prID'); $pbDetail = PaymentReceived::with(['PaymentRecieveDetail']) ->with('PaymentMode') ->where('prPmID', $user->pmID) ->where('prID', $prID); $pbDetail = $pbDetail->get(); if (isset($pbDetail[0]) && !empty($pbDetail[0])) { $invoiceDetail = ''; if ($pbDetail[0]->prPaymentMode != '2') { $invoiceDetail .= ''; $invoiceDetail .= ''; } $invoiceDetail .= ''; $invoiceDetail .= '
Number ' . $pbDetail[0]->prNum . ' Date ' . $pbDetail[0]->prDate . '
Amount ' . $pbDetail[0]->prAmount . ' Mode ' . $pbDetail[0]->PaymentMode->pymName . '
Bank Name ' . $pbDetail[0]->prBankName . ' Check Num ' . $pbDetail[0]->prCheckNum . '
Check Date ' . Convert_Date_To_DD_MM_YYYY($pbDetail[0]->prCheckDate) . '
Remarks ' . $pbDetail[0]->prRemarks . '
'; if (isset($pbDetail[0]->PaymentRecieveDetail[0]) && !empty($pbDetail[0]->PaymentRecieveDetail)) { $invoiceDetail .= ''; foreach ($pbDetail[0]->PaymentRecieveDetail as $_pbDetail) { $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; } } $invoiceDetail .= '
Invoice No Amount
' . $_pbDetail->SalseBill->sbNum . '' . $_pbDetail->prdAmount . '
'; $return = array('success' => true, 'data' => $invoiceDetail); } } return response()->json($return); } public function getInvoiceDetail(Request $request) { $return = array('success' => false, 'message' => 'Invoice Not Found'); if (Auth::guard('customer')->check()) { $sbID = $request->get('sbID'); $user = Auth::guard('customer')->user(); $sbDetail = SalesBill::with('SalesDetail', 'SalesDetail.ItemHsnCode')->where('sbID', $sbID)->where('sbCustomerID', $user->pmID)->get(); if (isset($sbDetail[0]) && !empty($sbDetail[0])) { if ($sbDetail[0]->sbType == '1') $invoiceDetail = $this->viewTaxInvoice($sbDetail); else $invoiceDetail = $this->viewRetailInvoice($sbDetail); $return = array('success' => true, 'data' => $invoiceDetail); } } return response()->json($return); } public function viewTaxInvoice($sbDetail) { $invoiceDetail = '
Invoice Number ' . $sbDetail[0]->sbNum . ' Date ' . $sbDetail[0]->sbDate . '
Remarks ' . $sbDetail[0]->sbRemarks . '
'; $invoiceDetail .= ''; if ($sbDetail[0]->sbGstMode == '1') { $invoiceDetail .= ''; } else { $invoiceDetail .= ''; $invoiceDetail .= ''; } $invoiceDetail .= ''; if (isset($sbDetail[0]->SalesDetail[0]) && !empty($sbDetail[0]->SalesDetail)) { foreach ($sbDetail[0]->SalesDetail as $_SalesDetail) { // pr($_SalesDetail); // exit; $emboss = $_SalesDetail->sbdEmboss == '1' ? 'Yes' : 'No'; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; if ($sbDetail[0]->sbGstMode == '1') { $sbdGSTStr = number_format($_SalesDetail->sbdIgstPercent, 2, '.', '') . '%'; } else { $sbdGSTStr = number_format($_SalesDetail->sbdCgstPercent + $_SalesDetail->sbdCgstPercent, 2, '.', '') . '%'; } $invoiceDetail .= ''; if ($sbDetail[0]->sbGstMode == '1') { $invoiceDetail .= ''; } else { $invoiceDetail .= ''; $invoiceDetail .= ''; } $invoiceDetail .= ''; $invoiceDetail .= ''; } } $invoiceDetail .= '
Brand Model Type Color Emboss Qty Rate HSN GST%IGSTCGSTSGSTAmount
' . $_SalesDetail->sbdBrandName . '' . $_SalesDetail->sbdItemName . '' . $_SalesDetail->sbdSizeName . '' . $_SalesDetail->sbdColorName . '' . $emboss . '' . $_SalesDetail->sbdQty . '' . $_SalesDetail->sbdRate . '' . $_SalesDetail->ItemHsnCode->hsnName . '' . $sbdGSTStr . '' . number_format($_SalesDetail->sbdIgstValue, 2, '.', '') . '' . number_format($_SalesDetail->sbdCgstValue, 2, '.', '') . '' . number_format($_SalesDetail->sbdSgstValue, 2, '.', '') . '' . number_format($_SalesDetail->sbdAmount, 2, '.', '') . '
'; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; if ($sbDetail[0]->sbGstMode == '1') { $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; } else { $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; } $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= '
Sub Total' . number_format($sbDetail[0]->sbTotal, 2, '.', '') . '
Total IGST' . number_format($sbDetail[0]->sbTotalIgst, 2, '.', '') . '
Total SGST' . number_format($sbDetail[0]->sbTotalSgst, 2, '.', '') . '
Total CGST' . number_format($sbDetail[0]->sbTotalCgst, 2, '.', '') . '
Shipping Charge' . number_format($sbDetail[0]->sbShippingCharge, 2, '.', '') . '
Round Off' . number_format($sbDetail[0]->sbRoundOff, 2, '.', '') . '
Grand Total' . number_format($sbDetail[0]->sbGrandTotal, 2, '.', '') . '
Advance Payment' . number_format($sbDetail[0]->sbAdvancePayment, 2, '.', '') . '
'; return $invoiceDetail; } public function viewRetailInvoice($sbDetail) { $invoiceDetail = '
Invoice Number ' . $sbDetail[0]->sbNum . ' Date ' . $sbDetail[0]->sbDate . '
Remarks ' . $sbDetail[0]->sbRemarks . '
'; $invoiceDetail .= ''; if (isset($sbDetail[0]->SalesDetail[0]) && !empty($sbDetail[0]->SalesDetail)) { foreach ($sbDetail[0]->SalesDetail as $_SalesDetail) { // pr($_SalesDetail); // exit; $emboss = $_SalesDetail->sbdEmboss == '1' ? 'Yes' : 'No'; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; } } $invoiceDetail .= '
Brand Model Type Color Emboss Qty Rate Amount
' . $_SalesDetail->sbdBrandName . '' . $_SalesDetail->sbdItemName . '' . $_SalesDetail->sbdSizeName . '' . $_SalesDetail->sbdColorName . '' . $emboss . '' . $_SalesDetail->sbdQty . '' . $_SalesDetail->sbdRate . '' . number_format($_SalesDetail->sbdAmount, 2, '.', '') . '
'; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= ''; $invoiceDetail .= '
Sub Total' . number_format($sbDetail[0]->sbTotal, 2, '.', '') . '
Plus     (' . number_format($sbDetail[0]->sbVatPercent, 2, '.', '') . ' %)' . number_format($sbDetail[0]->sbVatValue, 2, '.', '') . '
Shipping Charge' . number_format($sbDetail[0]->sbShippingCharge, 2, '.', '') . '
Round Off' . number_format($sbDetail[0]->sbRoundOff, 2, '.', '') . '
Grand Total' . number_format($sbDetail[0]->sbGrandTotal, 2, '.', '') . '
Advance Payment' . number_format($sbDetail[0]->sbAdvancePayment, 2, '.', '') . '
'; return $invoiceDetail; } }