public function index()
{
// Obtenemos los consultores
$consultor = new Consultor();
$consultores = $consultor->getAllConsultores();
$cliente = new Cliente();
$clientes = $cliente->getAllClientes();
return view('comercial.performance')->with('clientes', $clientes)->with('consultores', $consultores);
}
/**
* Store a newly created resource in storage.
*
* @param ClienteStoreRequest $request
* @return \Illuminate\Http\RedirectResponse
*/
public function store(ClienteStoreRequest $request)
{
// store
Cliente::insert($request->all());
// Redirect
return redirect()->route('clientes.index');
}
public function clientesFrecuentesFecha($fecha)
{
$clientes = Cliente::clientesFrecuentes($fecha);
$clientes = Funciones::limparCeros($clientes);
$cantidadclientes = count($clientes);
return view('principal.consultas.clientesfrecuentesfecha', compact('clientes', 'cantidadclientes'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$json = File::get(database_path() . '/data/clienti.json');
$data = json_decode($json);
foreach ($data as $obj) {
Cliente::create(array('id' => $obj->id, 'nome' => $obj->nome, 'cognome' => $obj->cognome, 'societa' => $obj->societa, 'indirizzo' => $obj->indirizzo, 'cap' => $obj->cap, 'comune' => $obj->comune, 'provincia' => $obj->provincia, 'nazione' => $obj->nazione, 'telefono' => $obj->telefono, 'fax' => $obj->fax, 'utente' => $obj->utente, 'cancellato' => $obj->cancellato));
}
$this->command->info("tabella clienti popolata");
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$venda = Venda::find($id);
$clientes = Cliente::orderBy('fantasia')->get(['id', 'fantasia', 'nome_razao']);
/*if ($venda->status == 2) {
flash()->error('Venda não pode ser alterar, a mesma já está concluída');
return redirect('/vendas');
}*/
return view('vendas.edit', compact('venda', 'clientes'));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cliente::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(['clien_codigo' => $this->clien_codigo, 'clien_tipo' => $this->clien_tipo, 'muni_codigo' => $this->muni_codigo]);
$query->andFilterWhere(['like', 'clien_nome', $this->clien_nome])->andFilterWhere(['like', 'clien_cpf_cnpj', $this->clien_cpf_cnpj])->andFilterWhere(['like', 'clien_email', $this->clien_email]);
return $dataProvider;
}
public function search2($params)
{
$query = Cliente::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(['idCliente' => $this->idCliente]);
$query->andFilterWhere(['like', 'razonSocial', $this->razonSocial])->andFilterWhere(['like', 'direccion', $this->direccion])->andFilterWhere(['like', 'barrio', $this->barrio])->andFilterWhere(['like', 'telefono', $this->telefono])->andFilterWhere(['like', 'nit', $this->nit])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'ruta', $this->ruta])->andFilterWhere(['like', 'dia', $this->dia]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cliente::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]);
$query->andFilterWhere(['like', 'nome', $this->nome])->andFilterWhere(['like', 'telefone', $this->telefone])->andFilterWhere(['like', 'celular', $this->celular])->andFilterWhere(['like', 'endereco', $this->endereco]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cliente::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(['idCliente' => $this->idCliente]);
$query->andFilterWhere(['like', 'Nombre', $this->Nombre])->andFilterWhere(['like', 'Telefono', $this->Telefono])->andFilterWhere(['like', 'Mail', $this->Mail])->andFilterWhere(['like', 'Direccion', $this->Direccion])->andFilterWhere(['like', 'Descripcion', $this->Descripcion]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cliente::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(['idcliente' => $this->idcliente, 'numero' => $this->numero, 'longe_od_esferico' => $this->longe_od_esferico, 'longe_od_cilindrico' => $this->longe_od_cilindrico, 'longe_od_eixo' => $this->longe_od_eixo, 'longe_od_dnp' => $this->longe_od_dnp, 'longe_oe_esferico' => $this->longe_oe_esferico, 'longe_oe_cilindrico' => $this->longe_oe_cilindrico, 'longe_oe_eixo' => $this->longe_oe_eixo, 'longe_oe_dnp' => $this->longe_oe_dnp, 'perto_od_esferico' => $this->perto_od_esferico, 'perto_od_cilindrico' => $this->perto_od_cilindrico, 'perto_od_eixo' => $this->perto_od_eixo, 'perto_od_dnp' => $this->perto_od_dnp, 'perto_oe_esferico' => $this->perto_oe_esferico, 'perto_oe_cilindrico' => $this->perto_oe_cilindrico, 'perto_oe_eixo' => $this->perto_oe_eixo, 'perto_oe_dnp' => $this->perto_oe_dnp, 'ad' => $this->ad, 'data_receituario' => $this->data_receituario, 'datanascimento' => $this->datanascimento, 'renda' => $this->renda]);
$query->andFilterWhere(['like', 'nome', $this->nome])->andFilterWhere(['like', 'cpf', $this->cpf])->andFilterWhere(['like', 'rg', $this->rg])->andFilterWhere(['like', 'sexo', $this->sexo])->andFilterWhere(['like', 'telefone1', $this->telefone1])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'observacao', $this->observacao])->andFilterWhere(['like', 'logradouro', $this->logradouro])->andFilterWhere(['like', 'complemento', $this->complemento])->andFilterWhere(['like', 'bairro', $this->bairro])->andFilterWhere(['like', 'cidade', $this->cidade])->andFilterWhere(['like', 'estado', $this->estado])->andFilterWhere(['like', 'cep', $this->cep])->andFilterWhere(['like', 'observacao_lentes', $this->observacao_lentes])->andFilterWhere(['like', 'naturalidade_uf', $this->naturalidade_uf])->andFilterWhere(['like', 'profissao', $this->profissao])->andFilterWhere(['like', 'mae', $this->mae])->andFilterWhere(['like', 'pai', $this->pai])->andFilterWhere(['like', 'estadocivil', $this->estadocivil])->andFilterWhere(['like', 'conjuge', $this->conjuge])->andFilterWhere(['like', 'telefone2', $this->telefone2])->andFilterWhere(['like', 'referencia1', $this->referencia1])->andFilterWhere(['like', 'telefone11', $this->telefone11])->andFilterWhere(['like', 'referencia2', $this->referencia2])->andFilterWhere(['like', 'telefone21', $this->telefone21]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Cliente::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, 'dni' => $this->dni, 'fecha_nacimiento' => $this->fecha_nacimiento, 'localidad_id' => $this->localidad_id]);
$query->andFilterWhere(['like', 'apellido', $this->apellido])->andFilterWhere(['like', 'nombre', $this->nombre])->andFilterWhere(['like', 'domicilio', $this->domicilio]);
return $dataProvider;
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(UserCreateRequest $request)
{
$persona = new Persona();
$persona->fill($request->all());
$persona->contacto_id = 1;
$persona->fecha_nacimiento = Carbon::createFromTimestamp(strtotime($persona->fecha_nacimiento))->format('Y-m-d');
$persona->save();
$cliente = new Cliente();
$cliente->numero_cliente = 0;
$cliente->curp = '';
$cliente->rfc = '';
$cliente->razon_social = '';
$cliente->actividad_economica = '';
$cliente->fecha_registro = Carbon::now();
$cliente->persona_id = $persona->id;
$cliente->save();
$user = new User();
$user->fill($request->all());
$user->password = bcrypt($request->password);
$user->cliente_id = $cliente->id;
$user->save();
$user->roles()->sync($request->roles);
return redirect()->route('usuario.index');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getClienCodigo()
{
return $this->hasOne(Cliente::className(), ['clien_codigo' => 'clien_codigo']);
}
/**
* 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.');
}
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $model app\models\Pedido */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="pedido-form">
<?php
$form = ActiveForm::begin(['enableClientValidation' => false]);
?>
<?php
$rows = \app\models\Cliente::find()->all();
$data = ArrayHelper::map($rows, 'clien_codigo', 'clien_nome');
echo $form->field($model, 'clien_codigo')->dropDownList($data, ['prompt' => 'Selecione um cliente']);
?>
<?php
$rows = \app\models\FormaPagamento::find()->all();
$data = ArrayHelper::map($rows, 'fopa_codigo', 'fopa_nome');
echo $form->field($model, 'fopa_codigo')->dropDownList($data, ['prompt' => 'Selecione uma forma de pagamento']);
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? 'Cadastrar' : 'Alterar', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
public function createByCliente($id)
{
$cliente = Cliente::findOrFail($id);
$cliente_id = $cliente->id;
$asociado = new Asociado();
$cliente_id_field = \Form::hidden('cliente_id', $cliente->id);
$form_data = ['route' => 'asociado.store'];
$title = 'Agregar asociado de cliente: ' . $cliente->persona->primer_nombre;
return view('asociado.form')->with(compact('cliente', 'asociado', 'cliente_id_field', 'cliente_id', 'form_data', 'title'));
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIdCliente()
{
return $this->hasOne(Cliente::className(), ['id' => 'id_cliente']);
}
public function getClientAccount($id)
{
$cliente = Cliente::findOrFail($id);
$coches = $cliente->coches->lists('modelo', 'id');
$title = 'Cuenta de cliente';
return view('sell.clientaccount')->with(compact('cliente', 'title', 'coches'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$cheque = Cheque::find($id);
$bancos = Banco::all()->lists('nome', 'id');
$clientes = Cliente::orderBy('fantasia')->get();
$fornecedores = Fornecedor::orderBy('fantasia')->get();
if ($cheque->lancamento->status != '2' || $cheque->lancamento->status != '3') {
return view('cheques.edit', compact('cheque', 'bancos', 'clientes', 'fornecedores'));
}
flash('Cheque já está pago');
return redirect('/cheques');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getClienteIdCliente()
{
return $this->hasOne(Cliente::className(), ['idCliente' => 'Cliente_idCliente']);
}
public static function clientesFrecuentes($reservaciones)
{
$clientes = array();
$idCliente = null;
$cliente = null;
$again = false;
foreach ($reservaciones as $reservacion) {
do {
if ($idCliente == null) {
$cliente = Cliente::find($reservacion->id_cliente);
$cliente->visitas = 0;
$idCliente = $cliente->id;
$again = false;
}
if ($reservacion->id_cliente == $idCliente) {
$cliente->visitas += 1;
}
if ($reservacion->id_cliente != $idCliente) {
$idCliente = null;
array_push($clientes, $cliente);
$cliente = null;
$again = true;
}
} while ($again);
}
return $clientes;
}
use yii\helpers\ArrayHelper;
use kartik\widgets\Select2;
use kartik\datecontrol\DateControl;
/* @var $this yii\web\View */
/* @var $model app\models\Pedido */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="pedido-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'cliente_idCliente')->widget(Select2::classname(), ['data' => ArrayHelper::map(Cliente::find()->all(), 'idCliente', 'razonSocial'), 'options' => ['placeholder' => 'Seleccione une opción'], 'pluginOptions' => ['allowClear' => true]]);
?>
<?php
echo $form->field($model, 'fechaEntrega')->widget(DateControl::classname(), ['type' => DateControl::FORMAT_DATE]);
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
/**
* @return \yii\db\ActiveQuery
*/
public function getCliente()
{
return $this->hasOne(Cliente::className(), ['id' => 'cliente_did']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getClientes()
{
return $this->hasMany(Cliente::className(), ['estatus_did' => 'id']);
}
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();
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$boleto = Boleto::find($id);
$clientes = Cliente::orderBy('fantasia')->get();
$fornecedores = Fornecedor::orderBy('fantasia')->get();
$edit = true;
if ($boleto->lancamento->status == '1') {
return view('boletos.edit', compact('boleto', 'fornecedores', 'clientes'));
}
flash('Boleto já está pago');
return redirect('/boletos');
}
public function actionImprimir()
{
// get your HTML raw content without any layouts or scrip
$Empleado = Cliente::find()->all();
$pdf = Yii::$app->pdf;
$pdf->content = $this->renderPartial('_imprimir', ['Cliente' => $Cliente]);
return $pdf->render();
}
/* @var $this yii\web\View */
/* @var $model app\models\Pedido */
/* @var $form yii\widgets\ActiveForm */
$stats = ArrayHelper::getColumn(Situacao::find()->all(), function ($element) {
return $element['status'];
});
$statuses = array_combine($stats, $stats);
$entregadores = ArrayHelper::getColumn(Entregador::find()->all(), function ($element) {
return $element['nome'];
});
$entregadores = array_combine($entregadores, $entregadores);
$clientes = ArrayHelper::getColumn(Cliente::find()->all(), function ($element) {
return $element['nome'];
});
$clientes = array_combine($clientes, $clientes);
$tels = ArrayHelper::getColumn(Cliente::find()->all(), function ($element) {
return $element['tel'];
});
$tels = array_combine($tels, $tels);
?>
<div class="pedido-form">
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'cliente_nome')->dropDownList($clientes, ['prompt' => 'Selecione...']);
?>
/**
* 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.');
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getClientes()
{
return $this->hasMany(Cliente::className(), ['emp_rut' => 'emp_rut']);
}
