/**
* View a blog post.
*
* @param string $slug
* @return Redirect
*/
public function postView($slug)
{
$user = $this->user->currentUser();
// Get this blog post data
$client = $this->client->where('slug', '=', $slug)->first();
// Redirect to this blog post page
return Redirect::to($slug);
}
/**
* Display a listing of clients
*
* @return Response
*/
public function index()
{
$user = Auth::user()->id;
// Grab all the user clients
$clients = $this->client->where('user_id', $user)->get();
//Include deleted clients
if (Input::get('withTrashed')) {
} else {
if (Input::get('onlyTrashed')) {
$clients = $this->client->onlyTrashed()->where('user_id', $user)->get();
}
}
return View::make('clients.index', compact('clients'));
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
$credit = Credit::createNew();
$last_credit = Credit::where('account_id', '=', Auth::user()->account_id)->where('client_id', '=', Input::get('client'))->max('credit_number');
if (!$last_credit) {
$last_credit = 0;
}
$credit->setClient(Input::get('client'));
//Client::getPrivateId(Input::get('client'));
$dateparser = explode("/", Input::get('credit_date'));
$date = $dateparser[2] . '-' . $dateparser[1] . '-' . $dateparser[0];
$credit->setCreditDate(date($date));
$credit->setAmount(Input::get('amount'));
$credit->setBalance(Input::get('amount'));
$credit->setPrivateNotes(trim(Input::get('private_notes')));
$credit->setUser(Auth::user()->id);
$credit->setCreditNumber($last_credit + 1);
$error = $credit->guardar();
if ($error) {
Session::flash('error', $error);
return Redirect::to('creditos/create');
}
$credit->save();
Session::flash('message', 'Crédito creado con éxito');
$client = Client::where('id', '=', Input::get('client'))->first();
return Redirect::to('clientes/' . $client->public_id);
}
public function authenticate()
{
$username = Input::get('username');
$password = Input::get('password');
$captcha_string = Input::get('g-recaptcha-response');
$captcha_response = file_get_contents('https://www.google.com/recaptcha/api/siteverify?secret=6LcCwgATAAAAAKaXhPJOGPTBwX-n2-PPLZ7iupKj&response=' . $captcha_string);
$captcha_json = json_decode($captcha_response);
if ($captcha_json->success) {
if (Auth::attempt(['loginClient' => $username, 'password' => $password], true)) {
// Gestion de la connexion administrateur via le front-office
$is_admin = Client::where('loginClient', '=', $username)->firstOrFail()->admin;
if ($is_admin == '1') {
Session::put('admin', '1');
} else {
Session::put('admin', '0');
}
Session::flash('flash_msg', "Vous êtes maintenant connecté.");
Session::flash('flash_type', "success");
return Redirect::to('/account');
} else {
Session::flash('flash_msg', "Identifiants incorrects, veuillez réessayer.");
Session::flash('flash_type', "fail");
return Redirect::to('/login');
}
} else {
Session::flash('flash_msg', "Champ de vérification incorrect ou non coché.");
Session::flash('flash_type', "fail");
return Redirect::to(URL::previous());
}
}
public function testClientDeletePost()
{
$client = Client::where('name', '=', 'TestClient2')->firstOrFail();
$this->call('POST', '/client/delete/' . $client->id);
$this->assertRedirectedTo('/client/list');
$this->assertSessionHas('success');
}
public function __construct()
{
$this->beforeFilter('auth.admin');
$this->hasUnverifiedUsers = Client::where('is_verified', '=', 0)->count();
$this->hasUsersInWaitlist = Client::where('on_waitlist', '=', 1)->count();
View::share('actionName', explode('@', Route::currentRouteAction())[1]);
$this->userRules = array('email' => 'required|email', 'first_name' => 'required', 'last_name' => 'required');
}
/**
* Load the manage clients page.
* @param String $lrs_id
* @return View
*/
public function manage($lrs_id)
{
$opts = ['user' => \Auth::user()];
$lrs = $this->lrs->show($lrs_id, $opts);
$lrs_list = $this->lrs->index($opts);
$clients = \Client::where('lrs_id', $lrs->id)->get();
return View::make('partials.client.manage', ['clients' => $clients, 'lrs' => $lrs, 'list' => $lrs_list]);
}
public function show($id)
{
$group = Group::scope($id)->firstOrFail();
print_r($group->id);
$clients = Client::where('group_id', '=', $group->id)->select('clients.id', 'clients.nit', 'clients.name', 'clients.public_id')->get();
$clientes = array();
foreach ($clients as $key => $client) {
array_push($clientes, $client);
}
return View::make('groups.show', array('group' => $group, 'clients' => $clientes, 'showBreadcrumbs' => false));
}
public function dashboard()
{
$sucursales = Branch::where('account_id', Auth::user()->account_id)->get();
$usuarios = Account::find(Auth::user()->account_id)->users;
//$clientes = Account::find(Auth::user()->account_id)->clients;
$clientes = Client::where('account_id', Auth::user()->account_id)->count();
$productos = Account::find(Auth::user()->account_id)->products;
$informacionCuenta = array('sucursales' => sizeof($sucursales), 'usuarios' => sizeof($usuarios), 'clientes' => $clientes, 'productos' => sizeof($productos));
// return Response::json($informacionCuenta);
return View::make('cuentas.dashboard')->with('cuenta', $informacionCuenta);
}
/**
* Remove the specified resource from storage.
* DELETE /users/{id}
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
// Delete everything related to the user
Task::where('user_id', Auth::id())->delete();
Credential::where('user_id', Auth::id())->delete();
Project::where('user_id', Auth::id())->delete();
Client::where('user_id', Auth::id())->delete();
User::where('id', Auth::id())->delete();
// Logout and redirect back to home page
Auth::logout();
return Redirect::to('/');
}
/**
* Run a general search.
* @return array of objects with the search results.
*/
public function search()
{
$q = Input::get("q");
// redirect user back if nothing was typed
if (empty(trim($q))) {
return Redirect::back();
}
$clients = Client::where('name', 'like', '%' . $q . '%')->whereUserId(Auth::id())->get();
$projects = Project::where('name', 'like', '%' . $q . '%')->whereUserId(Auth::id())->get();
$tasks = Task::where('name', 'like', '%' . $q . '%')->whereUserId(Auth::id())->get();
$pTitle = "Search Results";
return View::make('search', compact('q', 'clients', 'projects', 'tasks', 'pTitle'));
}
public function getInvoices()
{
$invoices = Invoice::where('account_id', Auth::user()->account_id)->where('branch_id', Session::get('branch_id'))->select('public_id', 'invoice_status_id', 'client_id', 'invoice_number', 'invoice_date', 'importe_total', 'branch_name')->orderBy('public_id', 'DESC')->get();
foreach ($invoices as $key => $invoice) {
$invoice_razon = Client::where('account_id', Auth::user()->account_id)->select('name')->where('id', $invoice->client_id)->first();
$invoice->razon = $invoice_razon->name;
$estado = InvoiceStatus::where('id', $invoice->invoice_status_id)->first();
$invoice->estado = $estado->name;
$invoice->accion = "<a class='btn btn-primary btn-xs' data-task='view' href='factura/{$invoice->public_id}' style='text-decoration:none;color:white;'><i class='glyphicon glyphicon-eye-open'></i></a> <a class='btn btn-warning btn-xs' href='copia/{$invoice->public_id}' style='text-decoration:none;color:white;'><i class='glyphicon glyphicon-duplicate'></i></a>";
}
$invoiceJson = ['data' => $invoices];
return Response::json($invoiceJson);
}
public function clientList($id = null)
{
if ($id == null) {
$clients = Client::all(array('id', 'name'));
} else {
$clients = Client::where('id_user', '=', Auth::user()->id)->get(array('id', 'name'));
}
$clientsRow = array();
$clientsRow[0] = "Cliente";
foreach ($clients as $client) {
$clientsRow[$client["id"]] = $client["name"];
}
return $clientsRow;
}
public function updatemotdepasse($token)
{
$client = Client::where('token', '=', $token)->firstOrFail();
$input = ["password1" => Input::get('password1'), "password2" => Input::get('password2'), "mdpClient" => Hash::make(Input::get('password1'))];
$messages = array('required' => ":attribute est requis pour changer votre mot de passe.", 'same' => 'Les mots de passe ne correspondent pas', 'min' => "Le mot de passe entré est trop court (5 car. mini)");
$rules = array('password1' => 'required|same:password2|min:5', 'password2' => 'required');
$validator = Validator::make(Input::all(), $rules, $messages);
if ($validator->fails()) {
$messages = $validator->messages();
return Redirect::to(URL::previous())->withErrors($validator);
} else {
Session::flash('flash_msg', "Le mot de passe a bien été changé.");
Session::flash('flash_type', "success");
$client->mdpClient = $input['mdpClient'];
$client->token = '';
$client->save();
return Redirect::to("/login");
}
}
public function action_check_id()
{
try {
$jwt = $this->authserver->getRequest()->get()['access_token'];
//Get Token header and payload
$content = JWT::decode($this->authserver->getRequest()->get()['access_token'], null, false);
$client_id = DB::table('oauth_client_metadata')->where('key', 'website')->where('value', $content->aud)->first()->client_id;
$client_secret = Client::where('id', $client_id)->first()->secret;
//Verify Signature
$response = JWT::decode($this->authserver->getRequest()->get()['access_token'], $client_secret);
} catch (League\OAuth2\Server\Exception\ClientException $e) {
// Throw an exception because there was a problem with the client's request
$response = array('error' => $this->authserver->getExceptionType($e->getCode()), 'error_description' => $e->getMessage());
// Set the correct header
header($this->authserver->getExceptionHttpHeaders($this->authserver->getExceptionType($e->getCode()))[0]);
} catch (Exception $e) {
// Throw an error when a non-library specific exception has been thrown
$response = array('error' => 'undefined_error', 'error_description' => $e->getMessage());
}
header('Content-type: application/json');
echo json_encode($response);
}
public static function findUserClient($id_client = null, $id_user = null)
{
return Client::where('id', '=', $id_client)->where('id_user', '=', $id_user)->first();
}
public function requestRevision()
{
$tripId = Input::get('trip_id');
$carName = Input::get('car');
$clientName = Input::get('client');
$customerName = Input::get('customer_name');
$customerEmail = Input::get('customer_email');
$customerPhone = Input::get('customer_phone');
$departureKm = Input::get('start_km');
$arrivalKm = Input::get('end_km');
$departureDateTime = Input::get('start_time');
$arrivalDateTime = Input::get('end_time');
$departureAddress = Input::get('departure_address');
$arrivalAddress = Input::get('destination_address');
$car = Cars::where('name', '=', substr($carName, 0, 3))->first();
if ($car instanceof Cars) {
$carId = $car->id;
} else {
$carId = '';
}
$client = Client::where('name', '=', $clientName)->first();
if ($client instanceof Client) {
$clientId = $client->id;
} else {
$clientId = '';
}
try {
$myTrip = DailyTrips::find($tripId);
$myTrip->edit_req = 1;
$myTrip->save();
$myTripRevison = new DailyTripsRevision();
$myTripRevison->trip_id = $tripId;
$myTripRevison->user_id = Session::get('user_id');
$myTripRevison->car_id = $carId;
$myTripRevison->client_id = $clientId;
$myTripRevison->customer_name = $customerName;
$myTripRevison->customer_email = $customerEmail;
$myTripRevison->customer_phone = $customerPhone;
$myTripRevison->departure_km = $departureKm;
$myTripRevison->departure_date_time = $departureDateTime;
$myTripRevison->arrival_km = $arrivalKm;
$myTripRevison->arrival_date_time = $arrivalDateTime;
$myTripRevison->departure_address = $departureAddress;
$myTripRevison->arrival_address = $arrivalAddress;
$myTripRevison->save();
$results = array('success' => true, 'message' => 'revision requested');
} catch (Exception $ex) {
\Log::error(__METHOD__ . ' | error :' . print_r($ex, 1));
$results = array('success' => false, 'message' => 'an error occurred');
}
return $results;
}
private function seedTestUsersAndClients()
{
$resource_server = ResourceServer::first();
// create users and clients ...
User::create(array('identifier' => 'sebastian.marcet', 'external_identifier' => 13867, 'last_login_date' => gmdate("Y-m-d H:i:s", time())));
$user = User::where('identifier', '=', 'sebastian.marcet')->first();
OpenIdTrustedSite::create(array('user_id' => $user->id, 'realm' => 'https://www.test.com/', 'policy' => IAuthService::AuthorizationResponse_AllowForever));
Client::create(array('app_name' => 'oauth2_test_app', 'app_description' => 'oauth2_test_app', 'app_logo' => null, 'client_id' => 'Jiz87D8/Vcvr6fvQbH4HyNgwTlfSyQ3x.openstack.client', 'client_secret' => 'ITc/6Y5N7kOtGKhg', 'client_type' => IClient::ClientType_Confidential, 'application_type' => IClient::ApplicationType_Web_App, 'user_id' => $user->id, 'rotate_refresh_token' => true, 'use_refresh_token' => true));
Client::create(array('app_name' => 'oauth2.service', 'app_description' => 'oauth2.service', 'app_logo' => null, 'client_id' => '11z87D8/Vcvr6fvQbH4HyNgwTlfSyQ3x.openstack.client', 'client_secret' => '11c/6Y5N7kOtGKhg', 'client_type' => IClient::ClientType_Confidential, 'application_type' => IClient::ApplicationType_Service, 'user_id' => $user->id, 'rotate_refresh_token' => true, 'use_refresh_token' => true));
Client::create(array('app_name' => 'oauth2_test_app_public', 'app_description' => 'oauth2_test_app_public', 'app_logo' => null, 'client_id' => 'Jiz87D8/Vcvr6fvQbH4HyNgwKlfSyQ3x.openstack.client', 'client_secret' => null, 'client_type' => IClient::ClientType_Public, 'application_type' => IClient::ApplicationType_JS_Client, 'user_id' => $user->id, 'rotate_refresh_token' => false, 'use_refresh_token' => false));
Client::create(array('app_name' => 'oauth2_test_app_public_2', 'app_description' => 'oauth2_test_app_public_2', 'app_logo' => null, 'client_id' => 'Jiz87D8/Vcvr6fvQbH4HyNgwKlfSyQ2x.openstack.client', 'client_secret' => null, 'client_type' => IClient::ClientType_Public, 'application_type' => IClient::ApplicationType_JS_Client, 'user_id' => $user->id, 'rotate_refresh_token' => false, 'use_refresh_token' => false));
Client::create(array('app_name' => 'resource_server_client', 'app_description' => 'resource_server_client', 'app_logo' => null, 'client_id' => 'resource.server.1.openstack.client', 'client_secret' => '123456789', 'client_type' => IClient::ClientType_Confidential, 'application_type' => IClient::ApplicationType_Service, 'resource_server_id' => $resource_server->id, 'rotate_refresh_token' => false, 'use_refresh_token' => false));
$client_confidential = Client::where('app_name', '=', 'oauth2_test_app')->first();
$client_public = Client::where('app_name', '=', 'oauth2_test_app_public')->first();
$client_service = Client::where('app_name', '=', 'oauth2.service')->first();
//attach scopes
$scopes = ApiScope::get();
foreach ($scopes as $scope) {
$client_confidential->scopes()->attach($scope->id);
$client_public->scopes()->attach($scope->id);
$client_service->scopes()->attach($scope->id);
}
//add uris
ClientAuthorizedUri::create(array('uri' => 'https://www.test.com/oauth2', 'client_id' => $client_confidential->id));
//add uris
ClientAllowedOrigin::create(array('allowed_origin' => 'https://www.test.com/oauth2', 'client_id' => $client_confidential->id));
ClientAuthorizedUri::create(array('uri' => 'https://www.test.com/oauth2', 'client_id' => $client_public->id));
}
public function indexDown($name = null, $numero = null, $nit = null, $group = null, $contact = null)
{
$name = Input::get('name');
$numero = Input::get('numero');
$nit = Input::get('nit');
$group = Input::get('group');
$contact = Input::get('contact');
if (Session::get('sw') == 'DESC') {
Session::put('sw', 'ASC');
} else {
Session::put('sw', 'DESC');
}
$sw = Session::get('sw');
if ($numero == "" && $name == "" && $nit == "" && $group == "" && $contact == "") {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('id', 'business_name', 'nit', 'created_at', 'group_id')->orderBy('id', $sw)->simplePaginate(30);
foreach ($clientes as $key => $client) {
$contacts = Contact::where('account_id', Auth::user()->account_id)->select('first_name', 'last_name')->where('client_id', $client->id)->first();
$client->contacto_first_name = $contacts->first_name;
$client->contacto_last_name = $contacts->last_name;
}
return View::make('clientes.index', array('clients' => $clientes, 'sw' => 'ASC', 'contacts' => $contacts));
}
if ($numero) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('id', 'business_name', 'nit', 'created_at', 'group_id')->where('id', 'like', $numero . "%")->orderBy('id', $sw)->simplePaginate(30);
foreach ($clientes as $key => $client) {
$contacts = Contact::where('account_id', Auth::user()->account_id)->select('first_name', 'last_name')->where('client_id', $client->id)->first();
$client->contacto_first_name = $contacts->first_name;
$client->contacto_last_name = $contacts->last_name;
}
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'create' => $create];
return View::make('clientes.index', $data);
}
if ($name) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('id', 'business_name', 'nit', 'created_at', 'group_id')->where('business_name', 'like', $name . "%")->orderBy('business_name', $sw)->simplePaginate(30);
// $clientes = Client::join('contacts', 'clients.id' ,'=', 'contacts.client_id')
// ->where('business_name', 'like', $name."%")
// ->select('clients.id', 'clients.business_name', 'clients.nit', 'clients.created_at', 'contacts.first_name', 'contacts.last_name')
// ->orderBy('business_name', $sw)
// ->simplePaginate(30);
foreach ($clientes as $key => $client) {
$contacts = Contact::where('account_id', Auth::user()->account_id)->select('first_name', 'last_name')->where('client_id', $client->id)->first();
$client->contacto_first_name = $contacts->first_name;
$client->contacto_last_name = $contacts->last_name;
}
// return $clientes;
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'create' => $create];
return View::make('clientes.index', $data);
}
if ($nit) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('id', 'business_name', 'nit', 'created_at', 'group_id')->where('nit', 'like', $nit . "%")->orderBy('nit', $sw)->simplePaginate(30);
foreach ($clientes as $key => $client) {
$contacts = Contact::where('account_id', Auth::user()->account_id)->select('first_name', 'last_name')->where('client_id', $client->id)->first();
$client->contacto_first_name = $contacts->first_name;
$client->contacto_last_name = $contacts->last_name;
}
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'create' => $create];
return View::make('clientes.index', $data);
}
// if ($create) {
//
// $clientes = Client::where('account_id', Auth::user()->account_id)
// ->select('id', 'business_name', 'nit', 'created_at', 'group_id')
// ->where('created_at', 'like', $create."%")
// ->orderBy('created_at', $sw)
// ->simplePaginate(30);
// foreach ($clientes as $key => $client) {
// $contacts = Contact::where('account_id', Auth::user()->account_id)
// ->select('first_name', 'last_name')
// ->where('client_id', $client->id)
// ->first();
// $client->contacto_first_name = $contacts->first_name;
// $client->contacto_last_name = $contacts->last_name;
// }
//
// $data = [
// 'clients' => $clientes,
// 'numero' => $numero,
// 'name' => $name,
// 'nit' => $nit,
// 'create' => $create
// ];
// return View::make('clientes.index', $data);
// }
if ($group) {
$clientes = Client::join('groups', 'clients.group_id', '=', 'groups.id')->select('clients.id', 'clients.nit', 'clients.business_name', 'clients.created_at', 'clients.group_id')->where('groups.name', 'like', $group . '%')->orderBy('groups.name', $sw)->simplePaginate(30);
foreach ($clientes as $key => $client) {
$contacts = Contact::where('account_id', Auth::user()->account_id)->select('first_name', 'last_name')->where('client_id', $client->id)->first();
$client->contacto_first_name = $contacts->first_name;
$client->contacto_last_name = $contacts->last_name;
}
$data = ['clients' => $clientes, 'group' => $group];
return View::make('clientes.index', $data);
}
if ($contact) {
$clientes = Client::join('contacts', 'clients.id', '=', 'contacts.client_id')->select('clients.id', 'clients.nit', 'clients.business_name', 'clients.created_at', 'clients.group_id', 'contacts.first_name', 'contacts.last_name')->where('contacts.first_name', 'like', $contact . "%")->orderBy('contacts.first_name', $sw)->simplePaginate(30);
foreach ($clientes as $key => $client) {
$client->contacto_first_name = $client->first_name;
$client->contacto_last_name = $client->last_name;
}
$data = ['clients' => $clientes, 'contact' => $contact];
return View::make('clientes.index', $data);
}
}
public function enviarCorreoFactura($min = 0, $max = 0)
{
//todotix http
$min = Input::get('min');
$max = Input::get('max');
$branch = 1;
$cuenta = Account::where('domain', 'roy')->where('id', 1)->first();
$invoices = Invoice::where('account_id', $cuenta->id)->where('branch_id', $branch)->where('public_id', '>=', $min)->where('public_id', '<=', $max)->get();
$count = 1;
foreach ($invoices as $key => $invoice) {
$client = Client::where('id', $invoice->client_id)->select('name', 'business_name', 'nit')->first();
if (filter_var($client->name, FILTER_VALIDATE_EMAIL)) {
$this->sendInvoiceByMailLocal($client->name, $client->business_name, $invoice->id, $invoice->invoice_date, $client->nit);
echo $count . " " . $client->name . " " . $invoice->control_code . " " . $invoice->invoice_number . "<br>";
sleep(0.2);
$count = $count + 1;
}
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
//return 0;
// return Response::json(Input::all());
// $rules = array(
// 'client' => 'required',
// 'invoice' => 'required',
// 'amount' => 'required'
// );
// if (Input::get('invoice')) {
// $invoice = Invoice::scope(Input::get('invoice'))->firstOrFail();
// $rules['amount'] .= '|less_than:' . $invoice->balance;
// }
// if (Input::get('payment_type_id') == PAYMENT_TYPE_CREDIT)
// {
// $rules['payment_type_id'] = 'has_credit:' . Input::get('client') . ',' . Input::get('amount');
// }
// $messages = array(
// 'required' => 'El campo es Requerido',
// 'positive' => 'El Monto debe ser mayor a cero',
// 'less_than' => 'El Monto debe ser menor o igual a ' . $invoice->balance,
// 'has_credit' => 'El Cliente no tiene crédito suficiente'
// );
// $validator = \Validator::make(Input::all(), $rules, $messages);
// if ($validator->fails())
// {
// $url = 'pagos/create';
// return Redirect::to($url)
// ->withErrors($validator)
// ->withInput();
// }
// else
// {
$payment = Payment::createNew();
$paymentTypeId = Input::get('payment_type_id');
$clientId = Input::get('client');
$amount = floatval(Input::get('amount'));
// if ($paymentTypeId == PAYMENT_TYPE_CREDIT)
// {
// $credits = Credit::scope()->where('client_id', '=', $clientId)
// ->where('balance', '>', 0)->orderBy('created_at')->get();
// $applied = 0;
// foreach ($credits as $credit)
// {
// $applied += $credit->apply($amount);
// if ($applied >= $amount)
// {
// break;
// }
// }
// }
// $payment->client_id = $clientId;
// $payment->invoice_id =Input::get('invoice');
// $payment->payment_type_id = $paymentTypeId;
// $payment->user_id = Auth::user()->id;
// $payment->payment_date = date("Y-m-d",strtotime(Input::get('payment_date')));
// $payment->amount = $amount;
// $payment->transaction_reference = trim(Input::get('transaction_reference'));
$payment->setClientId($clientId);
$payment->setInvoiceId(Input::get('invoice'));
$payment->setPaymentTypeId($paymentTypeId);
$payment->setUserId(Auth::user()->id);
$dateparser = explode("/", Input::get('payment_date'));
$date = $dateparser[2] . '-' . $dateparser[1] . '-' . $dateparser[0];
$payment->setPaymentDate($date);
$payment->setAmount($amount);
$payment->setTransactionReference(trim(Input::get('transaction_reference')));
$error = $payment->guardar();
if ($error) {
Session::flash('error', $error);
return Redirect::to('pagos/create');
}
$payment->save();
$cliente = Client::find($payment->client_id);
$cliente->balance = $cliente->balance - $payment->amount;
$cliente->paid_to_date = $cliente->paid_to_date + $payment->amount;
$cliente->save();
$invoice = Invoice::find($payment->invoice_id);
$invoice->balance = $invoice->balance - $payment->amount;
$invoice->save();
if ($paymentTypeId == PAYMENT_TYPE_CREDIT) {
$credits = Credit::scope()->where('client_id', '=', $clientId)->where('balance', '>', 0)->orderBy('created_at')->get();
$applied = 0;
foreach ($credits as $credit) {
$applied += $credit->apply($amount);
if ($applied >= $amount) {
break;
}
}
}
$paymentName = PaymentType::where('id', '=', $paymentTypeId)->first();
if ($invoice->balance == 0) {
// $invoice->invoice_status_id = INVOICE_STATUS_PAID;
Utils::addNote($invoice->id, '<b>' . $invoice->getClientName() . ': </b>Totalmente pagada; se pagó:<b>' . $payment->amount . '</b>Bs, con <b>' . $paymentName->name . '</b>', INVOICE_STATUS_PAID);
} else {
// $invoice->invoice_status_id = INVOICE_STATUS_PARTIAL;
Utils::addNote($invoice->id, '<b>' . $invoice->getClientName() . ': </b>Parcialmente pagado; se pagó:<b>' . $payment->amount . '</b> Bs, con <b>' . $paymentName->name . '</b>', INVOICE_STATUS_PARTIAL);
}
Session::flash('message', 'Pago creado con éxito');
$client = Client::where('id', '=', Input::get('client'))->first();
return Redirect::to('clientes/' . $client->public_id);
// }
}
public function users()
{
$users = Client::where('admin', '=', '1')->get();
return View::make('private.pages.users')->with('users', $users);
}
/** Find Client by Id
*
* @param $client_id
*
* @return bool
*/
public function getClientById($client_id)
{
$this->model = Client::where('id', '=', $client_id)->get();
if ($this->model->count() === 1) {
$this->model = $this->model->first();
return true;
}
return false;
}
private function validateShatterExcel($invoices)
{
$stackAstray = "";
foreach ($invoices as $invoice) {
$client = Client::where('account_id', Auth::user()->account_id)->where('public_id', $invoice['id'])->where('nit', $invoice['nit'])->first();
if (!$client) {
$stackAstray .= "El cliente " . $invoice['id'] . " con NIT: " . $invoice['nit'] . " no existe<br>";
}
foreach ($invoice['products'] as $pro) {
$product = Product::where('account_id', Auth::user()->account_id)->where('product_key', $pro['product_key'])->first();
if (!$product) {
$stackAstray .= "El producto con codigo: " . $pro['product_key'] . " no existe<br>";
}
// else
// echo $product->name;
}
}
if ($stackAstray != "") {
$stackAstray .= "Revise el documento y vuelva a intentar.";
}
return $stackAstray;
}
public function utilisateurs()
{
$utilisateurs = Client::where('admin', '=', '0')->get();
return View::make('private.pages.utilisateurs')->with('utilisateurs', $utilisateurs);
}
public function indexDown($name = null, $numero = null, $nit = null, $telefono = null, $matricula = null)
{
$name = Input::get('name');
$numero = Input::get('numero');
$nit = Input::get('nit');
$telefono = Input::get('telefono');
$matricula = Input::get('matricula');
if (Session::get('sw') == 'DESC') {
Session::put('sw', 'ASC');
} else {
Session::put('sw', 'DESC');
}
$sw = Session::get('sw');
if (!$numero && !$name && !$nit && !$telefono && !$matricula) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->orderBy('public_id', $sw)->simplePaginate(15);
// return View::make('clientes.index', array('clients' => $clientes));
return View::make('clientes.index', array('clients' => $clientes, 'sw' => 'ASC'));
}
if ($numero) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->where('public_id', 'like', $numero . "%")->orderBy('public_id', $sw)->simplePaginate(15);
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'telefono' => $telefono];
return View::make('clientes.index', $data);
}
if ($name) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->where('name', 'like', $name . "%")->orderBy('name', $sw)->simplePaginate(15);
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'telefono' => $telefono];
return View::make('clientes.index', $data);
}
if ($nit) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->where('nit', 'like', $nit . "%")->orderBy('nit', $sw)->simplePaginate(15);
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'telefono' => $telefono];
return View::make('clientes.index', $data);
}
if ($telefono) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->where('work_phone', 'like', $telefono . "%")->orderBy('work_phone', $sw)->simplePaginate(15);
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'telefono' => $telefono];
return View::make('clientes.index', $data);
}
if ($matricula) {
$clientes = Client::where('account_id', Auth::user()->account_id)->select('public_id', 'name', 'nit', 'custom_value4', 'work_phone')->where('custom_value4', 'like', $matricula . "%")->orderBy('custom_value4', $sw)->simplePaginate(15);
$data = ['clients' => $clientes, 'numero' => $numero, 'name' => $name, 'nit' => $nit, 'telefono' => $telefono, 'matricula' => $matricula];
return View::make('clientes.index', $data);
}
}
/**
* Destroys the model with the given ID and options.
* @param String $lrs_id ID to match.
* @param [String => Mixed] $opts
* @return Boolean
*/
public function destroy($lrs_id, array $opts)
{
// Delete related documents from client and oauth_clients collections.
$clients = ClientModel::where('lrs_id', $lrs_id)->get();
foreach ($clients as $client) {
$client->delete();
}
StatementModel::where('lrs_id', $lrs_id)->delete();
return parent::destroy($lrs_id, $opts);
}
public function cliente($nit)
{
// $cuenta = Account::find(Auth::user()->account_id);
// $client = DB::table('clients')->select('id','public_id','name','nit')->where('account_id',$user->account_id)->where('nit',$public_id)->first();
$client = Client::where('account_id', Auth::user()->account_id)->where('nit', $nit)->first();
if ($client != null) {
$datos = array('resultado' => 0, 'cliente' => $client);
return Response::json($datos);
}
$datos = array('resultado' => 1, 'mensaje' => 'cliente no encontrado');
return Response::json($datos);
}
public function testDoubleSaveManyToMany()
{
$user = User::create(array('name' => 'John Doe'));
$client = Client::create(array('name' => 'Admins'));
$user->clients()->save($client);
$user->clients()->save($client);
$user->save();
$this->assertEquals(1, $user->clients()->count());
$this->assertEquals(array($user->_id), $client->user_ids);
$this->assertEquals(array($client->_id), $user->client_ids);
$user = User::where('name', 'John Doe')->first();
$client = Client::where('name', 'Admins')->first();
$this->assertEquals(1, $user->clients()->count());
$this->assertEquals(array($user->_id), $client->user_ids);
$this->assertEquals(array($client->_id), $user->client_ids);
$user->clients()->save($client);
$user->clients()->save($client);
$user->save();
$this->assertEquals(1, $user->clients()->count());
$this->assertEquals(array($user->_id), $client->user_ids);
$this->assertEquals(array($client->_id), $user->client_ids);
}
public function pagoCliente($client_id, $invoice_id)
{
$client = Client::where('id', $client_id)->first();
$invoice = Invoice::where('id', $invoice_id)->first();
$dato = ['now' => date('d/m/Y'), 'cliente' => $client->name, 'client_id' => $client->id, 'factura' => 'Factura #' . $invoice->invoice_number . ' Importe Total ' . $invoice->importe_total . '(' . $invoice->balance . ')', 'invoice_id' => $invoice->id, 'amount' => $invoice->balance];
return View::make('pagos.createCustom', $dato);
}
