public function exportExcelPaymentDetail($id) { $model = new PaymentRequestDetailBaseModel(); $data['data'] = $model->getItemsByPaymentRequestId($id); if (count($data['data']) > 0) { $data['publisher'] = $data['data']['0']->publisher; if ($data['publisher']) { $pid = $data['publisher']->id; $data['pubName'] = PublisherBaseModel::getPublisherName($pid); } else { $data['pubName'] = ''; } return $model->exportExcel($data); } else { return Redirect::to($this->moduleURL . 'payment-request/waiting'); } }
public function createMonthlyPaymentRequest() { $startDate = Carbon::now()->firstOfMonth()->subMonth(); $endDate = Carbon::now()->firstOfMonth()->subMonth()->lastOfMonth(); $date = $startDate->format('Y-m'); $check = PaymentRequestBaseModel::where(array('publisher_id' => $this->id, 'date' => $date))->first(); $websiteLists = $this->publisherSite->lists('id'); if (empty($check)) { $tracking = new TrackingSummaryBaseModel(); $data = $tracking->sumEarnPerCampaign($websiteLists, $startDate, $endDate); $campaigns = $data['campaign']; $total = $data['total']; $pr = new PaymentRequestBaseModel(); $pr->publisher_id = $this->id; $pr->date = $date; $pr->amount = $total; $pr->save(); if (!empty($campaigns)) { foreach ($campaigns as $campaignID => $campaign) { $prd = new PaymentRequestDetailBaseModel(); $prd->publisher_id = $this->id; $prd->campaign_id = $campaignID; $prd->amount = $campaign['cost']; $prd->impression = $campaign['impression']; $prd->click = $campaign['click']; if ($campaign['click'] != 0 && $campaign['impression'] != 0) { $prd->ctr = $campaign['click'] / $campaign['impression']; } else { $prd->ctr = 0; } $prd->date = $date; $prd->payment_request_id = $pr->id; $prd->save(); } } } }
public function exportExcelPaymentDetail($id) { $model = new PaymentRequestDetailBaseModel(); $data['data'] = $model->getItemsByPaymentRequestId($id); if (count($data['data']) > 0) { $data['publisher'] = $data['data']['0']->publisher; $data['pubName'] = Sentry::getUser()->username; return $model->exportExcel($data); } else { return Redirect::to($this->moduleURL . 'payment-request'); } }