<?php
session_start();
require_once 'core/init.php';
if (isset($_POST['update_password'])) {
$user_id = $_SESSION['uid'];
$new_password = md5($_POST['newPwd']);
$BranchObj = new branch(null, $new_password, null, null);
$res = $BranchObj->updatePwd($user_id);
if ($res) {
$_GET['update_success'] = 1;
header("location:branch_page.php?update_success=1");
} else {
header("location:branch_page.php?update_success=0");
}
}
?>
<?php
require_once 'object_set.php';
class branch extends object_set
{
function table_name()
{
return "t_branch";
}
function auto_id()
{
return true;
}
}
$branch = new branch();
$branch->process();
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();
}
}
}
<div class="container-fluide">
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a class="active" href="#">Branches</a></li>
</ul>
<div class="page-heading">
<h1>View Branches</h1>
</div>
<div class="table-responsive custom-table">
<?php
$branch = new branch();
$results = $branch->get_branches();
if ($results) {
}
?>
<table id="myTable">
<thead>
<tr>
<th>ID</th>
<th>Company</th>
<th>Name</th>
<th>Location</th>
<th>Desc</th>
<th></th>
</tr>
</thead>
if (isset($_SESSION['company_id'])) {
?>
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a href="view_branch_item.php">Items</a></li>
<li><a class="active" href="#" >Add</a></li>
</ul>
<div class="page-heading">
<h1>Add Item</h1>
</div>
<div class="form-container">
<?php
$branch = new branch();
$all_branch = $branch->get_branches();
$branch_category = new branch_category();
$all_branch_category = $branch_category->get_branch_category();
$branch_menu_type = new branch_menu_type();
$all_branch_menu_type = $branch_menu_type->get_branch_menu_type();
$branch_spice = new branch_spice();
$all_branch_spice = $branch_spice->get_branch_spice();
$branch_item = new branch_item();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_branch_item'])) {
// Update old record
if (isset($ID)) {
$results = $branch_item->update_branch_item($_POST, $ID);
} else {
// Insert new
<div class="container-fluide">
<?php
if (isset($_SESSION['company_id'])) {
?>
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a class="active" href="#">Branches Items</a></li>
</ul>
<div class="page-heading">
<h1>View Items</h1>
</div>
<div class="table-responsive custom-table">
<?php
$branch = new branch();
$branch_item = new branch_item();
$results = $branch_item->get_branch_item();
?>
<table id="myTable">
<thead>
<tr>
<th>Name</th>
<th>Branch</th>
<th>Category</th>
<th>Menu Type</th>
<th>Status</th>
<th></th>
</tr>
</thead>
<tbody>
if (isset($_SESSION['company_id'])) {
?>
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a href="view_branch.php">Branches</a></li>
<li><a class="active" href="#" >Add</a></li>
</ul>
<div class="page-heading">
<h1>Add Branch</h1>
</div>
<div class="form-container">
<?php
$branch = new branch();
$company = new company();
$ID = isset($_GET['id']) ? $_GET['id'] : NULL;
if (isset($_POST['add_branch'])) {
// Update old record
if (isset($ID)) {
$results = $branch->update_branch($_POST, $ID);
} else {
// Insert new
$results = $branch->insert_branch($_POST);
}
if ($results) {
echo '<div class="alert alert-success" role="alert">';
echo isset($_GET['id']) ? 'Updated ' : 'Added ';
echo 'branch Sucessfully </div>';
} else {
<div class="container-fluide">
<?php
if (isset($_SESSION['company_id'])) {
?>
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a class="active" href="#">Branches Users</a></li>
</ul>
<div class="page-heading">
<h1>View Branches Users</h1>
</div>
<div class="table-responsive custom-table">
<?php
$branch = new branch();
$branch_user = new branch_user();
$results = $branch_user->get_branch_user();
if ($results) {
}
?>
<table id="myTable">
<thead>
<tr>
<th>Name</th>
<th>Branch</th>
<th>Email</th>
<th>Phone</th>
<th>Status</th>
<th></th>
</tr>
<div class="container-fluide">
<?php
if (isset($_SESSION['company_id'])) {
?>
<ul class="breadcrumb">
<li><a href="#">Home</a></li>
<li><a class="active" href="#">Branches Tables</a></li>
</ul>
<div class="page-heading">
<h1>View Tables</h1>
</div>
<div class="table-responsive custom-table">
<?php
$branch = new branch();
$branch_table = new branch_table();
$results = $branch_table->get_branch_table();
?>
<table id="myTable">
<thead>
<tr>
<th>Name</th>
<th>Branch</th>
<th>Status</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
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);
//}
}