/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Receipt::find();
$query->joinWith(['estimate']);
$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(['receipt.id' => $this->id, 'receipt.estimate_id' => $this->estimate_id, 'receipt.status' => $this->status, 'receipt.created_date' => $this->created_date, 'receipt.type' => $this->type, 'receipt.iva' => $this->iva, 'estimate.client_id' => $this->client_id]);
$query->andFilterWhere(['like', 'number', $this->number]);
/**
* Convert the to dates to mysql format.
* Leave them as null so they are not used
* by ActiveQuery::andFilterWhere().
*/
$fromDate = null;
$toDate = null;
if ($this->from_date) {
$this->from_date = DateConverter::convert($this->from_date);
}
if ($this->to_date) {
$this->to_date = DateConverter::convert($this->to_date);
}
$query->andFilterWhere(['>=', 'created_date', $this->from_date]);
$query->andFilterWhere(['<=', 'created_date', $this->to_date]);
return $dataProvider;
}
/**
* @return \Illuminate\Routing\Route|null|string
*/
public function ingnoreId()
{
$id = $this->route('receipt');
$commodity_id = $this->input('commodity_id');
$supplier_id = $this->input('supplier_id');
$user_id = $this->input('user_id');
return Receipt::where(compact('id', 'commodity_id', 'supplier_id', 'user_id'))->exists() ? $id : '';
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function delete($id)
{
//Soft delete the patient
$receipt = Receipt::find($id);
$receipt->delete();
// redirect
return redirect()->to('receipt.index')->with('message', trans('messages.receipt-succesfully-deleted'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
//
$issue = Issue::find($id);
$commodities = Commodity::all()->lists('name', 'id');
$batches = Receipt::all()->lists('batch_no', 'id');
$users = User::where('id', '!=', Auth::user()->id)->lists('name', 'id');
$sections = TestCategory::all()->lists('name', 'id');
//To DO:create function for this
$available = $issue->topupRequest->commodity->available();
return view('issue.edit')->with('commodities', $commodities)->with('available', $available)->with('users', $users)->with('sections', $sections)->with('issue', $issue)->with('batches', $batches);
}
public function stockLevel()
{
// Fetch form filters
$date = date('Y-m-d');
$from = Input::get('start');
if (!$from) {
$from = date('Y-m-01');
}
$to = Input::get('end');
if (!$to) {
$to = $date;
}
$reportTypes = array('Monthly', 'Quarterly');
$selectedReport = Input::get('report_type');
if (!$selectedReport) {
$selectedReport = 0;
}
switch ($selectedReport) {
case '0':
$reportData = Receipt::getIssuedCommodities($from, $to . ' 23:59:59');
$reportTitle = Lang::choice('messages.monthly-stock-level-report-title', 1);
break;
case '1':
$reportData = Receipt::getIssuedCommodities($from, $to . ' 23:59:59');
$reportTitle = Lang::choice('messages.quarterly-stock-level-report-title', 1);
break;
default:
$reportData = Receipt::getIssuedCommodities($from, $to . ' 23:59:59');
$reportTitle = Lang::choice('messages.monthly-stock-level-report-title', 1);
break;
}
$reportTitle = str_replace("[FROM]", $from, $reportTitle);
$reportTitle = str_replace("[TO]", $to, $reportTitle);
return view('reports.inventory.index')->with('reportTypes', $reportTypes)->with('reportData', $reportData)->with('reportTitle', $reportTitle)->with('selectedReport', $selectedReport)->withInput(Input::all());
}
<div class="receipt-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'number')->textInput();
?>
<?php
echo $form->field($model, 'type')->textInput()->dropDownList(Receipt::typeLabels());
?>
<?php
echo $form->field($model, 'status')->dropDownList(Receipt::statusLabels());
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? 'Crear' : 'Editar', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
</div>
<?php
ActiveForm::end();
?>
</div>
<div class="receipt-index">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['attribute' => 'id', 'options' => ['style' => 'width: 100px;']], ['label' => 'Cliente', 'value' => 'estimate.client.name', 'filter' => Html::activeDropDownList($searchModel, 'client_id', Client::getIdNameArray(), ['class' => 'form-control', 'prompt' => 'Nombre'])], ['label' => 'Presupuesto', 'value' => 'estimate.title'], 'number', ['class' => 'kartik\\grid\\EditableColumn', 'attribute' => 'status', 'label' => 'Estado', 'value' => 'statusLabel', 'filter' => Html::activeDropDownList($searchModel, 'status', Receipt::statusLabels(), ['class' => 'form-control', 'prompt' => 'Estado']), 'editableOptions' => ['inputType' => Editable::INPUT_DROPDOWN_LIST, 'data' => Receipt::statusLabels()]], ['attribute' => 'created_date', 'format' => 'date', 'filter' => false], ['class' => 'yii\\grid\\ActionColumn']]]);
?>
<?php
echo ExportMenu::widget(['dataProvider' => $exportDataProvider, 'target' => ExportMenu::TARGET_SELF, 'showConfirmAlert' => false, 'filename' => 'facturas', 'columns' => [['attribute' => 'created_date', 'format' => 'date', 'filter' => false], ['attribute' => 'type', 'value' => 'typeLabel'], ['attribute' => 'number', 'label' => 'Factura Nro'], ['label' => 'Cliente', 'value' => 'estimate.client.name'], ['label' => 'CUIT', 'value' => 'estimate.client.cuit'], ['label' => 'Facturación Neta', 'value' => function ($model, $key, $index, $column) {
return Currency::format($model->estimate->total_checked, Currency::CURRENCY_ARS);
}], ['label' => 'IVA', 'value' => function ($model, $key, $index, $column) {
return Currency::format($model->IVATotal, Currency::CURRENCY_ARS);
}], ['label' => 'Facturación Bruta', 'value' => function ($model, $key, $index, $column) {
return Currency::format($model->gross, Currency::CURRENCY_ARS);
}], ['label' => 'Utilidad', 'value' => function ($model, $key, $index, $column) {
return Currency::format($model->estimate->total_checked - $model->estimate->cost_checked, Currency::CURRENCY_ARS);
}], ['label' => 'Porcentaje', 'value' => null], ['label' => 'Productos', 'value' => 'products'], ['label' => 'Estado', 'value' => 'statusLabel'], ['label' => 'Recibo Nro', 'value' => null]]]);
?>
</div>
/**
* @return \yii\db\ActiveQuery
*/
public function getReceipt()
{
return $this->hasOne(Receipt::className(), ['estimate_id' => 'id']);
}
/**
* Finds the Receipt model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Receipt the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Receipt::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
