public function actionInvoice($id)
{
if (Yii::$app->user->identity->type == 'normal') {
return $this->redirect(['update', 'id' => $id]);
}
$admin_id = Yii::$app->user->identity->id;
$model = $this->findModel($id);
$invoice = Invoice::find();
$invoice = $invoice->where('job_id=' . $id);
$invoice = $invoice->orderBy('id DESC');
$invoice = $invoice->asArray();
$invoice = $invoice->limit(1);
$invoice = $invoice->all();
// $companies = Company::find();
// if(Yii::$app->user->identity->type=='normal'){
// $companies = $companies->innerJoin('wolf_admin_to_company wc','wc.company_id=wolf_company.company_id');
// $companies = $companies->where('admin_id='.$admin_id);
// }
// $companies = $companies->orderBy('company_name');
// $companies = $companies->asArray();
// $companies = $companies->all();
$jobScheduleSearch = new JobScheduleSearch(['job_id' => $id]);
$scheduleData = $jobScheduleSearch->search(Yii::$app->request->getQueryParams());
$scheduleData->pagination->pageSize = -1;
//infinite value
return $this->render('invoice', ['model' => $this->findModel($id), 'scheduleData' => $scheduleData, 'jobScheduleSearch' => $jobScheduleSearch, 'invoice' => $invoice]);
}
public function update($id, Request $request)
{
$invoice = Invoice::find($id);
$rules = $invoice->getValidatorRules();
$validator = $this->validate($request, $rules);
if ($validator) {
return response()->json($validator, '404');
}
$input = $request->all();
$invoice->update($input);
/**
|-----------------------------------------------------
| Add customer to invoice
|-----------------------------------------------------
*/
$customer_id = $request->get('customer')['id'];
$customer = Customer::find($customer_id);
$invoice->updateCustomerWithShippingAddress($customer);
/**
|-----------------------------------------------------
| Add list products to invoice
|-----------------------------------------------------
*/
$invoice->addProductItems($request->get('items'));
/**
|-----------------------------------------------------
| Save to Db
|-----------------------------------------------------
*/
redirect()->route('sale.invoice.show', [$invoice], 302);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Invoice::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'zip' => $this->zip]);
$query->andFilterWhere(['like', 'business_name', $this->business_name])->andFilterWhere(['like', 'rfc', $this->rfc])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'state', $this->state])->andFilterWhere(['like', 'email', $this->email]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Invoice::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'job_id' => $this->job_id, 'company_id' => $this->company_id, 'invoice_date' => $this->invoice_date]);
$query->andFilterWhere(['like', 'invoice_no', $this->invoice_no]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = InvoiceModel::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'amount' => $this->amount]);
if (isset($params['user'])) {
$query->andFilterWhere(['user_name' => $params['user']]);
}
$query->andFilterWhere(['like', 'user_name', $this->user_name])->andFilterWhere(['like', 'status', $this->status]);
return $dataProvider;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
try {
$admin = \Auth::User();
if (!$admin) {
return $this->failResponse('admin not logged in');
}
$invoiceObj = Invoice::find($id);
if (count($invoiceObj) == 0) {
return $this->failResponse('customer id not found');
}
$invoiceObj->delete();
return $this->successResponse('customer deleted successfully');
} catch (\Exception $e) {
Log::error("error in customer controller");
return $this->failResponse($e->getMessage());
}
}