��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧�

��ѧۧݧ�ӧ�� ާ֧ߧ֧էا֧� - ��֧էѧܧ�ڧ��ӧѧ�� - /home/zhaagvlk/web.zhaap.com/app__1b5d5ff/Http/Controllers/ProposalController.php

��ѧ٧ѧ�
<?php namespace App\Http\Controllers; use App\Models\ActivityLog; use App\Models\Customer; use App\Models\CustomField; use App\Models\Invoice; use App\Models\InvoiceProduct; use App\Models\Mail\ProposalSend; use App\Models\Milestone; use App\Models\Products; use App\Models\ProductService; use App\Models\ProductServiceCategory; use App\Models\Proposal; use App\Models\Retainer; use App\Models\ProposalProduct; use App\Models\RetainerProduct; use App\Models\StockReport; use App\Models\Task; use App\Models\Utility; use Auth; use App\Models\User; use Illuminate\Http\Request; use Illuminate\Support\Facades\Crypt; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Mail; use Illuminate\Support\Facades\Storage; use Maatwebsite\Excel\Facades\Excel; use App\Exports\ProposalExport; class ProposalController extends Controller { public function __construct() { } public function index(Request $request) { if (\Auth::user()->can('manage proposal')) { $customer = Customer::where('created_by', '=', \Auth::user()->creatorId())->get()->pluck('name', 'id'); $customer->prepend('Select Customer', ''); $status = Proposal::$statues; $query = Proposal::where('created_by', '=', \Auth::user()->creatorId()); if (!empty($request->customer)) { $query->where('customer_id', '=', $request->customer); } if (str_contains($request->issue_date, ' to ')) { $date_range = explode(' to ', $request->issue_date); $query->whereBetween('issue_date', $date_range); } elseif (!empty($request->issue_date)) { $query->where('issue_date', $request->issue_date); } // if (!empty($request->issue_date)) { // $date_range = explode(' to ', $request->issue_date); // $query->whereBetween('issue_date', $date_range); // } if (!empty($request->status)) { $query->where('status', '=', $request->status); } $proposals = $query->get(); return view('proposal.index', compact('proposals', 'customer', 'status')); } else { return redirect()->back()->with('error', __('Permission Denied.')); } } public function create($customerId) { if (\Auth::user()->can('create proposal')) { $customFields = CustomField::where('created_by', '=', \Auth::user()->creatorId())->where('module', '=', 'proposal')->get(); $proposal_number = \Auth::user()->proposalNumberFormat($this->proposalNumber()); $customers = Customer::where('created_by', \Auth::user()->creatorId())->get()->pluck('name', 'id'); $customers->prepend('Select Customer', ''); $category = ProductServiceCategory::where('created_by', \Auth::user()->creatorId())->where('type', 'income')->get()->pluck('name', 'id'); $category->prepend('Select Category', ''); $product_services = ProductService::where('created_by', \Auth::user()->creatorId())->get()->pluck('name', 'id'); $product_services->prepend('--', ''); return view('proposal.create', compact('customers', 'proposal_number', 'product_services', 'category', 'customFields', 'customerId')); } else { return response()->json(['error' => __('Permission denied.')], 401); } } public function customer(Request $request) { $customer = Customer::where('id', '=', $request->id)->first(); return view('proposal.customer_detail', compact('customer')); } public function product(Request $request) { $data['product'] = $product = ProductService::find($request->product_id); $data['unit'] = (!empty($product->unit)) ? $product->unit->name : 0; $data['taxRate'] = $taxRate = !empty($product->tax_id) ? $product->taxRate($product->tax_id) : 0; $data['taxes'] = !empty($product->tax_id) ? $product->tax($product->tax_id) : 0; $salePrice = $product->sale_price; $quantity = 1; $taxPrice = ($taxRate / 100) * ($salePrice * $quantity); $data['totalAmount'] = ($salePrice * $quantity); return json_encode($data); } public function store(Request $request) { if (\Auth::user()->can('create proposal')) { $validator = \Validator::make( $request->all(), [ 'customer_id' => 'required', 'issue_date' => 'required', 'category_id' => 'required', 'items' => 'required', ] ); if ($validator->fails()) { $messages = $validator->getMessageBag(); return redirect()->back()->with('error', $messages->first()); } $status = Proposal::$statues; $proposal = new Proposal(); $proposal->proposal_id = $this->proposalNumber(); $proposal->customer_id = $request->customer_id; $proposal->status = 0; $proposal->issue_date = $request->issue_date; $proposal->category_id = $request->category_id; $proposal->discount_apply = isset($request->discount_apply) ? 1 : 0; $proposal->created_by = \Auth::user()->creatorId(); $proposal->save(); Utility::starting_number($proposal->proposal_id + 1, 'proposal'); CustomField::saveData($proposal, $request->customField); $products = $request->items; for ($i = 0; $i < count($products); $i++) { $proposalProduct = new ProposalProduct(); $proposalProduct->proposal_id = $proposal->id; $proposalProduct->product_id = $products[$i]['item']; $proposalProduct->quantity = $products[$i]['quantity']; $proposalProduct->tax = $products[$i]['tax']; // $proposalProduct->discount = isset($products[$i]['discount']) ? $products[$i]['discount'] : 0; // $proposalProduct->discount = (isset($request->discount_apply)) ? isset($products[$i]['discount']) ? $products[$i]['discount'] : 0 :0; $proposalProduct->discount = $products[$i]['discount']; $proposalProduct->price = $products[$i]['price']; $proposalProduct->description = $products[$i]['description']; $proposalProduct->save(); } //Twilio Notification $setting = Utility::settings(\Auth::user()->creatorId()); $proposalId = Crypt::encrypt($proposal->id); $proposal->url = route('proposal.pdf', $proposalId); $customer = Customer::find($request->customer_id); if (isset($setting['invoice_notification']) && $setting['invoice_notification'] == 1) { $uArr = [ 'proposal_name' => $customer->name, 'proposal_number' => \Auth::user()->proposalNumberFormat($proposal->proposal_id), 'proposal_url' => $proposal->url, ]; Utility::send_twilio_msg($customer->contact, 'new_proposal', $uArr); } // webhook $module = 'New Proposal'; $webhook = Utility::webhookSetting($module); if ($webhook) { $parameter = json_encode($proposal); // 1 parameter is URL , 2 parameter is data , 3 parameter is method $status = Utility::WebhookCall($webhook['url'], $parameter, $webhook['method']); if ($status == true) { return redirect()->route('proposal.index')->with('success', __('Proposal successfully created.')); } else { return redirect()->back()->with('error', __('Webhook call failed.')); } } return redirect()->route('proposal.index')->with('success', __('Proposal successfully created.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function edit($ids) { if (\Auth::user()->can('edit proposal')) { $id = Crypt::decrypt($ids); $proposal = Proposal::find($id); $proposal_number = \Auth::user()->proposalNumberFormat($proposal->proposal_id); $customers = Customer::where('created_by', \Auth::user()->creatorId())->get()->pluck('name', 'id'); $category = ProductServiceCategory::where('created_by', \Auth::user()->creatorId())->where('type', 'income')->get()->pluck('name', 'id'); $category->prepend('Select Category', ''); $product_services = ProductService::where('created_by', \Auth::user()->creatorId())->get()->pluck('name', 'id'); // dd($product_services); $proposal->customField = CustomField::getData($proposal, 'proposal'); $customFields = CustomField::where('created_by', '=', \Auth::user()->creatorId())->where('module', '=', 'proposal')->get(); $items = []; foreach ($proposal->items as $proposalItem) { $itemAmount = $proposalItem->quantity * $proposalItem->price; $proposalItem->itemAmount = $itemAmount; $proposalItem->taxes = Utility::tax($proposalItem->tax); $items[] = $proposalItem; } return view('proposal.edit', compact('customers', 'product_services', 'proposal', 'proposal_number', 'category', 'customFields', 'items')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function update(Request $request, Proposal $proposal) { if (\Auth::user()->can('edit proposal')) { if ($proposal->created_by == \Auth::user()->creatorId()) { $validator = \Validator::make( $request->all(), [ 'customer_id' => 'required', 'issue_date' => 'required', 'category_id' => 'required', 'items' => 'required', ] ); if ($validator->fails()) { $messages = $validator->getMessageBag(); return redirect()->route('proposal.index')->with('error', $messages->first()); } $proposal->customer_id = $request->customer_id; $proposal->issue_date = $request->issue_date; $proposal->category_id = $request->category_id; $proposal->discount_apply = isset($request->discount_apply) ? 1 : 0; $proposal->save(); CustomField::saveData($proposal, $request->customField); $products = $request->items; for ($i = 0; $i < count($products); $i++) { $proposalProduct = ProposalProduct::find($products[$i]['id']); if ($proposalProduct == null) { $proposalProduct = new ProposalProduct(); $proposalProduct->proposal_id = $proposal->id; } if (isset($products[$i]['item'])) { $proposalProduct->product_id = $products[$i]['item']; } $proposalProduct->quantity = $products[$i]['quantity']; $proposalProduct->tax = $products[$i]['tax']; // $proposalProduct->discount = isset($products[$i]['discount']) ? $products[$i]['discount'] : 0; $proposalProduct->discount = $products[$i]['discount']; $proposalProduct->price = $products[$i]['price']; $proposalProduct->description = $products[$i]['description']; $proposalProduct->save(); } return redirect()->route('proposal.index')->with('success', __('Proposal successfully updated.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } else { return redirect()->back()->with('error', __('Permission denied.')); } } function proposalNumber() { $latest = Utility::getValByName('proposal_starting_number'); // $latest = Proposal::where('created_by', '=', \Auth::user()->creatorId())->latest()->first(); if (!$latest) { return 1; } // return $latest->proposal_id + 1; return $latest; } public function show($ids) { if (\Auth::user()->can('show proposal')) { $id = Crypt::decrypt($ids); $proposal = Proposal::find($id); if ($proposal->created_by == \Auth::user()->creatorId()) { $customer = $proposal->customer; $iteams = $proposal->items; $status = Proposal::$statues; $proposal->customField = CustomField::getData($proposal, 'proposal'); $customFields = CustomField::where('created_by', '=', \Auth::user()->creatorId())->where('module', '=', 'proposal')->get(); return view('proposal.view', compact('proposal', 'customer', 'iteams', 'status', 'customFields')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function destroy(Proposal $proposal) { if (\Auth::user()->can('delete proposal')) { if ($proposal->created_by == \Auth::user()->creatorId()) { $proposal->delete(); ProposalProduct::where('proposal_id', '=', $proposal->id)->delete(); return redirect()->route('proposal.index')->with('success', __('Proposal successfully deleted.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function productDestroy(Request $request) { if (\Auth::user()->can('delete proposal product')) { ProposalProduct::where('id', '=', $request->id)->delete(); return redirect()->back()->with('success', __('Proposal product successfully deleted.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function customerProposal(Request $request) { if (\Auth::user()->can('manage customer proposal')) { $status = Proposal::$statues; $query = Proposal::where('customer_id', '=', \Auth::user()->id)->where('status', '!=', '0')->where('created_by', \Auth::user()->creatorId()); if (str_contains($request->issue_date, ' to ')) { $date_range = explode(' to ', $request->issue_date); $query->whereBetween('issue_date', $date_range); } elseif (!empty($request->issue_date)) { $query->where('issue_date', $request->issue_date); } // if (!empty($request->issue_date)) { // $date_range = explode(' to ', $request->issue_date); // $query->whereBetween('issue_date', $date_range); // } if (!empty($request->status)) { $query->where('status', '=', $request->status); } $proposals = $query->get(); return view('proposal.index', compact('proposals', 'status')); } else { return redirect()->back()->with('error', __('Permission Denied.')); } } public function customerProposalShow($id) { if (\Auth::user()->can('show proposal')) { $proposal_id = Crypt::decrypt($id); $proposal = Proposal::where('id', $proposal_id)->first(); if ($proposal->created_by == \Auth::user()->creatorId()) { $customer = $proposal->customer; $iteams = $proposal->items; return view('proposal.view', compact('proposal', 'customer', 'iteams')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function sent($id) { if (\Auth::user()->can('send proposal')) { $proposal = Proposal::where('id', $id)->first(); $proposal->send_date = date('Y-m-d'); $proposal->status = 1; $proposal->save(); $customer = Customer::where('id', $proposal->customer_id)->first(); $proposal->name = !empty($customer) ? $customer->name : ''; $proposal->proposal = \Auth::user()->proposalNumberFormat($proposal->proposal_id); $proposalId = Crypt::encrypt($proposal->id); $proposal->url = route('proposal.pdf', $proposalId); $uArr = [ 'proposal_name' => $proposal->name, 'proposal_number' => $proposal->proposal, 'proposal_url' => $proposal->url, ]; try { $resp = Utility::sendEmailTemplate('proposal_sent', [$customer->id => $customer->email], $uArr); } catch (\Exception $e) { $smtp_error = __('E-Mail has been not sent due to SMTP configuration'); } return redirect()->back()->with('success', __('Proposal successfully sent.') . ((isset($smtp_error)) ? '<br> <span class="text-danger">' . $smtp_error . '</span>' : '')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function resent($id) { if (\Auth::user()->can('send proposal')) { $proposal = Proposal::where('id', $id)->first(); $customer = Customer::where('id', $proposal->customer_id)->first(); $proposal->name = !empty($customer) ? $customer->name : ''; $proposal->proposal = \Auth::user()->proposalNumberFormat($proposal->proposal_id); $proposalId = Crypt::encrypt($proposal->id); $proposal->url = route('proposal.pdf', $proposalId); $uArr = [ 'proposal_name' => $proposal->name, 'proposal_number' => $proposal->proposal, 'proposal_url' => $proposal->url, ]; try { $resp = Utility::sendEmailTemplate('proposal_sent', [$customer->id => $customer->email], $uArr); } catch (\Exception $e) { $smtp_error = __('E-Mail has been not sent due to SMTP configuration'); } return redirect()->back()->with('success', __('Proposal successfully sent.') . ((isset($smtp_error)) ? '<br> <span class="text-danger">' . $smtp_error . '</span>' : '')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function shippingDisplay(Request $request, $id) { $proposal = Proposal::find($id); if ($request->is_display == 'true') { $proposal->shipping_display = 1; } else { $proposal->shipping_display = 0; } $proposal->save(); return redirect()->back()->with('success', __('Shipping address status successfully changed.')); } public function duplicate($proposal_id) { if (\Auth::user()->can('duplicate proposal')) { $proposal = Proposal::where('id', $proposal_id)->first(); $duplicateProposal = new Proposal(); $duplicateProposal->proposal_id = $this->proposalNumber(); $duplicateProposal->customer_id = $proposal['customer_id']; $duplicateProposal->issue_date = date('Y-m-d'); $duplicateProposal->send_date = null; $duplicateProposal->category_id = $proposal['category_id']; $duplicateProposal->status = 0; $duplicateProposal->created_by = $proposal['created_by']; $duplicateProposal->save(); if ($duplicateProposal) { $proposalProduct = ProposalProduct::where('proposal_id', $proposal_id)->get(); foreach ($proposalProduct as $product) { $duplicateProduct = new ProposalProduct(); $duplicateProduct->proposal_id = $duplicateProposal->id; $duplicateProduct->product_id = $product->product_id; $duplicateProduct->quantity = $product->quantity; $duplicateProduct->tax = $product->tax; $duplicateProduct->discount = $product->discount; $duplicateProduct->price = $product->price; $duplicateProduct->save(); } } return redirect()->back()->with('success', __('Proposal duplicate successfully.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function convert($proposal_id) { if (\Auth::user()->can('convert retainer proposal')) { $proposal = Proposal::where('id', $proposal_id)->first(); $proposal->is_convert = 1; $proposal->save(); $convertRetainer = new Retainer(); $convertRetainer->retainer_id = $this->retainerNumber(); $convertRetainer->customer_id = $proposal['customer_id']; $convertRetainer->issue_date = date('Y-m-d'); $convertRetainer->due_date = date('Y-m-d'); $convertRetainer->send_date = null; $convertRetainer->category_id = $proposal['category_id']; $convertRetainer->status = 0; $convertRetainer->created_by = $proposal['created_by']; $convertRetainer->save(); $proposal->converted_retainer_id = $convertRetainer->id; $proposal->save(); if ($convertRetainer) { $proposalProduct = ProposalProduct::where('proposal_id', $proposal_id)->get(); foreach ($proposalProduct as $product) { $duplicateProduct = new RetainerProduct(); $duplicateProduct->retainer_id = $convertRetainer->id; $duplicateProduct->product_id = $product->product_id; $duplicateProduct->quantity = $product->quantity; $duplicateProduct->tax = $product->tax; $duplicateProduct->discount = $product->discount; $duplicateProduct->price = $product->price; $duplicateProduct->save(); Utility::total_quantity('minus', $duplicateProduct->quantity, $duplicateProduct->product_id); //Product Stock Report $type = 'Retainer'; $type_id = $convertRetainer->id; $description = $duplicateProduct->quantity . ' ' . __(' quantity sold in invoice') . ' ' . \Auth::user()->retainerNumberFormat($convertRetainer->retainer_id); Utility::addProductStock($product->product_id, $duplicateProduct->quantity, $type, $description, $type_id); } } return redirect()->back()->with('success', __('Proposal to Retainer convert successfully.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function statusChange(Request $request, $id) { $status = $request->status; $proposal = Proposal::find($id); $proposal->status = $status; $proposal->save(); return redirect()->back()->with('success', __('Proposal status changed successfully.')); } public function previewProposal($template, $color) { $objUser = \Auth::user(); $settings = Utility::settings(); $proposal = new Proposal(); $customer = new \stdClass(); $customer->email = '<Email>'; $customer->shipping_name = '<Customer Name>'; $customer->shipping_country = '<Country>'; $customer->shipping_state = '<State>'; $customer->shipping_city = '<City>'; $customer->shipping_phone = '<Customer Phone Number>'; $customer->shipping_zip = '<Zip>'; $customer->shipping_address = '<Address>'; $customer->billing_name = '<Customer Name>'; $customer->billing_country = '<Country>'; $customer->billing_state = '<State>'; $customer->billing_city = '<City>'; $customer->billing_phone = '<Customer Phone Number>'; $customer->billing_zip = '<Zip>'; $customer->billing_address = '<Address>'; $customer->sku = 'Test123'; $totalTaxPrice = 0; $taxesData = []; $items = []; for ($i = 1; $i <= 3; $i++) { $item = new \stdClass(); $item->name = 'Item ' . $i; $item->quantity = 1; $item->tax = 5; $item->discount = 50; $item->price = 100; $taxes = [ 'Tax 1', 'Tax 2', ]; $itemTaxes = []; foreach ($taxes as $k => $tax) { $taxPrice = 10; $totalTaxPrice += $taxPrice; $itemTax['name'] = 'Tax ' . $k; $itemTax['rate'] = '10 %'; $itemTax['price'] = '$10'; $itemTax['tax_price'] = 10; $itemTaxes[] = $itemTax; // $taxPrice = 10; // $totalTaxPrice += $taxPrice; // $itemTax['name'] = 'Tax ' . $k; // $itemTax['rate'] = '10 %'; // $itemTax['price'] = '$10'; // $itemTaxes[] = $itemTax; if (array_key_exists('Tax ' . $k, $taxesData)) { $taxesData['Tax ' . $k] = $taxesData['Tax 1'] + $taxPrice; } else { $taxesData['Tax ' . $k] = $taxPrice; } } $item->itemTax = $itemTaxes; $items[] = $item; } $proposal->proposal_id = 1; $proposal->issue_date = date('Y-m-d H:i:s'); $proposal->due_date = date('Y-m-d H:i:s'); $proposal->itemData = $items; $proposal->totalTaxPrice = 60; $proposal->totalQuantity = 3; $proposal->totalRate = 300; $proposal->totalDiscount = 10; $proposal->taxesData = $taxesData; $proposal->customField = []; $customFields = []; $preview = 1; $color = '#' . $color; $font_color = Utility::getFontColor($color); $logo = asset(Storage::url('uploads/logo/')); $company_logo = Utility::getValByName('company_logo_dark'); $proposal_logo = Utility::getValByName('proposal_logo'); if (isset($proposal_logo) && !empty($proposal_logo)) { $img = Utility::get_file('proposal_logo/') . $proposal_logo; // $img = Utility::get_file($proposal_logo); } else { $img = asset($logo . '/' . (isset($company_logo) && !empty($company_logo) ? $company_logo : 'logo-dark.png')); } return view('proposal.templates.' . $template, compact('proposal', 'preview', 'color', 'img', 'settings', 'customer', 'font_color', 'customFields')); } public function proposal($proposal_id) { $settings = Utility::settings(); $proposalId = Crypt::decrypt($proposal_id); $proposal = Proposal::where('id', $proposalId)->first(); $data = DB::table('settings'); $data = $data->where('created_by', '=', $proposal->created_by); $data1 = $data->get(); foreach ($data1 as $row) { $settings[$row->name] = $row->value; } $customer = $proposal->customer; $items = []; $totalTaxPrice = 0; $totalQuantity = 0; $totalRate = 0; $totalDiscount = 0; $taxesData = []; foreach ($proposal->items as $product) { $item = new \stdClass(); $item->name = !empty($product->product) ? $product->product->name : ''; $item->quantity = $product->quantity; $item->tax = $product->tax; $item->discount = $product->discount; $item->price = $product->price; $item->description = $product->description; $totalQuantity += $item->quantity; $totalRate += $item->price; $totalDiscount += $item->discount; $taxes = Utility::tax($product->tax); $itemTaxes = []; if (!empty($item->tax)) { foreach ($taxes as $tax) { $taxPrice = Utility::taxRate($tax->rate, $item->price, $item->quantity, $item->discount); $totalTaxPrice += $taxPrice; $itemTax['name'] = $tax->name; $itemTax['rate'] = $tax->rate . '%'; $itemTax['price'] = Utility::priceFormat($settings, $taxPrice); $itemTax['tax_price'] = $taxPrice; $itemTaxes[] = $itemTax; if (array_key_exists($tax->name, $taxesData)) { $taxesData[$tax->name] = $taxesData[$tax->name] + $taxPrice; } else { $taxesData[$tax->name] = $taxPrice; } } $item->itemTax = $itemTaxes; } else { $item->itemTax = []; } $items[] = $item; } $proposal->itemData = $items; $proposal->totalTaxPrice = $totalTaxPrice; $proposal->totalQuantity = $totalQuantity; $proposal->totalRate = $totalRate; $proposal->totalDiscount = $totalDiscount; $proposal->taxesData = $taxesData; $proposal->customField = CustomField::getData($proposal, 'proposal'); $customFields = []; if (!empty(\Auth::user())) { $customFields = CustomField::where('created_by', '=', \Auth::user()->creatorId())->where('module', '=', 'proposal')->get(); } //Set your logo $logo = asset(Storage::url('uploads/logo/')); $company_logo = Utility::getValByName('company_logo_dark'); $settings_data = \App\Models\Utility::settingsById($proposal->created_by); $proposal_logo = $settings_data['proposal_logo']; if (isset($proposal_logo) && !empty($proposal_logo)) { $img = Utility::get_file('proposal_logo/') . $proposal_logo; // $img = asset(\Storage::url('proposal_logo/') . $proposal_logo); // $img = Utility::get_file($proposal_logo); } else { $img = asset($logo . '/' . (isset($company_logo) && !empty($company_logo) ? $company_logo : 'logo-dark.png')); } if ($proposal) { $color = '#' . $settings['proposal_color']; $font_color = Utility::getFontColor($color); return view('proposal.templates.' . $settings['proposal_template'], compact('proposal', 'color', 'settings', 'customer', 'img', 'font_color', 'customFields')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } public function saveProposalTemplateSettings(Request $request) { $user = \Auth::user(); $post = $request->all(); unset($post['_token']); if ($request->proposal_logo) { $dir = 'proposal_logo/'; $proposal_logo = $user->id . '_proposal_logo.png'; $validation = [ 'mimes:' . 'png', 'max:' . '20480', ]; // $path = $request->file('proposal_logo')->storeAs('/proposal_logo', $proposal_logo); $path = Utility::upload_file($request, 'proposal_logo', $proposal_logo, $dir, $validation); if ($path['flag'] == 1) { $retainer_logo = $path['url']; } else { return redirect()->back()->with('error', __($path['msg'])); } $post['proposal_logo'] = $proposal_logo; } if (isset($post['proposal_template']) && (!isset($post['proposal_color']) \|\| empty($post['proposal_color']))) { $post['proposal_color'] = "ffffff"; } foreach ($post as $key => $data) { \DB::insert( 'insert into settings (`value`, `name`,`created_by`) values (?, ?, ?) ON DUPLICATE KEY UPDATE `value` = VALUES(`value`) ', [ $data, $key, \Auth::user()->creatorId(), ] ); } return redirect()->back()->with('success', __('Proposal Setting updated successfully')); } function retainerNumber() { $latest = Retainer::where('created_by', '=', \Auth::user()->creatorId())->latest()->first(); if (!$latest) { return 1; } return $latest->retainer_id + 1; } public function items(Request $request) { $items = ProposalProduct::where('proposal_id', $request->proposal_id)->where('product_id', $request->product_id)->first(); return json_encode($items); } public function payproposal($id) { try { $proposal_id = \Illuminate\Support\Facades\Crypt::decrypt($id); $proposal = Proposal::where('id', '=', $proposal_id)->first(); if (!empty($proposal)) { $status = Proposal::$statues; $item = $proposal->items ?? ''; $ownerId = !empty($proposal->created_by) ? $proposal->created_by : 0; $company_setting = Utility::settingById($ownerId); $payment_setting = Utility::invoice_payment_settings($ownerId); return view('proposal.proposalpay', compact('proposal', 'company_setting', 'status', 'item')); } else { return redirect()->back()->with('error', __('Proposal is not found')); } } catch (\Exception $e) { return abort('404', 'The Link You Followed Has Expired'); } } public function export() { $name = 'customer_' . date('Y-m-d i:h:s'); $data = Excel::download(new ProposalExport(), $name . '.xlsx'); return $data; } public function convertInvoice($proposal_id) { if (\Auth::user()->can('convert invoice proposal')) { $proposal = Proposal::where('id', $proposal_id)->first(); $proposal->is_convert = 1; $proposal->save(); $convertInvoice = new Invoice(); $convertInvoice->invoice_id = $this->invoiceNumber(); $convertInvoice->customer_id = $proposal['customer_id']; $convertInvoice->issue_date = date('Y-m-d'); $convertInvoice->due_date = date('Y-m-d'); $convertInvoice->send_date = null; $convertInvoice->category_id = $proposal['category_id']; $convertInvoice->status = 0; $convertInvoice->created_by = $proposal['created_by']; $convertInvoice->save(); $proposal->converted_invoice_id = $convertInvoice->id; $proposal->save(); if ($convertInvoice) { $proposalProduct = ProposalProduct::where('proposal_id', $proposal_id)->get(); foreach ($proposalProduct as $product) { $duplicateProduct = new InvoiceProduct(); $duplicateProduct->invoice_id = $convertInvoice->id; $duplicateProduct->product_id = $product->product_id; $duplicateProduct->quantity = $product->quantity; $duplicateProduct->tax = $product->tax; $duplicateProduct->discount = $product->discount; $duplicateProduct->price = $product->price; $duplicateProduct->save(); // inventory management (Quantity) Utility::total_quantity('minus', $duplicateProduct->quantity, $duplicateProduct->product_id); // Product Stock Report $type = 'invoice'; $type_id = $convertInvoice->id; StockReport::where('type', '=', 'invoice')->where('type_id', '=', $convertInvoice->id)->delete(); $description = $duplicateProduct->quantity . '' . __(' quantity sold in') . ' ' . \Auth::user()->proposalNumberFormat($proposal->proposal_id) . ' ' . __('Proposal convert to invoice') . ' ' . \Auth::user()->invoiceNumberFormat($convertInvoice->invoice_id); Utility::addProductStock($duplicateProduct->product_id, $duplicateProduct->quantity, $type, $description, $type_id); } } return redirect()->back()->with('success', __('Proposal to invoice convert successfully.')); } else { return redirect()->back()->with('error', __('Permission denied.')); } } function invoiceNumber() { $latest = Invoice::where('created_by', '=', \Auth::user()->creatorId())->latest()->first(); if (!$latest) { return 1; } return $latest->invoice_id + 1; } }

| ver. 1.4 | Github | . | PHP 8.1.34 | ��֧ߧ֧�ѧ�ڧ� ��ѧߧڧ��: 0.16 | proxy | phpinfo | ��ѧ��ۧܧ�