/**
* Finds the Cliente model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param string $nome
* @param string $tel
* @return Cliente the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($nome, $tel)
{
if (($model = Cliente::findOne(['nome' => $nome, 'tel' => $tel])) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Finds the Cliente model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Cliente the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Cliente::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionPromissoria2($id, $idvenda)
{
//Criação de objetos para a geração do relatório
$model = Cliente::findOne($id);
$model2 = Venda::findOne($idvenda);
//Adicionado Promissoria
$searchModel2 = new VendaSearch();
$searchModel2->cliente_idcliente = $id;
$dataProvider2 = $searchModel2->search(Yii::$app->request->queryParams);
$content = $this->renderPartial('promissoria', ['model' => $model, 'model2' => $model2, 'dataProvider2' => $dataProvider2]);
$pdf = new Pdf(['format' => Pdf::FORMAT_A4, 'orientation' => Pdf::ORIENT_PORTRAIT, 'destination' => Pdf::DEST_BROWSER, 'content' => $content, 'cssFile' => '@vendor/kartik-v/yii2-mpdf/assets/kv-mpdf-bootstrap.min.css', 'cssInline' => '.kv-heading-1{font-size:18px}', 'options' => ['title' => 'SGO - Nota Promissória - Cliente'], 'methods' => ['SetHeader' => ['SGO - Nota Promissória - Cliente'], 'SetFooter' => ['{PAGENO}']]]);
return $pdf->render();
}
public function actionListarRemoto($search = null, $id = null)
{
$out = ['more' => false];
if (!is_null($search)) {
$query = new Query();
$query->select(['idcliente AS id', 'CONCAT(nome, " - ", cpf) AS text'])->from('cliente')->where('nome LIKE "%' . $search . '%"')->limit(200);
//$query -> select('idcliente AS id, nome AS text')->from('cliente')->where('nome LIKE "%'.$search.'%"')->limit(200);
$command = $query->createCommand();
$data = $command->queryAll();
$out['results'] = array_values($data);
} elseif ($id > 0) {
$out['results'] = ['id' => $id, 'text' => Cliente::findOne($id)->nome];
} else {
$out['results'] = ['id' => 0, 'text' => 'No matching records found'];
}
echo Json::encode($out);
}
