public function getPostPage()
{
$obj = new BaseController();
$campusid = $this->getDevice();
if ($campusid == 0) {
$countryname = $obj->getCountryName();
if ($countryname == 'NONE') {
return Redirect::route('selectcampus-get');
} else {
//check whether the country name exists inthe db
$locationcountry = Country::where('name', '=', $countryname);
if ($locationcountry->count()) {
$locationcountrycode = $locationcountry->first()->code;
$locationcountrycode = strtolower($locationcountrycode);
return Redirect::route('selectcountryid', $locationcountrycode);
} else {
return Redirect::route('selectcampus-get');
}
}
}
$college = Institution::whereHas('Branch', function ($query) use($campusid) {
$query->where('id', '=', $campusid);
})->first();
View::share('college', $college);
$mycampus = Branch::where('id', '=', $campusid)->first();
View::share('mycampus', $mycampus);
if (Auth::user()) {
return View::make('member.post');
}
return View::make('guest.post');
}
public static function buscar($public_id)
{
if (Auth::check()) {
$account_id = Auth::user()->account_id;
} else {
$account_id = Session::get('account_id');
}
$branch = Branch::where('public_id', $public_id)->scope(false, $account_id)->first();
return $branch;
}
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;
$productos = Account::find(Auth::user()->account_id)->products;
$informacionCuenta = array('sucursales' => sizeof($sucursales), 'usuarios' => sizeof($usuarios), 'clientes' => sizeof($clientes), 'productos' => sizeof($productos));
// return Response::json($informacionCuenta);
return View::make('cuentas.dashboard')->with('cuenta', $informacionCuenta);
}
public function getUpdate($business_id, $field, $value)
{
$first_branch = Branch::where('business_id', '=', $business_id)->first();
$first_service = Service::where('branch_id', '=', $first_branch->branch_id)->first();
if (QueueSettings::serviceExists($first_service->service_id)) {
QueueSettings::updateQueueSetting($first_service->service_id, $field, $value);
} else {
QueueSettings::createQueueSetting(['service_id' => $first_service->service_id, 'date' => mktime(0, 0, 0, date('m'), date('d'), date('Y')), $field => $value]);
}
return json_encode(['success' => 1]);
}
public function getIndex()
{
if (Auth::user()->grade == 1) {
$branch = Branch::take(10)->get();
} else {
$branch = Branch::where('user_id', Auth::user()->id)->take(10)->get();
}
// 提醒
//
$notice = Notice::where('user_id', Auth::user()->id)->where('read', '0')->orderBy('timeline', 'desc')->take(10)->get();
return View::make('index')->with('goods', Good::orderBy('store')->take(10)->get())->with('branch', $branch)->with('notice', $notice);
}
public function getIndex()
{
// 区域
//
$area = Area::all();
// 线路
//
$line = Line::all();
// 客户类型
//
$type = Type::all();
$whereRaw = ' 1=1 ';
$type_id = Input::get('type_id');
$area_id = Input::get('area_id');
$line_id = Input::get('line_id');
$name = Input::get('name');
$code = Input::get('code');
$contact = Input::get('contact');
if ($type_id) {
$whereRaw .= "and type_id = {$type_id} ";
}
if ($area_id) {
$whereRaw .= "and area_id = {$area_id} ";
}
if ($line_id) {
$whereRaw .= "and line_id = {$line_id} ";
}
if ($name) {
$whereRaw .= "and name like '%{$name}%' ";
}
if ($code) {
$whereRaw .= "and code like '%{$code}%' ";
}
if ($contact) {
$whereRaw .= "and contact like '%{$contact}%' ";
}
// 管理员
//
if (Auth::user()->grade == 10) {
$branch = Branch::where('user_id', Auth::user()->id)->whereRaw($whereRaw)->paginate();
$count = Branch::where('user_id', Auth::user()->id)->whereRaw($whereRaw)->count();
} else {
$branch = Branch::whereRaw($whereRaw)->paginate();
$count = Branch::whereRaw($whereRaw)->count();
}
return View::make('branch.index')->with(compact('area'))->with(compact('line'))->with(compact('type'))->with('branch', $branch)->with(compact('count'));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($public_id)
{
if (Auth::user()->is_admin) {
$branch = Branch::where('id', $public_id)->first();
$documents = $this->getWorkingDocuments();
if ($branch->type_third == 0) {
$type = "Facturación Web";
}
if ($branch->type_third == 1) {
$type = "Facturación por Terceros";
}
if ($branch->type_third == 2) {
$type = "Facturación POS";
}
$data = ['sucursal' => $branch, 'documents' => $documents, 'type' => $type];
return View::make('sucursales.show', $data);
}
return Redirect::to('/inicio');
}
public function postImportEmp()
{
if (\Request::ajax()) {
$efile = \Input::file('upload');
/* Validation of file */
$validate = \Validator::make(array('file' => $efile), array('file' => 'required|mimes:xls,csv|max:2000|min:1'));
if ($validate->fails()) {
$error = array('error' => $validate->messages()->first());
echo json_encode($error);
return;
} else {
$handle = file($efile->getRealPath());
/* Call Excel Class */
$objPHPExcel = \PHPExcel_IOFactory::load($efile->getRealPath());
$mainArr = array();
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
// Sheet names
switch ($worksheet->getTitle()) {
case 'User':
$index = 'users';
break;
case 'PersonalDetails':
$index = 'PersonalDetails';
break;
case 'ContactInfo':
$index = 'ContactInfo';
break;
case 'IdentificationandBankInfo':
$index = 'IdentificationandBankInfo';
break;
case 'PFandESIInformation':
$index = 'PFandESIInformation';
break;
case 'JobDetails':
$index = 'JobDetails';
break;
case 'EducationalBackground':
$index = 'EducationalBackground';
break;
case 'WorkExperience':
$index = 'WorkExperience';
break;
}
// Getting all cells
$subArr = array();
$rows = $worksheet->getRowIterator();
foreach ($rows as $row) {
$cells = $row->getCellIterator();
// cells store into data array
$data = array();
foreach ($cells as $cell) {
$data[] = $cell->getCalculatedValue();
}
if ($data) {
// one set of row stored in indexed array
$arr[$index] = $data;
// indexed array store into subarr
$subArr[] = $arr;
// remove indexd array for optimiced douplicated
unset($arr);
}
}
// every sheet of array store in main Arr
$mainArr[$index] = $subArr;
unset($subArr);
}
$emails = array_fetch($mainArr['users'], 'users.1');
// Validate emails
foreach ($emails as $value) {
if (preg_match("/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}\$/", $value)) {
} else {
$error = array('error' => "{$value} InValid Email");
echo json_encode($error);
return;
}
}
// validation email unique from excel
if (count($emails) != count(array_unique($emails))) {
$error = array('error' => "Douplicate emails are available");
echo json_encode($error);
return;
}
//end email unique in excel
//Check Email Id is unique or not
$user = \User::withTrashed()->whereIn('email', $emails)->first();
if ($user) {
$error = array('error' => "{$user->email} already registered");
echo json_encode($error);
return;
}
// Database insertion starts here
$users = $mainArr['users'];
$PersonalDetails = $mainArr['PersonalDetails'];
$ContactInfo = $mainArr['ContactInfo'];
$IdentificationandBankInfo = $mainArr['IdentificationandBankInfo'];
$PFandESIInformation = $mainArr['PFandESIInformation'];
$JobDetails = $mainArr['JobDetails'];
$EducationalBackground = $mainArr['EducationalBackground'];
$WorkExperience = $mainArr['WorkExperience'];
// Create UserId
$userID = \Auth::user()->id;
$branch = \Branch::where('user_id', '=', $userID)->first();
$prifix = $branch->branch_code;
// branch prifix code
$count = \BranchEmp::withTrashed()->where('branch_id', '=', $userID)->count();
// count all registered user of this branch
$i = 0;
foreach ($users as $val) {
\DB::beginTransaction();
$temp = $count + 1;
// increase one
$count++;
$postfix = sprintf('%04d', $temp);
// manupulate 000$temp
$username = $prifix . $postfix;
$password = str_random(10);
$hashPassword = \Hash::make($password);
$email = $val['users'][1];
$uId = \User::insertGetId(array('username' => $username, 'password' => $hashPassword, 'displayname' => $val['users'][0], 'email' => $val['users'][1], 'profilesId' => 4, 'active' => 'Y'));
//create branch employee
$branchEmployee = \BranchEmp::insertGetId(array('branch_id' => $userID, 'emp_id' => $uId));
// Insert Personal detail
$empId = \Employee::insertGetId(array('user_id' => $uId, 'firstname' => $PersonalDetails[$i]['PersonalDetails'][0], 'lastname' => $PersonalDetails[$i]['PersonalDetails'][2], 'middlename' => $PersonalDetails[$i]['PersonalDetails'][1], 'fathername' => $PersonalDetails[$i]['PersonalDetails'][3], 'mothermaiden' => $PersonalDetails[$i]['PersonalDetails'][8], 'dateofbirth' => $PersonalDetails[$i]['PersonalDetails'][4], 'maritialstatus' => $PersonalDetails[$i]['PersonalDetails'][5], 'spousename' => $PersonalDetails[$i]['PersonalDetails'][6], 'sibling' => $PersonalDetails[$i]['PersonalDetails'][8], 'bloodgroup' => $PersonalDetails[$i]['PersonalDetails'][9]));
// Contact Information
$contact = \UserContact::insertGetId(array('user_id' => $uId, 'address' => $ContactInfo[$i]['ContactInfo'][0], 'city' => $ContactInfo[$i]['ContactInfo'][1], 'state' => $ContactInfo[$i]['ContactInfo'][2], 'pin' => $ContactInfo[$i]['ContactInfo'][3], 'p_address' => $ContactInfo[$i]['ContactInfo'][4], 'p_city' => $ContactInfo[$i]['ContactInfo'][5], 'p_state' => $ContactInfo[$i]['ContactInfo'][6], 'p_pin' => $ContactInfo[$i]['ContactInfo'][7], 'mobile' => $ContactInfo[$i]['ContactInfo'][8], 'phone' => $ContactInfo[$i]['ContactInfo'][9], 'alt_mobile' => $ContactInfo[$i]['ContactInfo'][10], 'alt_email' => $ContactInfo[$i]['ContactInfo'][11]));
//IdentificationandBankInfo
$identification = \EmpIdentification::insertGetId(array('user_id' => $uId, 'pan' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][0], 'passport_no' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][1], 'adhar_no' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][2], 'voter_id' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][3], 'driving_licence' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][4]));
// Bank Detail
$bankDetails = \EmpBankDetail::insertGetId(array('user_id' => $uId, 'account_no' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][5], 'bank_name' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][6], 'branch' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][7], 'IFSC' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][8], 'micrno' => $IdentificationandBankInfo[$i]['IdentificationandBankInfo'][9]));
// Esi and PF Detail
$PfEsi = \PfEsi::insertGetId(array('user_id' => $uId, 'isPF' => $PFandESIInformation[$i]['PFandESIInformation'][0], 'pfno' => $PFandESIInformation[$i]['PFandESIInformation'][1], 'pfenno' => $PFandESIInformation[$i]['PFandESIInformation'][2], 'epfno' => $PFandESIInformation[$i]['PFandESIInformation'][3], 'relationship' => $PFandESIInformation[$i]['PFandESIInformation'][4], 'isESI' => $PFandESIInformation[$i]['PFandESIInformation'][5], 'esino' => $PFandESIInformation[$i]['PFandESIInformation'][6]));
// Job details
$jobdetailsId = \JobDetails::insertGetId(array('user_id' => $uId, 'joining_date' => $JobDetails[$i]['JobDetails'][0], 'job_type' => $JobDetails[$i]['JobDetails'][1], 'designation' => $JobDetails[$i]['JobDetails'][2], 'department' => $JobDetails[$i]['JobDetails'][3], 'reporting_manager' => $JobDetails[$i]['JobDetails'][4], 'payment_mode' => $JobDetails[$i]['JobDetails'][5], 'hr_verification' => $JobDetails[$i]['JobDetails'][6], 'police_verification' => $JobDetails[$i]['JobDetails'][7], 'emp_type' => $JobDetails[$i]['JobDetails'][8], 'client_id' => $JobDetails[$i]['JobDetails'][9]));
//EducationalBackground
$eduction = \EmpEducation::insertGetId(array('user_id' => $uId, 'school_name' => $EducationalBackground[$i]['EducationalBackground'][0], 'school_location' => $EducationalBackground[$i]['EducationalBackground'][1], 'school_percentage' => $EducationalBackground[$i]['EducationalBackground'][2], 'puc_name' => $EducationalBackground[$i]['EducationalBackground'][3], 'puc_location' => $EducationalBackground[$i]['EducationalBackground'][4], 'puc_percentage' => $EducationalBackground[$i]['EducationalBackground'][5], 'diploma_name' => $EducationalBackground[$i]['EducationalBackground'][6], 'diploma_location' => $EducationalBackground[$i]['EducationalBackground'][7], 'diploma_percentage' => $EducationalBackground[$i]['EducationalBackground'][8], 'degree_name' => $EducationalBackground[$i]['EducationalBackground'][9], 'degree_location' => $EducationalBackground[$i]['EducationalBackground'][10], 'degree_percentage' => $EducationalBackground[$i]['EducationalBackground'][11], 'master_name' => $EducationalBackground[$i]['EducationalBackground'][12], 'master_location' => $EducationalBackground[$i]['EducationalBackground'][13], 'master_percentage' => $EducationalBackground[$i]['EducationalBackground'][14]));
// Experiance
$companyDetails = \WorkExperiance::insertGetId(array('user_id' => $uId, 'company_name' => $WorkExperience[$i]['WorkExperience'][0], 'location' => $WorkExperience[$i]['WorkExperience'][1], 'designation' => $WorkExperience[$i]['WorkExperience'][2], 'last_ctc' => $WorkExperience[$i]['WorkExperience'][3], 'join_date' => $WorkExperience[$i]['WorkExperience'][4], 'leaving_date' => $WorkExperience[$i]['WorkExperience'][5]));
\DB::commit();
\Mail::send('emails.user_credential', array('name' => $val['users'][0], 'username' => $username, 'password' => $password), function ($message) use($email, $username) {
$message->to($email, $username)->subject('User Credential');
});
$i++;
}
// end foreach of database insertion
// success message
$success = array('success' => "Successfully uploaded your Employees");
echo json_encode($success);
return;
}
// end else part
}
// end ajax condition
}
public function factura2()
{
// return Response::json(Input::all());
$account = DB::table('accounts')->where('id', '=', Auth::user()->account_id)->first();
//$matriz = Branch::where('number_branch','=',0)->first();
$matriz = Branch::where('id', 2)->first();
$branch = Branch::where('id', '=', Session::get('branch_id'))->first();
$type_document = TypeDocument::where('account_id', Auth::user()->account_id)->where('master_id', Input::get('invoice_type'))->orderBy('id', 'DESC')->first();
if (Input::get('printer_type') == 1) {
$js = $type_document->javascript_web;
} else {
$js = $type_document->javascript_pos;
}
$client = Client::where('id', Input::get('client'))->first();
$invoice = (object) ['id' => '0', 'account_name' => $account->name, 'account_nit' => $account->nit, 'account_uniper' => $account->uniper, 'address1' => $branch->address1, 'address2' => $branch->address2, 'terms' => Input::get('terms'), 'importe_neto' => Input::get('total'), 'importe_total' => Input::get('subtotal'), 'discount' => number_format(Input::get('subtotal') - Input::get('total'), 2, '.', ''), 'importe_ice' => number_format(Input::get('importe_ice'), 2, '.', ''), 'debito_fiscal' => number_format(Input::get('importe_fiscal'), 2, '.', ''), 'branch_name' => $branch->name, 'city' => $branch->city, 'client_id' => Input::get('client'), 'client_name' => Input::get('nombre'), 'client_nit' => Input::get('nit'), 'control_code' => '00-00-00-00', 'deadline' => $branch->deadline, 'descuento_total' => Input::get('discount'), 'economic_activity' => $branch->economic_activity, 'end_date' => Input::get('due_date'), 'invoice_date' => Input::get('invoice_date'), 'invoice_number' => 0, 'number_autho' => $branch->number_autho, 'phone' => $branch->work_phone, 'public_notes' => Input::get('public_notes'), 'logo' => $type_document->logo, 'sfc' => $branch->sfc, 'type_third' => $branch->type_third, 'branch_id' => $branch->id, 'state' => $branch->state, 'law' => $branch->law, 'javascript' => $js, 'document_number' => 0, 'extralabel' => $client->custom_value1];
// $document= TypeDocument::where("id",$invoice->javascript)->first();
// $invoice->logo = $document->logo;
// $invoice->javascript = $invoice->logo?$document->javascript_web:$document->javascript_pos;
$user = Auth::user();
$products = array();
foreach (Input::get('productos') as $producto) {
$product = Product::where('account_id', Auth::user()->account_id)->where('product_key', $producto["'product_key'"])->first();
if ($product != null) {
$prod = (object) ['product_key' => $producto["'product_key'"], 'notes' => $product->notes, 'cost' => $producto["'cost'"], 'qty' => $producto["'qty'"] + $product->units * $producto["'pack'"], 'packs' => $producto["'qty'"] / $product->units + $producto["'pack'"]];
array_push($products, $prod);
}
}
// $invoice = Input::all();
$template = TypeDocumentBranch::where('branch_id', $invoice->branch_id)->select('template')->first();
//return 0;
$data = array('invoice' => $invoice, 'account' => $account, 'products' => $products, 'copia' => 0, 'matriz' => $matriz, 'user' => $user, 'template' => $template);
// if(Input::get('printer_type')==0)
// return View::make('factura.ver2',$data);
return View::make('factura.ver', $data);
}
public function do_select_branch()
{
if (Input::get('branch_id')) {
$branch_id = Input::get('branch_id');
$branch = Branch::where('account_id', '=', Auth::user()->account_id)->where('public_id', $branch_id)->first();
$user = Auth::user();
$user->branch_id = $branch->id;
$user->save();
return Redirect::intended('/');
}
}
private function save($publicId = null)
{
$action = Input::get('action');
$entityType = Input::get('entityType');
if ($action == 'archive' || $action == 'delete' || $action == 'mark') {
return InvoiceController::bulk($entityType);
}
$input = json_decode(Input::get('data'));
$invoice = $input->invoice;
if (Utils::isAdmin()) {
$branch_id = $input->invoice->branch_id;
$branch = Branch::where('account_id', '=', Auth::user()->account_id)->where('public_id', $branch_id)->first();
// $branch = DB::table('branches')->where('id',$branch_id)->first();
} else {
$branch = Auth::user()->branch;
$branch_id = $branch->id;
$branch = DB::table('branches')->where('id', $branch_id)->first();
}
$today = new DateTime('now');
$today = $today->format('Y-m-d');
$datelimit = DateTime::createFromFormat('Y-m-d', $branch->deadline);
$datelimit = $datelimit->format('Y-m-d');
$valoresPrimera = explode("-", $datelimit);
$valoresSegunda = explode("-", $today);
$diaPrimera = $valoresPrimera[2];
$mesPrimera = $valoresPrimera[1];
$anyoPrimera = $valoresPrimera[0];
$diaSegunda = $valoresSegunda[2];
$mesSegunda = $valoresSegunda[1];
$anyoSegunda = $valoresSegunda[0];
$a = gregoriantojd($mesPrimera, $diaPrimera, $anyoPrimera);
$b = gregoriantojd($mesSegunda, $diaSegunda, $anyoSegunda);
$errorS = "Expiró la fecha límite de " . $branch->name;
if ($a - $b < 0) {
Session::flash('error', $errorS);
return Redirect::to("{$entityType}s/create")->withInput();
} else {
$last_invoice = Invoice::where('account_id', '=', Auth::user()->account_id)->first();
if ($last_invoice) {
$yesterday = $last_invoice->invoice_date;
$today = date("Y-m-d", strtotime($invoice->invoice_date));
$errorD = "La fecha de la factura es incorrecta";
$yesterday = new DateTime($yesterday);
$today = new DateTime($today);
if ($yesterday > $today) {
Session::flash('error', $errorD);
return Redirect::to("{$entityType}s/create")->withInput();
}
}
if ($errors = $this->invoiceRepo->getErrors($invoice)) {
Session::flash('error', trans('texts.invoice_error'));
return Redirect::to("{$entityType}s/create")->withInput()->withErrors($errors);
} else {
$this->taxRateRepo->save($input->tax_rates);
$clientData = (array) $invoice->client;
$clientData['branch'] = $branch->id;
$client = $this->clientRepo->save($invoice->client->public_id, $clientData);
$invoiceData = (array) $invoice;
$invoiceData['branch_id'] = $branch->id;
$invoiceData['client_id'] = $client->id;
$invoiceData['client_nit'] = $client->nit;
$invoiceData['client_name'] = $client->name;
$invoiceData['action'] = $action;
$invoice = $this->invoiceRepo->save($publicId, $invoiceData, $entityType);
$account = Auth::user()->account;
// if ($account->invoice_taxes != $input->invoice_taxes
// || $account->invoice_item_taxes != $input->invoice_item_taxes
// || $account->invoice_design_id != $input->invoice->invoice_design_id)
// {
// $account->invoice_taxes = $input->invoice_taxes;
// $account->invoice_item_taxes = $input->invoice_item_taxes;
// $account->invoice_design_id = $input->invoice->invoice_design_id;
// $account->save();
// }
$client->load('contacts');
$sendInvoiceIds = [];
foreach ($client->contacts as $contact) {
if ($contact->send_invoice || count($client->contacts) == 1) {
$sendInvoiceIds[] = $contact->id;
}
}
foreach ($client->contacts as $contact) {
$invitation = Invitation::scope()->whereContactId($contact->id)->whereInvoiceId($invoice->id)->first();
if (in_array($contact->id, $sendInvoiceIds) && !$invitation) {
$invitation = Invitation::createNew();
$invitation->invoice_id = $invoice->id;
$invitation->contact_id = $contact->id;
$invitation->invitation_key = str_random(RANDOM_KEY_LENGTH);
$invitation->save();
} else {
if (!in_array($contact->id, $sendInvoiceIds) && $invitation) {
$invitation->delete();
}
}
}
$invoice_date = date("d/m/Y", strtotime($invoice->invoice_date));
require_once app_path() . '/includes/BarcodeQR.php';
// $ice = $invoice->amount-$invoice->fiscal;
$desc = $invoice->subtotal - $invoice->amount;
$subtotal = number_format($invoice->subtotal, 2, '.', '');
$amount = number_format($invoice->amount, 2, '.', '');
$fiscal = number_format($invoice->fiscal, 2, '.', '');
// $icef = number_format($ice, 2, '.', '');
$descf = number_format($desc, 2, '.', '');
// if($icef=="0.00"){
// $icef = 0;
// }
if ($descf == "0.00") {
$descf = 0;
}
$icef = 0;
$qr = new BarcodeQR();
$datosqr = $invoice->account_nit . '|' . $invoice->invoice_number . '|' . $invoice->number_autho . '|' . $invoice_date . '|' . $subtotal . '|' . $amount . '|' . $invoice->control_code . '|' . $invoice->client_nit . '|' . $icef . '|0|0|' . $descf;
$qr->text($datosqr);
$qr->draw(150, 'qr/' . $account->account_key . '_' . $branch->name . '_' . $invoice->invoice_number . '.png');
$input_file = 'qr/' . $account->account_key . '_' . $branch->name . '_' . $invoice->invoice_number . '.png';
$output_file = 'qr/' . $account->account_key . '_' . $branch->name . '_' . $invoice->invoice_number . '.jpg';
$inputqr = imagecreatefrompng($input_file);
list($width, $height) = getimagesize($input_file);
$output = imagecreatetruecolor($width, $height);
$white = imagecolorallocate($output, 255, 255, 255);
imagefilledrectangle($output, 0, 0, $width, $height, $white);
imagecopy($output, $inputqr, 0, 0, 0, 0, $width, $height);
imagejpeg($output, $output_file);
$invoice->qr = HTML::image_data('qr/' . $account->account_key . '_' . $branch->name . '_' . $invoice->invoice_number . '.jpg');
$invoice->save();
$message = trans($publicId ? "texts.updated_{$entityType}" : "texts.created_{$entityType}");
if ($input->invoice->client->public_id == '-1') {
$message = $message . ' ' . trans('texts.and_created_client');
$url = URL::to('clients/' . $client->public_id);
Utils::trackViewed($client->getDisplayName(), ENTITY_CLIENT, $url);
}
if ($action == 'clone') {
return $this->cloneInvoice($publicId);
} else {
if ($action == 'convert') {
return $this->convertQuote($publicId);
} else {
if ($action == 'email') {
$aux = 0;
foreach ($client->contacts as $contact) {
if ($contact->email) {
$aux = 1;
}
}
if ($aux == 0) {
$errorMessage = trans('El cliente no tiene Correo Electrónico.');
Session::flash('error', $errorMessage);
} else {
if (Auth::user()->confirmed && !Auth::user()->isDemo()) {
$message = trans("texts.emailed_{$entityType}");
$this->mailer->sendInvoice($invoice);
Session::flash('message', $message);
} else {
$errorMessage = trans(Auth::user()->registered ? 'texts.confirmation_required' : 'texts.registration_required');
Session::flash('error', $errorMessage);
Session::flash('message', $message);
}
}
} else {
if ($action == 'savepay') {
$payment = Payment::createNew();
$payment->client_id = $client->id;
$payment->invoice_id = $invoice->id;
$payment->payment_type_id = 1;
$payment->payment_date = $invoice->invoice_date;
$payment->amount = $invoice->amount;
$payment->save();
$message = trans("texts.savepay_{$entityType}");
Session::flash('message', $message);
} else {
if ($action == 'savepaycredit') {
$payment = Payment::createNew();
$credits = Credit::scope()->where('client_id', '=', $client->id)->where('balance', '>', 0)->orderBy('created_at')->get();
$applied = 0;
foreach ($credits as $credit) {
$applied += $credit->apply($invoice->amount);
if ($applied >= $invoice->amount) {
break;
}
}
$payment->client_id = $client->id;
$payment->invoice_id = $invoice->id;
$payment->payment_type_id = 2;
$payment->payment_date = $invoice->invoice_date;
$payment->amount = $invoice->amount;
$payment->save();
$message = trans("texts.savepay_{$entityType}");
Session::flash('message', $message);
} else {
Session::flash('message', $message);
}
}
}
}
}
$url = "{$entityType}s/" . $invoice->public_id . '/edit';
return Redirect::to($url);
}
}
}
private function mapFileInvoice()
{
$file = Input::file('file');
if ($file == null) {
Session::flash('error', trans('texts.select_file'));
return Redirect::to('company/import_export');
}
$name = $file->getRealPath();
require_once app_path() . '/includes/parsecsv.lib.php';
$csv = new parseCSV();
$csv->heading = false;
$csv->auto($name);
Session::put('data', $csv->data);
$headers = false;
$hasHeaders = false;
$mapped = array();
$columns = array('', Invoice::$fieldCodClient, Invoice::$fieldProduct, Invoice::$fieldAmount);
if (count($csv->data) > 0) {
$headers = $csv->data[0];
foreach ($headers as $title) {
if (strpos(strtolower($title), 'name') > 0) {
$hasHeaders = true;
break;
}
}
for ($i = 0; $i < count($headers); $i++) {
$title = strtolower($headers[$i]);
$mapped[$i] = '';
if ($hasHeaders) {
$map = array('cod_client' => Invoice::$fieldCodClient, 'product' => Invoice::$fieldProduct, 'amount' => Invoice::$fieldAmount);
foreach ($map as $search => $column) {
foreach (explode("|", $search) as $string) {
if (strpos($title, 'sec') === 0) {
continue;
}
if (strpos($title, $string) !== false) {
$mapped[$i] = $column;
break 2;
}
}
}
}
}
}
$data = array('data' => $csv->data, 'headers' => $headers, 'hasHeaders' => $hasHeaders, 'columns' => $columns, 'mapped' => $mapped);
$data['branches'] = Branch::where('account_id', '=', Auth::user()->account_id)->orderBy('id')->get();
return View::make('accounts.import_map_invoice', $data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
\DB::beginTransaction();
$branch = \Branch::where('id', '=', $id)->with('contact')->firstOrFail();
$user = \User::where('id', '=', $branch->user_id)->firstOrFail();
$contact = \BranchContact::where('branch_id', '=', $id)->firstOrFail();
// $branchEmp=\BranchEmp::where('branch_id','=',$id)->firstOrFail();
if (!$user->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
}
if (!$branch->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
}
if (!$contact->delete()) {
\DB::rollback();
return \Redirect::back()->with('error', 'Failed to delete');
} else {
\DB::commit();
return \Redirect::back()->with('success', 'Successfully deleted');
}
}
public function getMoreHomePageSqueeb($lastid)
{
$campusid = $this->getDevice();
$obj = new BaseController();
$campusid = $this->getDevice();
if ($campusid == 0) {
$countryname = $obj->getCountryName();
if ($countryname == 'NONE') {
return Redirect::route('selectcampus-get');
} else {
//check whether the country name exists inthe db
$locationcountry = Country::where('name', '=', $countryname);
if ($locationcountry->count()) {
$locationcountrycode = $locationcountry->first()->code;
$locationcountrycode = strtolower($locationcountrycode);
return Redirect::route('selectcountryid', $locationcountrycode);
} else {
return Redirect::route('selectcampus-get');
}
}
}
$more = true;
$college = Institution::whereHas('Branch', function ($query) use($campusid) {
$query->where('id', '=', $campusid);
})->first();
$collegeid = $college->id;
$countryid = Country::where('id', '=', $college->country_id)->first()->id;
//get the top squeeb to display
$newsqueebs = Squeeb::where('active', '=', TRUE)->where('branch_id', '=', $campusid)->orderBy('id', 'DESC')->take(self::TOP_SQUEEB_LIMIT)->get();
View::share('newsqueebs', $newsqueebs);
$squeebs = Notice::whereHas('Squeeb', function ($query) use($campusid, $lastid) {
$query->where('branch_id', '=', $campusid)->where('id', '<', $lastid)->where('active', '=', TRUE);
})->orwhereHas('Squeeb', function ($query) use($lastid) {
$query->where('branch_id', '=', 0)->where('world', '=', TRUE)->where('id', '<', $lastid)->where('active', '=', TRUE);
})->orwhereHas('Squeeb', function ($query) use($lastid, $countryid) {
$query->where('branch_id', '=', 0)->where('country', '=', $countryid)->where('id', '<', $lastid)->where('active', '=', TRUE);
})->orwhereHas('Squeeb', function ($query) use($lastid, $collegeid) {
$query->where('branch_id', '=', 0)->where('college', '=', $collegeid)->where('id', '<', $lastid)->where('active', '=', TRUE);
});
$last = $squeebs;
$squeebs = $squeebs->orderBy('id', 'DESC')->take(self::SQUEEB_LIMIT)->get();
if ($squeebs->count()) {
$last_id = $last->orderBy('id', 'DESC')->take(self::SQUEEB_LIMIT)->get()->last()->Squeeb()->first()->id;
}
View::share('last_id', $last_id);
View::share('squeebs', $squeebs);
//get the top squeeb to display
$topsqueebs = Squeeb::where('active', '=', TRUE)->where('model', '=', 'Notice')->where('branch_id', '=', $campusid)->orderBy('views', 'DESC')->take(self::TOP_SQUEEB_LIMIT)->get();
View::share('topsqueebs', $topsqueebs);
if ($lastid <= 0 or $squeebs->count() != self::SQUEEB_LIMIT) {
$more = false;
}
$college = Institution::whereHas('Branch', function ($query) use($campusid) {
$query->where('id', '=', $campusid);
})->first();
View::share('college', $college);
View::share('more', $more);
$mycampus = Branch::where('id', '=', $campusid)->first();
View::share('mycampus', $mycampus);
return View::make('guest.home');
}
public function loginpos()
{
// $branch = DB::table('branches')->where('id','=',$user->branch_id)->first();
// $clients = DB::table('clients')->select('id','name','nit')->where('account_id',$user->account_id)->get(array('id','name','nit'));
// $account = DB::table('accounts')->where('id',$user->account_id) ->first();
$products = DB::table('products')->where('account_id', '=', Auth::user()->account_id)->get(array('id', 'product_key', 'notes', 'cost'));
// $ice = DB::table('tax_rates')->select('rate')
// // ->where('account_id','=',$user->account_id)
// ->where('name','=','ice')
// ->first();
// if(Auth::user()->is_admin){
$branches = Branch::where('account_id', Auth::user()->account_id)->select('id', 'name')->get();
// }else
// {
// }
$mensaje = array('productos' => $products, 'sucursales' => $branches);
return Response::json($mensaje);
}
private static function getViewModel()
{
return ['branches' => Branch::where('account_id', '=', Auth::user()->account_id)->where('public_id', '>', 0)->orderBy('public_id')->get(), 'price_types' => PriceType::orderBy('id')->get(), 'allgroups' => Group::orderBy('id')->get(array('id', 'name'))];
}
function update()
{
$this->filter_access('Branch', 'roled_edit', 'branches/index');
$branch = new Branch();
$branch->where('branch_id', $this->input->post('id'))->update('branch_name', $this->input->post('branch_name'));
$this->session->set_flashdata('message', 'Branch Update successfuly.');
redirect('branches/');
}
public function postGuestPostsCollege2()
{
//verify the user input and create account
$validator = Validator::make(Input::all(), array('Type' => 'required|in:Notice,Eventsq,Job,Offer', 'Title' => 'required|max:40', 'Description' => 'required', 'Name' => 'required|max:120', 'Email' => 'required|email|max:60', 'Pic' => 'image|max:3000', 'College' => 'required'));
if ($validator->fails()) {
return Redirect::route('advanced_squeeb-get')->withErrors($validator)->withInput()->with('global', 'Sorry!! Your Squeeb was not posted, please retry.');
} else {
$type = Input::get('Type');
$title = Input::get('Title');
$description = Input::get('Description');
$description = $this->MakeUrls($description);
$squeeb = substr(strip_tags($description), 0, 300);
$name = Input::get('Name');
$email = Input::get('Email');
$file = Input::file('Pic');
$package = Input::get('Package');
$collegeid = Input::get('College');
$campuses = Branch::where('institutions_id', '=', $collegeid)->select('id')->get();
//check whether the user with this email existed before
$user = User::where('email', '=', $email);
$firstname = NULL;
$lastname = NULL;
//extract the firstname and last name from the name
if (preg_match('/\\s/', $name)) {
$names = explode(" ", $name);
$firstname = $names[0];
$lastname = $names[1];
} else {
$firstname = $name;
}
if ($user->count()) {
$user = $user->orderBy('id', 'DESC')->first();
} else {
//store the user details
$user = User::create(array('email' => $email, 'firstname' => $firstname, 'lastname' => $lastname));
}
//get the model name
$model = $type;
$result = $this->postUploadPhoto($type, $file);
$the_squeeb_array = array();
foreach ($campuses as $campus) {
$the_squeeb = Squeeb::create(array('model' => $model, 'views' => 0, 'branch_id' => $campus->id, 'create_day' => date("Y-m-d")));
array_push($the_squeeb_array, $the_squeeb->id);
//create the post details
$squeeb_id = 0;
$squeeb_id = $this->createSqueeb($model, $the_squeeb->id, $user->id, $title, $description, $squeeb);
//finally post the squeebe photo
if ($squeeb_id) {
if ($result != FALSE) {
//photos validation
$modelname = $type;
$tablename = lcfirst($modelname) . 's';
$modelphoto = $modelname . 'Photo';
$savesuccess = $modelphoto::create(array($tablename . '_id' => $squeeb_id, 'name' => $result));
}
}
}
if ($user && $the_squeeb) {
if ($squeeb_id) {
$squeeb = Squeeb::where('id', '=', $the_squeeb->id)->first();
View::share('squeeb', $squeeb);
view::share('model', $type);
$the_squeeb_array = implode(",", $the_squeeb_array);
View::share('the_squeeb_array', $the_squeeb_array);
return View::make('guest.advanced_squeeb_preview');
}
}
}
return Redirect::route('advanced_squeeb-get')->with('global', 'Some Error Occured, Please try again');
}
public function run()
{
DB::table('categories')->truncate();
//1
$category = new Category();
$category->name = "Street Style";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//2
$category = new Category();
$category->name = "Running-training";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//3
$category = new Category();
$category->name = "Basketball";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//4
$category = new Category();
$category->name = "Tennis";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//5
$category = new Category();
$category->name = "Sandal";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//6
$category = new Category();
$category->name = "Dép";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//7
$category = new Category();
$category->name = "Adix";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//8
$category = new Category();
$category->name = "Asics Gel";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//9
$category = new Category();
$category->name = "Neo";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//10
$category = new Category();
$category->name = "NB";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//11
$category = new Category();
$category->name = "Rade";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//12
$category = new Category();
$category->name = "Rade R2";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//13
$category = new Category();
$category->name = "Zx";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//14
$category = new Category();
$category->name = "F1";
$category->parent_id = 1;
$category->root_category_id = 1;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//15
$category = new Category();
$category->name = "Flex";
$category->parent_id = 2;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//16
$category = new Category();
$category->name = "Giày Cut";
$category->parent_id = 2;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//17
$category = new Category();
$category->name = "Asics Training";
$category->parent_id = 2;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//18
$category = new Category();
$category->name = "Baseketrade";
$category->parent_id = 3;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//19
$category = new Category();
$category->name = "Giày Cut";
$category->parent_id = 3;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//20
$category = new Category();
$category->name = "Adi Tennis";
$category->parent_id = 4;
$category->root_category_id = 4;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//21
$category = new Category();
$category->name = "Flex Training";
$category->parent_id = 15;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//22
$category = new Category();
$category->name = "Flex Pro";
$category->parent_id = 15;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//23
$category = new Category();
$category->name = "Dual Fusion";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//24
$category = new Category();
$category->name = "Flex Supreme";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//25
$category = new Category();
$category->name = "T Lite MM";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//26
$category = new Category();
$category->name = "Season";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//27
$category = new Category();
$category->name = "Air Max";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//28
$category = new Category();
$category->name = "Maori";
$category->parent_id = 16;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//29
$category = new Category();
$category->name = "GT";
$category->parent_id = 17;
$category->root_category_id = 2;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//30
$category = new Category();
$category->name = "Crazy Beat";
$category->parent_id = 18;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//31
$category = new Category();
$category->name = "Dual Fusion Basketball";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//32
$category = new Category();
$category->name = "Prime Hype";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//33
$category = new Category();
$category->name = "Visi Pro";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//34
$category = new Category();
$category->name = "Air Premier";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//35
$category = new Category();
$category->name = "Zoom";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//36
$category = new Category();
$category->name = "Jordan";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//37
$category = new Category();
$category->name = "Overplay";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//38
$category = new Category();
$category->name = "Kobe";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//39
$category = new Category();
$category->name = "Kobe";
$category->parent_id = 19;
$category->root_category_id = 3;
$category->Branch()->associate(Branch::where('name', '=', 'Giày dép')->first());
$category->save();
//40
$category = new Category();
$category->name = "Áo thun";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//41
$category = new Category();
$category->name = "Áo khoác";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//42
$category = new Category();
$category->name = "Quần Jogger";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//43
$category = new Category();
$category->name = "Quần Sweat";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//44
$category = new Category();
$category->name = "Quần short";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//45
$category = new Category();
$category->name = "Balance";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//46
$category = new Category();
$category->name = "Long Tee";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//47
$category = new Category();
$category->name = "Raglan";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//48
$category = new Category();
$category->name = "Tank Top";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//49
$category = new Category();
$category->name = "Print Tee";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//50
$category = new Category();
$category->name = "Sport Shirt";
$category->parent_id = 40;
$category->root_category_id = 40;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//51
$category = new Category();
$category->name = "Hoodie";
$category->parent_id = 41;
$category->root_category_id = 41;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//52
$category = new Category();
$category->name = "Bomber";
$category->parent_id = 41;
$category->root_category_id = 41;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//53
$category = new Category();
$category->name = "Jacket";
$category->parent_id = 41;
$category->root_category_id = 41;
$category->Branch()->associate(Branch::where('name', '=', 'Áo quần')->first());
$category->save();
//54
$category = new Category();
$category->name = "Balo";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//55
$category = new Category();
$category->name = "Túi Gym";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//56
$category = new Category();
$category->name = "Túi trống lớn";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//57
$category = new Category();
$category->name = "Túi xách";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//58
$category = new Category();
$category->name = "Túi rút";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//59
$category = new Category();
$category->name = "Hộp";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//60
$category = new Category();
$category->name = "Vớ";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//61
$category = new Category();
$category->name = "Dây";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
//62
$category = new Category();
$category->name = "Nón";
$category->parent_id = 0;
$category->Branch()->associate(Branch::where('name', '=', 'Phụ kiện')->first());
$category->save();
}
