public function view()
{
if (!isset($this->request->params['slug'])) {
$this->notice('invalid');
}
$branch = $this->Branch->find('first', array('conditions' => array('Branch.slug' => $this->request->params['slug'], 'Branch.active' => 1), 'contain' => array('Address' => array('fields' => array('Address.address'), 'Country' => array('fields' => array('Country.name'))), 'Contact')));
if (empty($branch)) {
$this->notice(__('The branch does not exsit'), array('redirect' => true));
}
$this->set('title_for_layout', sprintf(__('Contact us at %s'), $branch['Branch']['name']));
$this->set(compact('branch'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$student = Student::find($id);
if ($student == NULL) {
throw new Exception('Invalid Student ID');
}
$student->year = (int) substr($student->year, 2, 4);
$student_category = StudentCategories::find($student->category);
$student->category = $student_category->category;
$student_branch = Branch::find($student->branch);
$student->branch = $student_branch->branch;
if ($student->rejected == 1) {
unset($student->approved);
unset($student->books_issued);
$student->rejected = (bool) $student->rejected;
return $student;
}
if ($student->approved == 0) {
unset($student->rejected);
unset($student->books_issued);
$student->approved = (bool) $student->approved;
return $student;
}
unset($student->rejected);
unset($student->approved);
$student_issued_books = Logs::select('book_issue_id', 'issued_at')->where('student_id', '=', $id)->orderBy('time_stamp', 'desc')->take($student->books_issued)->get();
foreach ($student_issued_books as $issued_book) {
$issue = Issue::find($issued_book->book_issue_id);
$book = Books::find($issue->book_id);
$issued_book->name = $book->title;
$issued_book->issued_at = date('d-M', $issued_book->issued_at);
}
$student->issued_books = $student_issued_books;
return $student;
}
public function UpdateListBranch()
{
$input = Input::all();
$listBranchID = $input['update_list_branch_id'];
$listBranchID = explode(",", $listBranchID);
foreach ($listBranchID as $p) {
if ($input['name'] != '') {
$branch = Branch::find($p);
$branch->name = $input['name'];
$branch->save();
}
}
}
public static function aviso_renovar()
{
$fecha_i = date('Y-m-d');
$fecha_f = Branch::find(Session::get('branch_id'))->deadline;
$dias = (strtotime($fecha_f) - strtotime($fecha_i)) / 86400;
if ($dias <= 5 && $dias >= 1) {
$mensaje = '<span class="label label-warning pull-right">Fecha Límite de Emisión expirará en ' . $dias . ' día(s).</span>';
return $mensaje;
} elseif ($dias == 0) {
$mensaje = '<span class="label label-danger pull-right">Su Fecha Límite de Emisión Expira Hoy.</span>';
return $mensaje;
}
return null;
}
public static function all($options = [])
{
$condition = (is_array($options) and $options['all']) ? '' : self::baseCondition();
$list = Branch::find($condition);
if ($list) {
$list = $list->toArray();
if (is_array($options) and $options['key']) {
$data = [];
foreach ($list as $row) {
$data[$row['bid']] = $row;
}
$list = $data;
}
return $list;
}
return [];
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$this->info('Search Delivery Items Life Time');
// 六十天提醒
//
$N_Time = date("Y-m-d", time());
$L_Time = date("Y-m-d", time() + 60 * 3600 * 24);
// 获取满足条件的货品
//
$Items = DeliveryItems::where('life_date', '>', $N_Time)->where('life_date', '<', $L_Time)->orderBy('delivery_id', 'desc')->get();
// 初始化
//
$branch_ids = array();
$delivery_ids = array();
foreach ($Items as $Item) {
// 条件过滤
//
if (!in_array($Item->delivery_id, $delivery_ids) && in_array($Item->branch_id, $branch_ids)) {
continue;
} else {
if (!in_array($Item->delivery_id, $delivery_ids)) {
$delivery_ids[] = $Item->delivery_id;
}
if (!in_array($Item->branch_id, $branch_ids)) {
$branch_ids[] = $Item->branch_id;
}
$branch = Branch::find($Item->branch_id);
$delivery = Delivery::find($Item->delivery_id);
if ($branch && $delivery) {
$notice = new Notice();
$notice->user_id = $branch->user_id;
$notice->type = '5';
$notice->content = '客户（' . $branch->name . '）的出货单（' . $delivery->bn . '）中商品（' . $Item->good_name . '）' . date("Y-m-d", strtotime($Item->life_date)) . ' 过期！';
$notice->data = json_encode(array('branch_id' => $Item->branch_id, 'delivery_id' => $Item->delivery_id));
$notice->read = '0';
$notice->timeline = date("Y-m-d H:i:s", time());
$notice->save();
$this->info($notice->content);
}
}
}
$this->info('Done!');
}
/**
* Implementacja metody z interfejsu Zend_Auth_Adapter_Interface
* @see Zend_Auth_Adapter_Interface::authenticate()
* @return Zend_Auth_Result
*/
public function authenticate()
{
if (empty($this->_username)) {
throw new Zend_Auth_Adapter_Exception('Nie podano loginu!');
}
if (empty($this->_password)) {
throw new Zend_Auth_Adapter_Exception('Nie podano hasła!');
}
$config = Zend_Registry::get('config');
$this->_options = $config['ldap'];
$resultLDAP = parent::authenticate();
if ($resultLDAP->isValid()) {
$userModel = new User();
$userRow = $userModel->fetchRow(array('login = ?' => new Zend_Db_Expr("UPPER('{$this->_username}')"), 'ghost = ?' => 'f', 'is_locked = ?' => 'f', new Zend_Db_Expr('valid_until > NOW()')));
if ($userRow !== null) {
$identity = $this->_toStdClass($userRow);
unset($identity->password);
$ldapData = parent::getAccountObject();
$identity->ldap = $ldapData;
$branchModel = new Branch();
$identity->id_branch = ODDZIAL_ID;
$identity->view_branch = ODDZIAL_ID;
$data = $branchModel->find($identity->id_branch);
$d = $data->current()->toArray();
$d['application_code'] = 'getin';
$identity->jednostka = $d;
$identity->user_backend_apps_logins = null;
$identity->default_branches[$d['application_code']]['default_login'] = '******';
$this->_authResult['code'] = Zend_Auth_Result::SUCCESS;
$this->_authResult['messages'] = 'Autoryzacja pomyślna.';
$this->_authResult['identity'] = $identity;
return $this->_createAuthResult();
} else {
$this->_authResult['code'] = Zend_Auth_Result::FAILURE_IDENTITY_NOT_FOUND;
$this->_authResult['messages'] = 'Konto nieaktywne lub zablokowane.';
return $this->_createAuthResult();
}
} else {
$this->_authResult['code'] = Zend_Auth_Result::FAILURE_CREDENTIAL_INVALID;
$this->_authResult['messages'] = 'Nieprawidłowe dane logowania.';
return $this->_createAuthResult();
}
}
function _authenticateValidateResult($resultIdentity)
{
$zendAuthCredentialMatchColumn = $this->_zendDb->foldCase('zend_auth_credential_match');
if ($resultIdentity[$zendAuthCredentialMatchColumn] != '1') {
$this->_authenticateResultInfo['code'] = Zend_Auth_Result::FAILURE_CREDENTIAL_INVALID;
$this->_authenticateResultInfo['messages'][] = 'Supplied credential is invalid.';
return $this->_authenticateCreateAuthResult();
}
unset($resultIdentity[$zendAuthCredentialMatchColumn]);
$this->_resultRow = $resultIdentity;
// $userModel = new Logic_User();
// $user = $userModel->getUserByLogin();
$userModel = new User();
$user = $userModel->fetchRow(array('login = ?' => new Zend_Db_Expr("UPPER('" . $resultIdentity['login'] . "')"), 'ghost = ?' => 'f', 'is_locked = ?' => 'f', new Zend_Db_Expr('valid_until > NOW()')));
if (empty($user)) {
$this->_authenticateResultInfo['code'] = Zend_Auth_Result::FAILURE_IDENTITY_NOT_FOUND;
$this->_authenticateResultInfo['messages'][] = 'Authentication failed.';
return $this->_authenticateCreateAuthResult();
}
$identity = $this->_toStdClass($user);
$identity->password = $this->_password;
$branchModel = new Branch();
$identity->id_branch = ODDZIAL_ID;
$identity->view_branch = ODDZIAL_ID;
$data = $branchModel->find($identity->id_branch);
$d = $data->current()->toArray();
$d['application_code'] = 'getin';
$identity->jednostka = $d;
$identity->user_backend_apps_logins = null;
$identity->default_branches[$d['application_code']]['default_login'] = '******';
//$identity->user_backend_apps_logins[$d['application_code']]['application_login'] = '******';
$this->_authenticateResultInfo['identity'] = $identity;
$this->_resultRow = $user;
$this->_authenticateResultInfo['code'] = Zend_Auth_Result::SUCCESS;
$this->_authenticateResultInfo['messages'][] = 'Authentication successful.';
return $this->_authenticateCreateAuthResult();
}
private function saveLote($factura)
{
$account = DB::table('accounts')->where('id', '=', Auth::user()->account_id)->first();
$branch = Branch::find(Session::get('branch_id'));
// return $factura['nit'];
$client = Client::where('account_id', '=', Auth::user()->account_id)->where('public_id', $factura['id'])->first();
//if(!$client)
// return $factura['nit'];
$invoice = Invoice::createNew();
$invoice->setPublicNotes($factura['nota']);
$invoice->setBranch(Session::get('branch_id'));
$invoice->setInvoiceDate(date("Y-m-d"));
$invoice->setClient($client->id);
$invoice->setEconomicActivity($branch->economic_activity);
$invoice->setDiscount(0);
$invoice->setClientName($client->name);
$invoice->setClientNit($client->nit);
$invoice->setUser(Auth::user()->id);
//$date=date("Y-m-d",strtotime(Input::get('invoice_date')));
//$invoice->setInvoiceDate($date);
$total_cost = 0;
foreach ($factura['products'] as $producto) {
//$pr = Product::where('account_id',Auth::user()->account_id)->where('product_key',$producto['product_key'])->first();
//$total_cost+= $pr->cost*$producto['qty'];
$total_cost += $producto['cost'];
}
$invoice->importe_neto = trim($total_cost);
$invoice->importe_total = trim($total_cost);
//$invoice->note = trim(Input::get('nota'));
$invoice->setAccountName($account->name);
$invoice->setAccountNit($account->nit);
$invoice->setBranchName($branch->name);
$invoice->setAddress1($branch->address1);
$invoice->setAddress2($branch->address2);
$invoice->setPhone($branch->work_phone);
$invoice->setCity($branch->city);
$invoice->setState($branch->state);
$invoice->setNumberAutho($branch->number_autho);
$invoice->setKeyDosage($branch->key_dosage);
$invoice->setTypeThird($branch->type_third);
$invoice->setDeadline($branch->deadline);
$invoice->setLaw($branch->law);
$type_document = TypeDocument::where('account_id', Auth::user()->account_id)->first();
$invoice->invoice_number = branch::getInvoiceNumber();
$numAuth = $invoice->number_autho;
$numfactura = $invoice->invoice_number;
$nit = $invoice->client_nit;
$fechaEmision = date("Ymd", strtotime($invoice->invoice_date));
$total = $invoice->importe_neto;
$llave = $branch->key_dosage;
$codigoControl = Utils::getControlCode($numfactura, $nit, $fechaEmision, $total, $numAuth, $llave);
$invoice->setControlCode($codigoControl);
$documents = TypeDocumentBranch::where('branch_id', $invoice->branch_id)->orderBy('id', 'ASC')->get();
foreach ($documents as $document) {
$actual_document = TypeDocument::where('id', $document->type_document_id)->first();
if ($actual_document->master_id == 1) {
$id_documento = $actual_document->id;
}
}
$invoice->setJavascript($id_documento);
$invoice->logo = 1;
$invoice->sfc = $branch->sfc;
//$invoice->qr =$invoice->account_nit.'|'.$invoice->invoice_number.'|'.$invoice->number_autho.'|'.$invoice->invoice_date.'|'.$invoice->importe_neto.'|'.$invoice->importe_total.'|'.$invoice->client_nit.'|'.$invoice->importe_ice.'|0|0|'.$invoice->descuento_total;
if ($account->is_uniper) {
$invoice->account_uniper = $account->uniper;
}
//$invoice->logo = $type_document->logo;
$invoice->save();
foreach ($factura['products'] as $producto) {
$product = Product::where('account_id', Auth::user()->account_id)->where('product_key', $producto['product_key'])->first();
if ($product != null) {
$invoiceItem = InvoiceItem::createNew();
$invoiceItem->setInvoice($invoice->id);
$invoiceItem->setProduct($product->id);
$invoiceItem->setProductKey($product->product_key);
$invoiceItem->setNotes($product->notes . " " . $producto['description']);
$invoiceItem->setCost($producto['cost']);
$invoiceItem->setQty(1);
$invoiceItem->save();
}
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$issue = Issue::find($id);
if ($issue == NULL) {
throw new Exception('Invalid Book ID');
}
$issue->added_at_timestamp = date('d-M-y h:i A', strtotime($issue->added_at_timestamp));
$book = Books::find($issue->book_id);
$issue->book_name = $book->title;
$issue->author = $book->author;
$issue->category = Categories::find($book->category_id)->category;
$issue->available_status = (bool) $issue->available_status;
if ($issue->available_status == 1) {
return $issue;
}
$conditions = array('return_time' => 0, 'book_issue_id' => $id);
$book_issue_log = Logs::where($conditions)->take(1)->get();
foreach ($book_issue_log as $log) {
$student_id = $log->student_id;
}
$student_data = Student::find($student_id);
unset($student_data->email_id);
unset($student_data->books_issued);
unset($student_data->approved);
unset($student_data->rejected);
$student_branch = Branch::find($student_data->branch)->branch;
$roll_num = $student_data->roll_num . '/' . $student_branch . '/' . substr($student_data->year, 2, 4);
unset($student_data->roll_num);
unset($student_data->branch);
unset($student_data->year);
$student_data->roll_num = $roll_num;
$student_data->category = StudentCategories::find($student_data->category)->category;
$issue->student = $student_data;
return $issue;
}
<!--
<td>
<?php
if ($user->branch_id) {
$branch = Branch::find($user->branch_id);
if ($branch) {
echo $branch->name;
}
}
?>
</td>
-->
<td>
<?php
if ($user->branch_id) {
$branch = Branch::find($user->branch_id);
if ($branch && isset($branch->brand_id) && $branch->brand_id) {
$brand = Brand::find($branch->brand_id);
if ($brand) {
echo $brand->name;
}
}
}
?>
</td>
<td>
{{ $user->isActivated() ? trans('core::all.yes') : trans('core::all.no') }}
</td>
<td class="center" width="100">
<div>
@if($currentUser->hasAccess('update-user-info'))
public function getRecoverCapsuleList($BranchId, $GoodId)
{
$capsule = GoodCapsule::where('branch_id', $BranchId)->where('good_id', $GoodId)->orderBy('created_at', 'desc')->paginate();
return View::make('branch.recover-capsule-list')->with('branch', Branch::find($BranchId))->with('capsule', $capsule);
}
public function getWarehouseSelect($BranchId)
{
$branch = Branch::find($BranchId);
$warehouse = Warehouse::all();
return View::make('picking.warehouse-select')->with(compact('warehouse'))->with(compact('branch'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
if (Auth::user()->is_admin) {
$branch = Branch::find($id);
if ($branch->number_branch != 0) {
$branch->delete();
Session::flash('message', 'Se elimino satisfactoriamente a la sucursal');
} else {
Session::flash('error', 'No se puede eliminar a la casa matriz ');
}
return Redirect::to('sucursales');
}
return Redirect::to('inicio');
}
public static function GetByAddress($branchAddress)
{
return Branch::find(array('address' => $branchAddress));
}
print_r(Branch::getCurrency('1'));
echo '</pre>';
?>
<p style="font-weight: bold;">Update</p><p><?php
$data = array();
$data['id'] = '2';
$data['address'] = "Suite 3, 22 Council St,\nHawthorn East";
$data['state'] = "Victoria";
$data['zip'] = "3123";
$data['country'] = 'AU';
$data['phone'] = '+61 03 9882 7164';
$data['fax'] = '+61 03 9882 9792';
?>
Before...<?php
echo '<pre>';
print_r(Branch::get('2'));
echo '</pre>';
Branch::update($data);
?>
After...<?php
echo '<pre>';
print_r(Branch::get('2'));
echo '</pre>';
?>
<p style="font-weight: bold;">Find</p><p><?php
$criteria = array('columns' => 'branches.branch, branches.address, branches.zip, branches.state, countries.country', 'match' => 'branches.phone LIKE \'%6363\'', 'joins' => 'countries ON countries.country_code = branches.country');
echo '<pre>';
print_r(Branch::find($criteria));
echo '</pre>';
?>
</p>
public function asignarSucursal()
{
if (Session::has('branch_id')) {
Session::forget('branch_id');
Session::forget('branch_name');
}
// Session::forget('branch_id');
Session::put('branch_id', Input::get('branch_id'));
$sucursal = Branch::find(Session::get('branch_id'));
Session::put('branch_name', $sucursal->name);
// return Response::json(array('info ' =>$sucursal));
return Redirect::to('inicio');
}
private function saveOfflineInvoice2($factura)
{
// return Response::json($factura);
$input = $factura;
//print_r($input->invoice_number);
//return ;
// $invoice_number = Auth::user()->account->getNextInvoiceNumber();
//$invoice_number = (int)Auth::user()->branch->getNextInvoiceNumber();
//$numero =(int) $input['invoice_number'];
$numero = (int) $input->invoice_number;
$user_branch = UserBranch::where('user_id', Auth::user()->id)->first();
$sucursal = Branch::find($user_branch->branch_id);
//$sucursal->invoice_number_counter= $input['invoice_number']+1;
$sucursal->invoice_number_counter = $input->invoice_number + 1;
$sucursal->save();
$invoice_number = $numero;
// $numero =(int) $input['invoice_number'];
// if($invoice_number!=$numero)
// {
// return Response::json( array('resultado' => '1' ,'invoice_number'=>$invoice_number));
// }
//$client_id = $input['client_id'];
$client_id = $input->client_id;
// $client = DB::table('clients')->select('id','nit','name','public_id')->where('id',$input['client_id'])->first();
// $user_id = Auth::user()->getAuthIdentifier();
$user = DB::table('users')->select('account_id', 'price_type_id')->where('id', Auth::user()->id)->first();
//$account_id = $user->account_id;
// $account = DB::table('accounts')->select('num_auto','llave_dosi','fecha_limite')->where('id',$user->account_id)->first();
//$branch = DB::table('branches')->select('num_auto','llave_dosi' ,'fecha_limite','address1','address2','country_id','industry_id')->where('id',$user['branch_id'])->first();
//$branch = DB::table('branches')->select('num_auto','llave_dosi','fecha_limite','address1','address2','country_id','industry_id')->where('id','=',$user->branch_id)->first();
// $branch = DB::table('branches')->select('number_autho','key_dosage','deadline','address1','address2','country_id','industry_id','law','activity_pri','activity_sec1','name')->where('id','=',$user->branch_id)->first();
$branch = DB::table('branches')->where('id', '=', $user_branch->branch_id)->first();
//$items = $input['invoice_items'];
$items = $input->invoice_items;
// echo "this is initializioinh";
// print_r($input->invoice_items);
// return 0;
// $linea ="";
$amount = 0;
$subtotal = 0;
$fiscal = 0;
$icetotal = 0;
$bonidesc = 0;
foreach ($items as $item) {
# code...
//$product_id = $item['id'];
$product_id = $item->id;
$pr = DB::table('products')->join('prices', "product_id", "=", 'products.id')->select('products.id', 'products.notes', 'prices.cost', 'products.ice', 'products.units', 'products.cc')->where('prices.price_type_id', '=', $user->price_type_id)->where('products.account_id', '=', $user->account_id)->where('products.id', "=", $product_id)->first();
// $pr = DB::table('products')->select('cost')->where('id',$product_id)->first();
//$qty = (int) $item['qty'];
$qty = (int) $item->qty;
$cost = $pr->cost / $pr->units;
$st = $cost * $qty;
$subtotal = $item->subtotal;
//$subtotal + $st;
//$bd= ($item['boni']*$cost) + $item['desc'];
$bd = $item->boni * $cost + $item->desc;
$bonidesc = $bonidesc + $bd;
$amount = $amount + $st - $bd;
$icetotal = $pr->ice;
/*$ice = DB::table('tax_rates')->select('rate')->where('name','=','ICE')->first();
if($pr->ice == 1)
{
//caluclo ice bruto
$iceBruto = ($qty *($pr->cc/1000)*$ice->rate);
//$iceNeto = (((int)$item['boni']) *($pr->cc/1000)*$ice->rate);
$iceNeto = (((int)$item->boni) *($pr->cc/1000)*$ice->rate);
$icetotal = $icetotal +($iceBruto-$iceNeto) ;
// $fiscal = $fiscal + ($amount - ($item['qty'] *($pr->cc/1000)*$ice->rate) );
}
*/
}
//$fiscal = $amount -$bonidesc-$icetotal;
$fiscal = $subtotal - $bonidesc - $icetotal;
$balance = $amount;
/////////////////////////hasta qui esta bien al parecer hacer prueba de que fuciona el join de los productos XD
$invoice_dateCC = date("Ymd");
$invoice_date = date("Y-m-d", strtotime($input->fecha));
$invoice_date_limitCC = date("Y/m/d", strtotime($branch->deadline));
$cod_control = $input->cod_control;
$ice = DB::table('tax_rates')->select('rate')->where('name', '=', 'ice')->first();
//
// creando invoice
$cuenta = Account::find(1);
$invoice = Invoice::createNew();
$invoice->invoice_number = $invoice_number;
$invoice->client_id = $client_id;
$invoice->user_id = Auth::user()->id;
$invoice->account_id = Auth::user()->account_id;
$invoice->branch_id = $user_branch->branch_id;
$invoice->importe_neto = number_format((double) $amount, 2, '.', '');
$invoice->importe_total = $subtotal;
$invoice->debito_fiscal = $fiscal;
$invoice->law = $branch->law;
$invoice->balance = $balance;
$invoice->control_code = $cod_control;
$invoice->start_date = $invoice_date;
$invoice->invoice_date = $invoice_date;
$invoice->economic_activity = $branch->economic_activity;
// $invoice->activity_sec1=$branch->activity_sec1;
// $invoice->invoice
$invoice->end_date = $invoice_date_limitCC;
//datos de la empresa atra vez de una consulta XD
/*****************error generado al intentar guardar **/
$invoice->branch_name = $branch->name;
$invoice->address1 = $branch->address1;
$invoice->address2 = $branch->address2;
$invoice->number_autho = $branch->number_autho;
$invoice->phone = $branch->work_phone;
$invoice->city = $branch->city;
$invoice->state = $branch->state;
$invoice->account_name = $cuenta->name;
$invoice->account_nit = $cuenta->nit;
$invoice->importe_ice = $icetotal;
$invoice->qr = $invoice->account_nit . '|' . $invoice->invoice_number . '|' . $invoice->number_autho . '|' . $invoice->invoice_date . '|' . $invoice->importe_neto . '|' . $invoice->importe_total . '|' . $invoice->client_nit . '|' . $invoice->importe_ice . '|0|0|' . $invoice->descuento_total;
$invoice->key_dosage = $branch->key_dosage;
$invoice->deadline = $branch->deadline;
// $invoice->ice = $ice->rate;
//cliente
//$invoice->client_nit=$input['nit'];
$invoice->client_nit = $input->nit;
///$invoice->client_name =$input['name'];
$invoice->client_name = $input->name;
$documents = TypeDocumentBranch::where('branch_id', $invoice->branch_id)->orderBy('id', 'ASC')->get();
foreach ($documents as $document) {
$actual_document = TypeDocument::where('id', $document->type_document_id)->first();
if ($actual_document->master_id == 1) {
$id_documento = $actual_document->id;
}
}
$invoice->setJavascript($id_documento);
$invoice->logo = 0;
$account = Auth::user()->account;
$invoice->save();
foreach ($items as $item) {
$product_id = $item->id;
$product = DB::table('products')->join('prices', "product_id", "=", 'products.id')->select('products.id', 'products.notes', 'prices.cost', 'products.ice', 'products.units', 'products.cc', 'products.product_key')->where('prices.price_type_id', '=', $user->price_type_id)->where('products.account_id', '=', $user->account_id)->where('products.id', "=", $product_id)->first();
$cost = $product->cost / $product->units;
//$line_total= ((int)$item['qty'])*$cost;
$line_total = (int) $item->qty * $cost;
$invoiceItem = InvoiceItem::createNew();
// $invoiceItem->invoice_id = $invoice->id;
$invoiceItem->invoice_id = $invoice->id;
$invoiceItem->product_id = $product_id;
$invoiceItem->product_key = $product->product_key;
$invoiceItem->notes = $product->notes;
$invoiceItem->cost = $cost;
$invoiceItem->boni = (int) $item->boni;
$invoiceItem->discount = $item->desc;
$invoiceItem->qty = (int) $item->qty;
$invoiceItem->ice = $item->ice;
$invoiceItem->subtotal = $item->subtotal;
$invoiceItem->save();
}
$datos = array('resultado ' => "0");
}
public function asignarSucursal()
{
if (Session::has('branch_id')) {
Session::forget('branch_id');
Session::forget('branch_name');
Session::forget('printer');
Session::forget('printer');
Session::forget('invoice_link');
}
// Session::forget('branch_id');
Session::put('branch_id', Input::get('branch_id'));
$sucursal = Branch::find(Session::get('branch_id'));
Session::put('branch_name', $sucursal->name);
Session::put('printer', Input::get('printer'));
$documents = TypeDocumentBranch::where('branch_id', Input::get('branch_id'))->orderBy('id', 'ASC')->get();
foreach ($documents as $document) {
$actual_document = TypeDocument::where('id', $document->type_document_id)->first();
if ($actual_document->master_id == 1 || $actual_document->master_id == 3) {
$id_documento = $actual_document;
}
}
switch ($id_documento->master_id) {
case 1:
Session::put('invoice_link', 'factura/create');
break;
case 3:
Session::put('invoice_link', 'sinCreditoFiscal');
break;
}
// return Response::json(array('info ' =>$sucursal));
return Redirect::to('inicio');
}
/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$branch = Branch::find($id);
return View::make('branches.edit', compact('branch'));
}
private function saveLote2($factura, $date)
{
//print_r($factura);
//return;
$account = DB::table('accounts')->where('id', '=', Auth::user()->account_id)->first();
$branch = Branch::find(Session::get('branch_id'));
$client = Client::where('account_id', '=', Auth::user()->account_id)->where('name', $factura['name'])->where('nit', $factura['nit'])->first();
if (!$client) {
///echo "creo";
$client = Client::createNew();
$client->setNit(trim($factura['nit']));
$client->setName(trim($factura['name']));
$client->setBussinesName(trim($factura['razon']));
$alt = $client->guardar();
$client->save();
}
$invoice = Invoice::createNew();
$invoice->setPublicNotes("");
$invoice->setBranch(Session::get('branch_id'));
$dateparser = explode("/", $date);
$date = $dateparser[2] . '-' . $dateparser[1] . '-' . $dateparser[0];
$invoice->setInvoiceDate($date);
$invoice->setClient($client->id);
$invoice->setEconomicActivity($branch->economic_activity);
$invoice->setDiscount(0);
$invoice->setClientName($client->business_name);
$invoice->setClientNit($client->nit);
$invoice->setUser(Auth::user()->id);
$total_cost = 0;
/*foreach ($factura['products'] as $producto)
{
$total_cost+= $producto['cost'];
}*/
$invoice->importe_neto = $factura['total'] * $factura['qty'];
$invoice->importe_total = $factura['total'] * $factura['qty'];
$invoice->debito_fiscal = $factura['total'] * $factura['qty'];
//$invoice->note = trim(Input::get('nota'));
$invoice->setAccountName($account->name);
$invoice->setAccountNit($account->nit);
$invoice->setBranchName($branch->name);
$invoice->setAddress1($branch->address1);
$invoice->setAddress2($branch->address2);
$invoice->setPhone($branch->work_phone);
$invoice->setCity($branch->city);
$invoice->setState($branch->state);
$invoice->setNumberAutho($branch->number_autho);
$invoice->setKeyDosage($branch->key_dosage);
$invoice->setTypeThird($branch->type_third);
$invoice->setDeadline($branch->deadline);
$invoice->setLaw($branch->law);
$type_document = TypeDocument::where('account_id', Auth::user()->account_id)->firstOrFail();
$invoice->invoice_number = branch::getInvoiceNumber();
$numAuth = $invoice->number_autho;
$numfactura = $invoice->invoice_number;
$nit = $invoice->client_nit;
$fechaEmision = date("Ymd", strtotime($invoice->invoice_date));
$total = $invoice->importe_neto;
$llave = $branch->key_dosage;
$totalc = number_format((double) $total, 2, '.', '');
if ($account->currency_id == 2) {
$totalc = $total * $account->exchange;
$totalc = number_format((double) $totalc, 2, '.', '');
}
$codigoControl = Utils::getControlCode($numfactura, $nit, $fechaEmision, $totalc, $numAuth, $llave);
$invoice->setControlCode($codigoControl);
$documents = TypeDocumentBranch::where('branch_id', $invoice->branch_id)->orderBy('id', 'ASC')->get();
foreach ($documents as $document) {
$actual_document = TypeDocument::where('id', $document->type_document_id)->first();
if ($actual_document->master_id == 1) {
$id_documento = $actual_document->id;
}
}
$invoice->setJavascript($id_documento);
$invoice->logo = 1;
//$invoice->sfc = $branch->sfc;
if ($account->currency_id == 1) {
$invoice->sfc = 1;
} else {
$invoice->sfc = $account->exchange;
}
$invoice->qr = $invoice->account_nit . '|' . $invoice->invoice_number . '|' . $invoice->number_autho . '|' . $invoice->invoice_date . '|' . $invoice->importe_neto . '|' . $invoice->importe_total . '|' . $invoice->client_nit . '|' . $invoice->importe_ice . '|0|0|' . $invoice->descuento_total;
if ($account->is_uniper) {
$invoice->account_uniper = $account->uniper;
}
//$invoice->logo = $type_document->logo;
$invoice->save();
//foreach ($factura['products'] as $producto)
//{
$product = Product::where('account_id', Auth::user()->account_id)->where('product_key', $factura['code'])->first();
if ($product != null) {
$invoiceItem = InvoiceItem::createNew();
$invoiceItem->setInvoice($invoice->id);
$invoiceItem->setProduct($product->id);
$invoiceItem->setProductKey($product->product_key);
$invoiceItem->setNotes($product->notes);
//$invoiceItem->setCost($factura['total']);
$invoiceItem->setCost($factura['total']);
$invoiceItem->setQty($factura['qty']);
$invoiceItem->save();
}
// $this->sendInvoiceByMailLocal($client->name,$client->business_name,$invoice->id,$invoice->invoice_date,$client->nit);
//}
}
public function obtenerFactura($public_id)
{
$client = DB::table('clients')->select('id', 'name', 'business_name', 'nit', 'public_id', 'custom_value4')->where('account_id', Auth::user()->account_id)->where('public_id', $public_id)->first();
if ($client == null) {
$datos = array('resultado' => 1, 'mensaje' => 'cliente no encontrado');
return Response::json($datos);
}
//caso contrario tratar al cliente
// $branch = Auth::user()->branch;
$invoices = DB::table('invoices')->where('client_id', '=', $client->id)->orderBy('public_id')->get(array('id', 'invoice_number'));
if ($invoices == null) {
$datos = array('resultado' => 2, 'mensaje' => 'Cliente no emitio ninguna factura');
return Response::json($datos);
}
$inv = "";
foreach ($invoices as $invo) {
$inv = $invo;
}
$invoice = DB::table('invoices')->where('id', '=', $inv->id)->first();
$invoiceItems = DB::table('invoice_items')->select('notes', 'cost', 'qty')->where('invoice_id', '=', $invoice->id)->get(array('notes', 'cost', 'qty'));
// $date = date_create($invoice->deadline);
$date = new DateTime($invoice->deadline);
$fecha_emision = new DateTime($invoice->invoice_date);
// $account = DB::table('accounts')->select('name','nit')->where('id',$user->account_id)->first();
$branch = Branch::find($invoice->branch_id);
$account = array('name' => $invoice->account_name, 'nit' => $invoice->account_nit);
$client->name = $invoice->client_name;
$client->business_name = $invoice->client_name;
$client->nit = $invoice->client_nit;
$ice = $invoice->amount - $invoice->fiscal;
$cliente = array('name' => $invoice->client_name, 'nit' => $invoice->client_nit);
$factura = array('resultado' => 0, 'activity_pri' => $branch->economic_activity, 'invoice_number' => $invoice->invoice_number, 'control_code' => $invoice->control_code, 'invoice_date' => $fecha_emision->format('d/m/Y'), 'amount' => number_format((double) $invoice->importe_total, 2, '.', ''), 'subtotal' => number_format((double) $invoice->importe_neto, 2, '.', ''), 'fiscal' => number_format((double) $invoice->fiscal, 2, '.', ''), 'client' => $client, 'account' => $account, 'law' => $invoice->law, 'invoice_items' => $invoiceItems, 'address1' => $invoice->address1, 'address2' => $invoice->address2, 'num_auto' => $invoice->number_autho, 'fecha_limite' => $date->format('d/m/Y'));
//its work ok go get the money
return Response::json($factura);
}
public function delete_branch()
{
$getID = Input::get('deleteID');
$branch = Branch::find($getID);
$branch->actStatus = '0';
$branch->save();
return Redirect::to('/branches');
}
