public function getPublisher() { if (Session::get('reviewPid')) { return PublisherBaseModel::find(Session::get('reviewPid')); } else { if ($this->user) { return $this->user->publisher; } else { return FALSE; } } }
public function getPdf() { $datemonth = Input::get('datemonth'); if ($datemonth) { if ($datemonth != null) { $datemonth >= 1 && $datemonth <= 9 ? $month = '0' . $datemonth : ($month = $datemonth); $flight = new FlightWebsiteBaseModel(); $start_date = date('Y', time()) . '-' . $month . '-01'; $end_date = date('Y', time()) . '-' . $month . '-' . date('t', strtotime($start_date)); $idpublisher = $this->getPublisher()->id; // get Campagin da chay $camend = $flight->join('campaign', 'campaign.id', '=', 'flight.campaign_id')->join('flight', 'flight.id', '=', 'flight_website.flight_id')->where('campaign.start_date', '>=', $start_date)->where('campaign.end_date', '<=', $end_date)->where('flight_website.website_id', '=', $idpublisher)->select(array('campaign.name as campaignname', 'campaign.start_date', 'campaign.end_date', 'campaign.sale_order_tax', 'flight_website.*'))->get(); $camend = $this->sumEarnings($camend, $start_date, $end_date); pr($camend, 1); //$camend = $this->sumEarnings($camend, $start_date, $end_date); //// get Campagin dang chay $camrun = $flight->join('campaign', 'campaign.id', '=', 'flight.campaign_id')->join('flight', 'flight.id', '=', 'flight_website.flight_id')->where('campaign.start_date', '<', $end_date)->where('campaign.end_date', '>', date("Y-m-d", time()))->where('flight_website.website_id', '=', $idpublisher)->select(array('campaign.name as campaignname', 'campaign.start_date', 'campaign.end_date', 'campaign.sale_order_tax', 'flight_website.*'))->get(); if (count($camrun) == 0 && count($camend) == 0) { $_SESSION['error'] = "No data"; return Redirect::to($this->moduleURL . 'get-invoice'); } $camrun = $this->sumEarnings($camrun, $start_date, $end_date); $publisher = PublisherBaseModel::find($idpublisher); $param['datemonth'] = $datemonth; $param['camend'] = $camend; $param['mont'] = $start_date; $param['camrun'] = $camrun; $param['publisher'] = $publisher; $param['pinetech'] = ConfigBaseModel::find(1); if ($param['pinetech'] == null) { $pinetech = new stdClass(); $pinetech->name = "N/A"; $pinetech->address = "N/A"; $pinetech->state = "N/A"; $pinetech->city = "N/A"; $pinetech->country = "N/A"; $param['pinetech'] = $pinetech; } $pdf = PDF::loadView('getInvoicePdf', $param)->setPaper('a4')->setWarnings(false); $file = "Invoice_" . $publisher->id . "_" . $publisher->company . "_" . date('M_Y', strtotime($start_date)) . '.pdf'; return $pdf->download($file); } else { return Redirect::to($this->moduleURL . 'get-invoice'); } } else { return Redirect::to($this->moduleURL . 'get-invoice'); } }