/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
//
$validator = Validator::make($request->all(), ['name' => 'required|unique:papers', 'size' => 'required|unique:papers']);
if ($validator->fails()) {
if ($request->ajax()) {
return response()->json($validator->messages());
exit;
} else {
return \Redirect::back()->withErrors($validator)->withInput();
}
}
array_forget($request, "_token");
$all_request = $request->all();
$paper = new Paper();
foreach ($all_request as $key => $value) {
$paper->{$key} = $value;
}
$paper->save();
$papers = Paper::all();
if ($request->ajax()) {
if ($papers) {
foreach ($papers as $paper) {
echo "\n <tr>\n <td>{$paper->id}</td>\n <td>{$paper->name}</td>\n <td>{$paper->description}</td>\n <td>{$paper->dimension}</td>\n <td>{$paper->unit}</td>\n\n <td><button class='edtPaperLink btn-primary' cid='{$paper->id}' cname='{$paper->name}' cdescription='{$paper->description}' cdimension='{$paper->dimension}' cunit='{$paper->unit}'><span class='glyphicon glyphicon-pencil'></span></button></td>\n <td><button class='btn-danger' data-target='#myModalPaperEdit' data-toggle='modal'><span class='glyphicon glyphicon-trash'></span></button></td>\n </tr>\n ";
}
}
exit;
}
return View("settings.paper", ["companies" => Company::all(), 'papers' => $papers, 'title' => 'Job Papers Setting']);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$dataView = array();
$dataView['page_title'] = "Compañías";
$dataView['companies'] = Company::all();
return view('company.index', $dataView);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$companies = Company::all();
$accountancies = Accountancy::all();
return view('admin.accountancy.index')->with(['companies' => $companies, 'accountancies' => $accountancies]);
}
public function edit($id)
{
$userName = Auth::user()->name;
$companies = Company::all();
$campain = Campain::find($id);
return view('campain.edit', ['userName' => $userName, 'companies' => $companies, 'campain' => $campain]);
}
public function showSettings()
{
$companies = \App\Company::all()->lists('name', 'id');
$current_company = \App\Company::find(Auth::user()->current_company);
// dd($current_company);
return view('settings.settings', compact('companies', 'current_company'));
}
public function index()
{
$data['is_showzhiye'] = Zhiye::where('z_show', '=', '1')->get();
$data['allzhiye'] = Zhiye::all();
$data['is_showcompany'] = Company::where('c_show', '=', '1')->get();
$data['allcompany'] = Company::all();
$data['alltime'] = Time::all();
return view('contestRoom.index', $data);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (Auth::user()->hasRole('member')) {
$companies = Company::where('comUserId', '=', Auth::user()->id)->get();
} else {
$companies = Company::all()->sortBy('comName');
}
return view('company.index', compact('companies'));
}
function index()
{
$user = Auth::user();
$posts = Post::latest('id')->get();
$companies = Company::all();
$users = User::all();
$testvar = "XYZABC";
return view('users.test', compact('testvar'));
return view('users.index', compact('user', 'posts', 'companies', 'users'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$query = Company::all('id', 'name')->toArray();
// TODO: Rework this to be more efficient. Could probably be done in a
// shorter way.
$companies = [];
foreach ($query as $row) {
$companies[$row['id']] = $row['name'];
}
return view('expenses/create')->with('companies', $companies);
}
public function run()
{
$contacts = \App\Contact::all();
$companies = \App\Company::all();
for ($i = 0; $i < 20; $i++) {
try {
$contacts->random()->companies()->attach($companies->random());
} catch (\Exception $e) {
}
}
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$products = Product::all();
$weeknrs = getWeeknumbers();
if (Auth::user()->hasRole('member')) {
$companies = Company::where('comUserId', '=', Auth::user()->id)->get();
} else {
$companies = Company::all();
}
$providers = Provider::all();
return view('allocatie.create', compact('products', 'companies', 'weeknrs', 'providers'));
}
public function companies()
{
$userName = Auth::user()->name;
$companies = Company::all();
$results = [];
foreach ($companies as $company) {
$company_id = $company->id;
$campains = DB::table('campains')->where('company_id', '=', $company_id)->get();
$totalGain = 0;
$totalInvestment = 1;
foreach ($campains as $campain) {
$totalGain = $totalGain + $campain->gain;
$totalInvestment = $totalInvestment + $campain->cost;
}
$roi = ($totalGain - $totalInvestment) / $totalInvestment;
$roi = number_format($roi, 2);
$results[] = ["name" => $company->name, "roi" => $roi];
}
return view('report.companies', ['userName' => $userName, 'results' => $results]);
}
public function months($months)
{
Excel::create('通讯报销汇总_' . $months, function ($excel) use($months) {
$companies = Company::all();
foreach ($companies as $company) {
$excel->sheet('new Sheet', function ($sheet) use($company, $months) {
$sheet->setAllBorders('thin');
// Set border for cells
$sheet->setBorder('A1', 'thin');
// Font family
$sheet->setFontFamily('Comic Sans MS');
// Set font with ->setStyle()`
$sheet->setStyle(array('font' => array('name' => 'Calibri', 'size' => 11, 'bold' => false)));
$sum = \App\MobileFees::where('company_id', $company->id)->where('months', $months)->with('company', 'employee')->sum('fee');
$mobilefees = \App\MobileFees::where('company_id', $company->id)->where('months', $months)->with('company', 'employee')->get();
$sheet->loadView('report.index')->with('mobilefees', $mobilefees)->with('sum', $sum)->with('company_name', $company->name);
});
}
})->download('xls');
}
/**
* create exhibitor by admin
*
* @return Response
*/
public function createexhibitorbyadmin()
{
$countries = Country::all();
$companies = Company::all();
return view('AdminCP.exhibitors.create', compact('countries', 'companies'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
//
return View("administrators.edituser", ["companies" => Company::all(), "myuser" => User::find($id), "myrole" => \DB::table("role_user")->where("user_id", $id)->get(), "roles" => \DB::table("roles")->get(), "title" => "Edit User"]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
return Company::all();
}
public function getPrice(Request $request, $compid)
{
//
$mcompany = Company::find($compid);
$jobprices = \DB::table("prices")->where("company_id", $compid)->get();
return View("settings.price", ["companies" => Company::all(), "mcompany" => $mcompany, 'prices' => $jobprices, "companyname" => $mcompany->name, 'papers' => Paper::all(), 'jobs' => Job::all(), 'title' => 'Job Price Setting']);
}
public function Index()
{
return View("dashboard", ["companies" => Company::all()]);
}
/**
* Show the profile for the given user. Yay
*
* @param int $id
* @return Response
*/
public function index()
{
$companies = Company::all();
$types = Category::all();
return view('pages.home', ['companies' => $companies, 'types' => $types]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$company = Company::all();
return $company;
}
Route::post('auth/login', 'Auth\\AuthController@postLogin');
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
// 注册路由...
Route::get('auth/register', 'Auth\\AuthController@getRegister');
Route::post('auth/register', 'Auth\\AuthController@postRegister');
Route::resource('upload', 'UploadController');
Route::resource('employee', 'EmployeeController');
Route::get('report/{month?}', 'ReportController@index')->where('month', '(\\d)(\\d)(\\d)(\\d)-[0-1]?[1-9]-[0-3]?[1-9]');
//Route::get('report/{month?}','ReportController@index');
Route::resource('report', 'ReportController');
Route::get('export', function () {
Excel::create('Filename', function ($excel) {
// Call writer methods here
$excel->setTitle('Our new awesome title');
// Chain the setters
$excel->setCreator('Maatwebsite')->setCompany('Maatwebsite');
// Call them separately
$excel->setDescription('A demonstration to change the file properties');
$companys = Company::all();
foreach ($companys as $company) {
$this->company_name = $company->name;
$this->company_id = $company->id;
$excel->sheet($this->company_name, function ($sheet) {
$employees = \App\Reportview::where('公司', $this->company_name)->get()->toArray();
$sum = \App\Reportview::sum('费用');
dd($sum);
$sheet->with($employees);
});
}
})->export('xlsx');
});
public function getCompanies()
{
return view('admin.companies', ['companies' => Company::all()]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$companies = Company::all();
return view('company.index', array('title' => 'Video game companies', 'page_h1' => 'Video game companies', 'companies' => $companies));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
return View("privileges.index", ["companies" => Company::all(), 'roles' => Role::all(), 'permissions' => Permission::all(), 'title' => 'Roles and Privileges']);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$companies = Company::all();
return view('companies/index')->with('companies', $companies);
}
public static function getCompanyDetails()
{
return Company::all()->first();
}
public function generateInvoice(Request $request, $id = "")
{
$input = $request->all();
$company = !empty($id) ? Company::find($id) : Company::find($input['company_id']);
$ArrMain = [];
// print_r($input);
if (count($input) > 0) {
//allow room for invoice to be processed for recent uploaded and date range
$stacks = Invoicingstack::where("company_id", "=", $company->id)->where("status", "=", 0)->get();
// var_dump("ok ok");
} else {
$stacks = Invoicingstack::where("company_id", "=", $company->id)->where("status", "=", 0)->get();
}
//$input['id']=$id;
$total = 0;
$bill = new Bill();
$invoiceno = "";
if (count($stacks) > 0) {
$bill_no = $bill->genInvoiceNo($company->id) > 0 ? $bill->genInvoiceNo($company->id) : "01";
$invoiceno = !empty($input['inv_no']) && $input['inv_no'] != "" ? "RJLEX/" . strtoupper(substr($company->name, 0, 3)) . "/" . $input['inv_no'] : "RJLEX/" . strtoupper(substr($company->name, 0, 3)) . "/" . str_pad($bill_no, 3, "0", STR_PAD_LEFT);
$bill->invoice_no = $invoiceno;
$bill->created_at = date("Y-m-d H:i:s");
$bill->updated_at = date("Y-m-d H:i:s");
$bill->company_id = $company->id;
$bill->invoice_date = date("Y-m-d H:i:s");
$check = Bill::where("invoice_no", "=", $invoiceno)->pluck("invoice_no");
if (!empty($check)) {
echo "Invoice number already existing in database";
exit;
}
$bill->save();
//$invoiceno = "RJLEX/".strtoupper(substr($company->name,0,3))."/".$bill->genInvoiceNo();
}
$dateFrom = "2000-01-01";
$dateTo = "2000-01-01";
$objPHPExcel = new \PHPExcel();
$m = 0;
$s = 0;
foreach ($stacks as $stack) {
// Create a new worksheet called “My Data”
$s++;
$sheetName = "RJLEX_" . strtoupper(substr($company->name, 0, 3)) . "_" . $bill_no;
$siteName = Branch::where("id", "=", $stack->site_id)->pluck("name");
$myWorkSheet = new \PHPExcel_Worksheet($objPHPExcel, $siteName);
$objPHPExcel->addSheet($myWorkSheet, $m);
/**/
$objPHPExcel->setActiveSheetIndex($m);
$m++;
$site = "";
$siteName = "";
$description = "";
$printNo = 0;
$copyNo = 0;
/**
* For each loop of the invoicing table,
* compute the cost of each print job and populate/create
* the invoice detail table
*/
$a3Arr = [];
$a4Arr = [];
$sumNoPagesA3Color = 0;
//+= $minvoice->number_of_pages;
$sumAmountA3Color = 0;
//$amount;
$sumNoPagesA4Color = 0;
// $minvoice->number_of_pages;
$sumAmountA4Color = 0;
//$amount;
$sumNoPagesA3Mono = 0;
// $minvoice->number_of_pages;
$sumAmountA3Mono = 0;
$sumNoPagesA4Mono = 0;
//0 $minvoice->number_of_pages;
$sumAmountA4Mono = 0;
//$amount;
$sumTotal = 0;
$unitCostA3Mono = 0;
$unitCostA4Mono = 0;
$unitCostA3Color = 0;
$unitCostA4Color = 0;
$x = 1;
$p = 1;
if (count($input) > 0) {
$invoicing = DB::table("invoicing")->where("stack_id", "=", $stack->id)->get();
//->where("final_date",">=",$input['date_from'])->where("final_date","<=","date_to")
} else {
$invoicing = DB::table("invoicing")->where("stack_id", "=", $stack->id)->get();
}
//$dateFrom = DB::table("invoicing")->where("stack_id","=",$stack->id)->max('final_date'); //DB::table("invoicing")->where()
//$dateTo = DB::table("invoicing")->where("stack_id","=",$stack->id)->min('final_date');
foreach ($invoicing as $minvoice) {
//One Location in loop
$froDate = new \DateTime("2000-01-01");
$toDate = new \DateTime("2000-01-01");
if ($x == 1) {
//$dateFrom = new \DateTime($minvoice->final_date);
//$dateTo = new \DateTime($minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('A' . $x, "SITE");
$objPHPExcel->getActiveSheet()->setCellValue('B' . $x, "User ID");
$objPHPExcel->getActiveSheet()->setCellValue('C' . $x, "Submit IP");
$objPHPExcel->getActiveSheet()->setCellValue('D' . $x, "Print Job Name");
$objPHPExcel->getActiveSheet()->setCellValue('E' . $x, "Submit Date");
$objPHPExcel->getActiveSheet()->setCellValue('F' . $x, "Final Date");
$objPHPExcel->getActiveSheet()->setCellValue('G' . $x, "Final Action");
$objPHPExcel->getActiveSheet()->setCellValue('H' . $x, "Final Site");
$objPHPExcel->getActiveSheet()->setCellValue('I' . $x, "Number of Pages");
$objPHPExcel->getActiveSheet()->setCellValue('J' . $x, "Cost Per Page");
$objPHPExcel->getActiveSheet()->setCellValue('K' . $x, "Total Cost");
$objPHPExcel->getActiveSheet()->setCellValue('L' . $x, "Release IP");
$objPHPExcel->getActiveSheet()->setCellValue('M' . $x, "Release User");
$objPHPExcel->getActiveSheet()->setCellValue('N' . $x, "Release Method");
$objPHPExcel->getActiveSheet()->setCellValue('O' . $x, "Print Job Color");
$objPHPExcel->getActiveSheet()->setCellValue('P' . $x, "Print Job Duplex");
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $x, "Print Job Paper Size");
$objPHPExcel->getActiveSheet()->setCellValue('R' . $x, "Release Model");
$objPHPExcel->getActiveSheet()->setCellValue('S' . $x, "Release Model Type");
$objPHPExcel->getActiveSheet()->setCellValue('T' . $x, "Rrelease Host Name");
}
//$date = date_create_from_format("Y-m-d H:i:s",$minvoice->final_date);
if (isset($input['date_from'])) {
$dateFrom = $input['date_from'];
} else {
/*$froDate = $dateFrom;
if( (int)$date->getTimestamp() <= (int)$froDate->getTimestamp() ){
$dateFrom = new \DateTime($minvoice->final_date);
}*/
}
if (isset($input['date_to'])) {
$dateTo = $input['date_to'];
} else {
/*$toDate = $dateTo;
if( (int)$date->getTimestamp() >= (int)$toDate->getTimestamp() ){
$dateTo = new \DateTime($minvoice->final_date);
}*/
}
$site = Branch::where("id", "=", $minvoice->site)->pluck("name");
$a3Arr[] = "";
$a4Arr[] = "";
// if($minvoice->job_paper_size == "A3"){}
$paperid = DB::table("papers")->where("name", $minvoice->job_paper_size)->pluck("id");
if (strtolower($minvoice->final_action) == "p" || strtolower($minvoice->final_action) == "c") {
//check if action type is print
/**
* check if colored or mono
*/
$p++;
if (strtolower($minvoice->device_type) == "c") {
if (strtolower($minvoice->job_color) == "y") {
if ($minvoice->job_paper_size == "A3" || ($minvoice->job_paper_size == "Tabloid" || $minvoice->job_paper_size == "Ledger")) {
if (strtolower($minvoice->device_name) == 'lexmark x925' || strtolower($minvoice->device_name) == 'lexmark x950' || strtolower($minvoice->device_name) == 'lexmark x950de' || strtolower($minvoice->device_name) == 'lexmark x792de' || strtolower($minvoice->device_name) == 'lexmark cx510de') {
$cost = Price::where("job_id", 1)->where("job_type", "color")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA3Color += $minvoice->number_of_pages;
$sumAmountA3Color += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA3Color = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "Y");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
} elseif (strtolower($minvoice->device_name) == 'lexmark x860') {
# else if Lexmark X860 (a mono A3 printer) //|| strtolower($minvoice->device_name) == 'lexmark x860de'
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA3Mono += $minvoice->number_of_pages;
$sumAmountA3Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA3Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
} else {
# otherwise its an A4 job for color not A3 as may be indicated in datafile but A4
$cost = Price::where("job_id", 1)->where("job_type", "color")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Color += $minvoice->number_of_pages;
$sumAmountA4Color += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Color = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "Y");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
} else {
$cost = Price::where("job_id", 1)->where("job_type", "color")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Color += $minvoice->number_of_pages;
$sumAmountA4Color += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Color = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "Y");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
} elseif (strtolower($minvoice->job_color) == "n") {
if ($minvoice->job_paper_size == "A3" || ($minvoice->job_paper_size == "Tabloid" || $minvoice->job_paper_size == "Ledger")) {
//&&
if (strtolower($minvoice->device_name) == 'lexmark mx860') {
//de
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA3Mono += $minvoice->number_of_pages;
$sumAmountA3Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA3Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
} elseif (strtolower($minvoice->device_name) == 'lexmark x925' || strtolower($minvoice->device_name) == 'lexmark x950' || strtolower($minvoice->device_name) == 'lexmark x950de' || strtolower($minvoice->device_name) == 'lexmark x792de' || strtolower($minvoice->device_name) == 'lexmark cx510de') {
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA3Mono += $minvoice->number_of_pages;
$sumAmountA3Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA3Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
} else {
# otherwise its an A4 job for mono not A3 as may be indicated in datafile
/** Print is a mono device*/
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Mono += $minvoice->number_of_pages;
$sumAmountA4Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
} else {
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Mono += $minvoice->number_of_pages;
$sumAmountA4Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
}
} elseif (strtolower($minvoice->device_type) == "m") {
if ($minvoice->job_paper_size == "A3" || ($minvoice->job_paper_size == "Tabloid" || $minvoice->job_paper_size == "Ledger")) {
#if device type is a mono and paper is A3
if (strtolower($minvoice->device_name) == 'lexmark mx860') {
#de we need to be sure its an lexmark mx860de device
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA3Mono += $minvoice->number_of_pages;
$sumAmountA3Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA3Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
} elseif (strtolower($minvoice->device_name) == 'lexmark x654de' || strtolower($minvoice->device_name) == 'lexmark x654' || (strtolower($minvoice->device_name) == 'lexmark t656' || strtolower($minvoice->device_name) == 'lexmark t656de')) {
# otherwise its an A4 job for mono not A3 as may be indicated in script
$paperid = DB::table("papers")->where("name", "A4")->pluck("id");
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Mono += $minvoice->number_of_pages;
$sumAmountA4Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, "A4");
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
} else {
$cost = Price::where("job_id", 1)->where("job_type", "mono")->where("paper_id", $paperid)->pluck("price");
$amount = $cost * $minvoice->number_of_pages;
$sumNoPagesA4Mono += $minvoice->number_of_pages;
$sumAmountA4Mono += $amount;
//not longer neccessory because cumulated pages could be multiplied by the unit cost
$unitCostA4Mono = $cost;
$objPHPExcel->getActiveSheet()->setCellValue('A' . $p, $site);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $p, $minvoice->user);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $p, $minvoice->ip);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $p, $minvoice->job_title);
$objPHPExcel->getActiveSheet()->setCellValue('E' . $p, $minvoice->submit_date);
$objPHPExcel->getActiveSheet()->setCellValue('F' . $p, $minvoice->final_date);
$objPHPExcel->getActiveSheet()->setCellValue('G' . $p, $minvoice->final_action);
$objPHPExcel->getActiveSheet()->setCellValue('H' . $p, $minvoice->final_site);
$objPHPExcel->getActiveSheet()->setCellValue('I' . $p, $minvoice->number_of_pages);
$objPHPExcel->getActiveSheet()->setCellValue('J' . $p, $cost);
$objPHPExcel->getActiveSheet()->setCellValue('K' . $p, $amount);
$objPHPExcel->getActiveSheet()->setCellValue('L' . $p, $minvoice->release_ip);
$objPHPExcel->getActiveSheet()->setCellValue('M' . $p, $minvoice->release_user);
$objPHPExcel->getActiveSheet()->setCellValue('N' . $p, $minvoice->release_method);
$objPHPExcel->getActiveSheet()->setCellValue('O' . $p, "N");
//
$objPHPExcel->getActiveSheet()->setCellValue('P' . $p, $minvoice->print_job_duplex);
//duplex
$objPHPExcel->getActiveSheet()->setCellValue('Q' . $p, $minvoice->job_paper_size);
$objPHPExcel->getActiveSheet()->setCellValue('R' . $p, $minvoice->device_name);
$objPHPExcel->getActiveSheet()->setCellValue('S' . $p, $minvoice->device_type);
$objPHPExcel->getActiveSheet()->setCellValue('T' . $p, $minvoice->device_host);
}
}
$printNo++;
}
$x++;
}
//End of invoicing loop
$b = $p + 5;
$sumAmountA3Color = $sumNoPagesA3Color * $unitCostA3Color;
$sumAmountA3Mono = $sumNoPagesA3Mono * $unitCostA3Mono;
$sumAmountA4Color = $sumNoPagesA4Color * $unitCostA4Color;
$sumAmountA4Mono = $sumNoPagesA4Mono * $unitCostA4Mono;
/**
* Sum total of all net
* amounts
*/
$sumTotal += $sumAmountA4Mono;
$sumTotal += $sumAmountA3Mono;
$sumTotal += $sumAmountA4Color;
$sumTotal += $sumAmountA3Color;
$a3Arr = ["a3mono" => ["nopages" => $sumNoPagesA3Mono, "unitcost" => $unitCostA3Mono, "netamount" => $sumAmountA3Mono], "a3color" => ["nopages" => $sumNoPagesA3Color, "unitcost" => $unitCostA3Color, "netamount" => $sumAmountA3Color]];
if ($sumNoPagesA3Mono > 0) {
DB::table("invoice_detail")->insert(['invoice_id' => $bill->id, 'branch_id' => $minvoice->site, 'location' => $site, 'un_identity' => 'A3 Mono', 'description' => "Print / Copy Mono A3", 'no_of_pages' => $sumNoPagesA3Mono, 'cost_per_page' => $unitCostA3Mono, 'paper_size' => "A3", 'amount' => $sumAmountA3Mono, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]);
}
if ($sumNoPagesA3Color > 0) {
DB::table("invoice_detail")->insert(['invoice_id' => $bill->id, 'branch_id' => $minvoice->site, 'location' => $site, 'un_identity' => 'A3 Color', 'description' => "Print / Copy Color A3", 'no_of_pages' => $sumNoPagesA3Color, 'cost_per_page' => $unitCostA3Color, 'paper_size' => "A3", 'amount' => $sumAmountA3Color, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]);
}
if ($sumNoPagesA4Mono > 0) {
DB::table("invoice_detail")->insert(['invoice_id' => $bill->id, 'branch_id' => $minvoice->site, 'location' => $site, 'un_identity' => 'A4 Mono', 'description' => "Print / Copy Mono A4", 'no_of_pages' => $sumNoPagesA4Mono, 'cost_per_page' => $unitCostA4Mono, 'paper_size' => "A4", 'amount' => $sumAmountA4Mono, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]);
}
if ($sumNoPagesA4Color > 0) {
DB::table("invoice_detail")->insert(['invoice_id' => $bill->id, 'branch_id' => $minvoice->site, 'location' => $site, 'un_identity' => 'A4 Color', 'description' => "Print / Copy Color A4", 'no_of_pages' => $sumNoPagesA4Color, 'cost_per_page' => $unitCostA4Color, 'paper_size' => "A4", 'amount' => $sumAmountA4Color, 'created_at' => date("Y-m-d H:i:s"), 'updated_at' => date("Y-m-d H:i:s")]);
}
$a4Arr = ["a4mono" => ["nopages" => $sumNoPagesA4Mono, "unitcost" => $unitCostA4Mono, "netamount" => $sumAmountA4Mono], "a4color" => ["nopages" => $sumNoPagesA4Color, "unitcost" => $unitCostA4Color, "netamount" => $sumAmountA4Color]];
array_push($ArrMain, ["site" => $site, "a4" => $a4Arr, "a3" => $a3Arr, "sumTotal" => $sumTotal]);
$total += $sumTotal;
$stack->status = 1;
$stack->update();
}
// End of stack loop
if (isset($input['date_from']) && isset($input['date_to'])) {
$duration = date_format(date_create($input['date_from']), "d M. Y") . " - " . date_format(date_create($input['date_to']), "d M. Y");
} else {
// $duration = date_format($dateFrom ,"d M. Y") ." - ". date_format($dateTo,"d M. Y");
}
define('BUDGETS_DIR', public_path() . "/invoicexlxs/");
// I define this in a constants.php file
$pdfPath = "";
if (!is_dir(BUDGETS_DIR)) {
mkdir(BUDGETS_DIR, 0755, true);
}
$fileurl = "RJLEX_" . strtoupper(substr($company->name, 0, 3)) . "_" . date("Y-M-d") . "_" . time();
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objWriter->save(BUDGETS_DIR . $fileurl . ".xlsx");
$outputName = $fileurl . ".pdf";
// str_random is a [Laravel helper](http://laravel.com/docs/helpers#strings)
$pdfPath = BUDGETS_DIR . $outputName;
$bill->pdf_url = $outputName;
// File::put($pdfPath, PDF::loadView($pdf, 'A4', 'portrait')->output());
$bill->subtotal = $total;
$bill->tax = 5 / 100 * $total;
$bill->total = $total + $bill->tax;
$bill->invoice_date = date("Y-m-d H:i:s");
$bill->duration = $duration;
$bill->file_url = $fileurl . ".xlsx";
$bill->update();
$input["invoice"] = $bill;
$invoiceItems = DB::table("invoice_detail")->where("invoice_id", $bill->id)->groupBy("location")->get();
$input["invoiceItems"] = $invoiceItems;
//$pdf = new PDF($dompdf, $config, $app['files'], $app['view']);
$pdf = App::make('dompdf.wrapper');
//$pdf->set_base_path(public_path()."/bootstrap");->download($outputName)
$pdf->loadView('invoicing.invoicepdf', $input)->setPaper('a4')->setOrientation('landscape')->save($pdfPath);
//return $pdf->download($outputName);
return View("invoicing.invoice", ["companies" => Company::all(), 'invoice' => $bill, "total" => $total, "company" => $company, "branches" => Branch::where("company_id", $company->id)->get(), "invoiceDatum" => $ArrMain, "title" => "Invoice"]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$companies = Company::all();
return view('estabelecimentos.index', compact('companies'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
$companies = Company::all();
return view('companies.index', compact('companies'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$companies = Company::all();
return view('admin.company.index')->with(['companies' => $companies]);
}
