/var/www/vhosts/nabawater/backend/controllers
Edit: /var/www/vhosts/nabawater/backend/controllers/VendorPaymentController.php (6094B)
render('index', [
'searchModel' => $searchModel ,
'dataProvider' => $searchModel->search(Yii::$app->request->queryParams)
]);
}
/**
* @return string
*
* @Title("Export")
*/
public function actionExport()
{
$searchModel = new VendorPaymentSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$model = $dataProvider->query->all();
$thead = [];
$tbody = [];
$theading = [
'Vendor Name',
'Total Order Amount',
'Total Admin Profit',
'Total Vendor Profit',
'No of Orders',
];
foreach ($theading as $index => $value) {
$thead[] = Html::tag('th', $value);
}
$thead = Html::tag('thead', Html::tag('tr', implode('', $thead)));
foreach ($model as $key => $value) {
$row = [];
$row[] = Html::tag('td', $value['vendor_name']);
$row[] = Html::tag('td', $value['total_order_amount']);
$row[] = Html::tag('td', $value['total_admin_profit']);
$row[] = Html::tag('td', $value['total_vendor_profit']);
$row[] = Html::tag('td', $value['no_of_orders']);
$tbody[] = Html::tag('tr', implode('', $row));
}
$tbody = Html::tag('tbody', implode('', $tbody));
$table = Html::tag('table', $thead . $tbody);
$fileName = 'Vendor Payment Detailss'.' '.date('Y/m/d');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Content-Length: ' . strlen($table));
header('Content-type: application/vnd.ms-excel');
header('Content-type: application/octet-stream, charset=UTF-8; encoding=UTF-8');
header('Content-Disposition: attachment; filename=' .$fileName.'.xlsx');
echo $table;
Yii::$app->end();
}
public function actionPdf()
{
$searchModel = new VendorPaymentSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
$model = $dataProvider->query->all();
$out = "
";
//
$out .= "";
$out .= "| " . Yii::t('backend', 'Vendor Name') . " | ";
$out .= "" . Yii::t('backend', 'Total Order Amount') . " | ";
$out .= "" . Yii::t('backend', 'Total Admin Profit') . " | ";
$out .= "" . Yii::t('backend', 'Total Vendor Profit') . " | ";
$out .= "" . Yii::t('backend', 'No of Orders') . " | ";
$out .= "
";
foreach ($model as $key => $value) {
$out .= "";
$out .= "| " . utf8_decode(ucfirst($value['vendor_name'])) . " | ";
$out .= "" . utf8_decode(ucfirst(Com::setPriceFormat($value['total_order_amount']) )) . " | ";
$out .= "" . utf8_decode(ucfirst(Com::setPriceFormat($value['total_admin_profit']))) . " | ";
$out .= "" . utf8_decode(ucfirst(Com::setPriceFormat($value['total_vendor_profit']) )) . " | ";
$out .= "" . utf8_decode(ucfirst($value['no_of_orders'])) . " | ";
$out .= "
";
}
$out .= "
";
$fileName = 'Vendor Payment Detailss'.' '.date('Y/m/d');
// setup kartik\mpdf\Pdf component
// Sends output inline to browser
$mpdf = new mPDF();
$mpdf->WriteHTML($out);
// Saves file on the server as 'filename.pdf'
$mpdf->Output($fileName.'.pdf', \Mpdf\Output\Destination::DOWNLOAD);
exit;
}
/**
* @return Json
*
* @Title("Vendor Payment Status")
*/
public function actionChangeVendorPaymentStatus()
{
$params = ['id', 'key'];
$post = Yii::$app->getRequest()->post();
$result = ['status' => STATUS_FAIL, 'msg' => ''];
foreach ($params as $param) {
if (!array_key_exists($param, $post)) {
$result['msg'] = 'Required param missing';
goto skip;
}
}
$model = Order::find()
->select('vendor_id')
->where(['Order_key' => $post['key']])
->one();
$vendorId = Order::find()
->select('*')
->where(['vendor_id' => $model->vendor_id])
->all();
if ($model === null && $vendorId === null) {
$result['msg'] = 'Unable to find the Details';
goto skip;
} else {
foreach($vendorId as $key => $value) {
$orderModel = Order::find()
->select('*')
->where(['order_id' => $value['order_id']])
->one();
$orderModel->vendor_payment_status = $post['id'];
$orderModel->save(false);
}
}
$result['msg'] = 'Payment Status Changed Successfully';
$result['status'] = STATUS_SUCCESS;
skip:
return $this->asJson($result);
}
}