public function activitySearch() { $customerName = Input::get('customer'); // $allCustomers = Customer::where('company_name', 'LIKE', "%$customerName%") ->get(); $allCustomers = Customer::where('company_name', 'LIKE', "%{$customerName}%")->get(); return View::make('activities.customer-list', array('company' => $allCustomers)); }
public function edit_help($user) { switch ($user->type) { case 'customer': Customer::where('id', '=', $user->id)->delete(); break; case 'driver': Driver::where('id', '=', $user->id)->delete(); break; case 'business': Business::where('id', '=', $user->id)->delete(); break; default: break; } $user->type = Input::get('type'); $user->save(); switch (Input::get('type')) { case 'driver': $driver = new Driver(); $driver->id = $user->id; $driver->first_name = Input::get('first_name'); $driver->last_name = Input::get('last_name'); $driver->phone = Input::get('phone'); $driver->home_address = Input::get('address'); $driver->credit_card = Input::get('credit_card'); $driver->cvv = Input::get('cvv'); $driver->expiry_date = Input::get('expiry_date'); $driver->car_type = Input::get('car_type'); $driver->cab_no = Input::get('cab_no'); $driver->flag = Input::get('flag'); $driver->rate = Input::get('rate'); $driver->hour = Input::get('hour'); $driver->save(); break; case 'customer': $customer = new Customer(); $customer->id = $user->id; $customer->first_name = Input::get('first_name'); $customer->last_name = Input::get('last_name'); $customer->phone = Input::get('phone'); $customer->home_address = Input::get('address'); $customer->credit_card = Input::get('credit_card'); $customer->cvv = Input::get('cvv'); $customer->expiry_date = Input::get('expiry_date'); $customer->save(); break; case 'business': $business = new Business(); $business->id = $user->id; $business->business_name = Input::get('business_name'); $business->phone = Input::get('phone'); $business->home_address = Input::get('address'); $business->credit_card = Input::get('credit_card'); $business->cvv = Input::get('cvv'); $business->expiry_date = Input::get('expiry_date'); $business->save(); break; } }
private function dbMailingSender() { $customers = Customer::where('is_active', '=', 1)->get(); foreach ($customers as $customer) { $subject = 'Hemos añadido una nueva oferta para ti, no te la pierdas!.'; $email = $customer->email; $name = $customer->customer_name; $title = $this->voucher->title; $this->mail($email, $name, $title, $subject); } }
public function generateCustomerId() { $stop = null; $customer_id = null; do { $customer_id = rand(1111111, 999999) . '-' . Carbon::now()->year; //7 digit customer id $customer = Customer::where('membership_id', $customer_id)->first(); if ($customer && !empty($customer)) { $stop = true; return $customer_id; } } while ($stop = false); return $customer_id; }
/** * Function to add a new customer to the database * * Returns customer id for appointment creation * **/ public static function addCustomer() { // We get appointment information then set up our validator $info = Session::get('appointmentInfo'); $validator = Validator::make(array('first_name' => $info['fname'], 'last_name' => $info['lname'], 'email' => $info['email']), array('first_name' => 'exists:customers,first_name', 'last_name' => 'exists:customers,last_name', 'email' => 'exists:customers,email')); // If the validator fails, that means the user does not exist // If any of those three variables don't exist, we create a new user // This is so that families can use the same e-mail to book, but // We stil create a new user for them in the database. if ($validator->fails()) { // Registering the new user return Customer::create(array('first_name' => $info['fname'], 'last_name' => $info['lname'], 'contact_number' => $info['number'], 'email' => $info['email'], 'wants_updates' => Session::get('updates')))->id; } else { return Customer::where('email', $info['email'])->pluck('id'); } }
public function searchCustomerToken() { $str = strtolower(Input::get('gettoken')); //$field = ( preg_match("/^[0-9 ]*$/", $str) !== 0 ) ? 'phone' : 'email'; //We check to determine if we search through phone or token //if( $field === 'phone' ){ $field = strlen($str) < 11 ? 'token' : 'phone'; //} $tokenInfo = Customer::where($field, '=', Input::get('gettoken'))->select('id', 'name', 'token')->get()->first(); if (!empty($tokenInfo)) { $data['status'] = 'success'; $data['message'] = $tokenInfo->name . ' Token-ID found!'; $data['detail'] = "Name: " . $tokenInfo->name . " | Token-ID: " . $tokenInfo->token . ""; } else { $data['status'] = 'error'; $data['message'] = 'Customer does not exist'; } return Response::json($data); }
function list_by_parent($id, $customer_id) { $cartdetails = new Cartdetail(); $cartdetails->order_by('id', 'desc'); $cartdetails->where('cart_id', $id); $cartdetails->get(); $customers = new Customer($customer_id); $customers->order_by('id', 'asc'); $customers->where('id', $customer_id); $customers->get(); $dis['base_url'] = base_url(); $dis['view'] = "cartdetail/listbyparent"; $dis['menu_active'] = 'Giỏ hàng'; $dis['title'] = "Chi tiết giỏ hàng"; $dis['title_customer'] = "Thông tin khách hàng"; $dis['cartdetails'] = $cartdetails; $dis['customers'] = $customers; $dis['nav_menu'] = array(array("type" => "back", "text" => "Back", "link" => "{$this->admin_url}carts/list_all/", "onclick" => "")); $this->viewadmin($dis); }
/** * 修改密码 * @return type */ public function modifyPassword() { // $oldpassword = Input::get('oldpassword'); $newpassword = Input::get('newpassword'); $msg = '密码修改失败'; if (Auth::check()) { $name = Auth::user()->name; // if (Hash::check($oldpassword, Auth::user()->password)) { if ($name != $newpassword) { $msg = '修改成功'; $result = Customer::where('id', Auth::id())->update(['password' => Hash::make($newpassword)]); } else { $msg = '密码与账号相同,请重新输入'; } // } } if (isset($result) && $result) { Auth::logout(); return Response::json(['err' => 0, 'msg' => $msg, 'success' => 1]); } else { return Response::json(['err' => 0, 'msg' => $msg, 'success' => 0]); } }
}); Route::get('booking', function () { $cpage = 'booklst'; $r = Room::select('id', 'name')->get(); return View::make('adminview.booking.index', compact('cpage', 'r')); }); Route::get('getbookinglist', 'BookingController@bookingList'); Route::post('getbookinglist/search', 'BookingController@searchList'); Route::post('getbookinginfo/{id}', 'BookingController@searchBooking'); Route::post('booking/{id}/update', 'BookingController@update'); Route::post('booking/{id}/payment', 'BookingController@payment'); Route::post('currentbooking/save', function () { $i = Input::all(); $membershipDiscount = null; if (isset($i['membership_id'])) { $membership = Customer::where('membership_id', $i['membership_id'])->first(); if ($membership) { $membershipDiscount = $membership->current_discount; } } $booking = Booking::where('id', $i['booking_id'])->first(); if ($booking) { $booking->firstname = $i['firstname']; $booking->lastname = $i['lastname']; $booking->address = $i['address']; $booking->contact_number = $i['contact_no']; $booking->status = 1; $booking->save(); $reservation = ReservedRoom::where('booking_id', $i['booking_id'])->get(); if (count($reservation) > 0) { foreach ($reservation as $r) {
/** * Remove the specified resource from storage. * DELETE /customers/{id} * * @param int $id * @return Response */ public function delete($id) { $c = Customer::where('membership_id', $id)->first(); if ($c) { $c->delete(); } }
public function update_job_order_po() { $id = Input::get('id'); /*$data['scope'] = QuotationScope::where('quotation_id', $id)->get(); echo "<pre>"; print_r($data['scope']); die();*/ $id = Input::get('id'); $job_order = Input::all(); $job_order_da = Input::all(); $jo_daRules = array('created_at' => 'required', 'date_needed' => 'required', 'company_name' => 'required', 'revision_number' => 'required', 'type_of_work' => 'required', 'measurements_from' => 'required'); $jo_daValidator = Validator::make($job_order_da, $jo_daRules); if ($jo_daValidator->fails()) { return Redirect::back()->withErrors($jo_daValidator)->withInput(Input::all()); } $job_order = Quotation::find($id); $job_order->created_at = Input::get('created_at'); $job_order->date_needed = Input::get('date_needed'); $job_order->type_of_work_id = Input::get('type_of_work'); $job_order->po_status = 'Job Order'; $job_order->po_number = 'PO_000' . $id; $job_order->save(); $job_order_id = $job_order->customer->id; $scope_jo = Customer::where('id', $job_order_id)->first(); $scope_jo->name = Input::get('company_name'); $scope_jo->save(); return Redirect::to('production/back')->with('message', 'Job order updated successfully'); }
private function CreateAllDir() { $customer = Auth::user()->name; $cus_id = Auth::id(); $weburl = Customer::where('id', $cus_id)->pluck('weburl'); $suf_url = str_replace('http://c', '', $weburl); if (!file_exists(public_path('customers/' . $customer))) { mkdir(public_path('customers/' . $customer)); } $zip = new ZipArchive(); //新建一个ZipArchive的对象 if ($zip->open(public_path('packages/customernull.zip')) === TRUE) { $zip->extractTo(public_path('customers/' . $customer)); } $zip->close(); $customerinfo = Customer::find($cus_id); $ftp_array = explode(':', $customerinfo->ftp_address); $port = $customerinfo->ftp_port; $ftpdir = $customerinfo->ftp_dir; $ftp = $customerinfo->ftp; $ftp_array[1] = isset($ftp_array[1]) ? $ftp_array[1] : $port; $conn = ftp_connect($ftp_array[0], $ftp_array[1]); if ($conn) { ftp_login($conn, $customerinfo->ftp_user, $customerinfo->ftp_pwd); ftp_pasv($conn, 1); if (trim($ftp) == '1') { if (ftp_nlist($conn, $customer) === FALSE) { ftp_mkdir($conn, $customer); } ftp_put($conn, $customer . "/unzip.php", public_path("packages/unzip.php"), FTP_ASCII); ftp_put($conn, $customer . "/site.zip", public_path('packages/customernull.zip'), FTP_BINARY); @file_get_contents('http://' . $customer . $suf_url . "/unzip.php"); } else { if (ftp_nlist($conn, $ftpdir) === FALSE) { ftp_mkdir($conn, $ftpdir); } if (ftp_nlist($conn, $ftpdir . '/mobile') === FALSE) { ftp_mkdir($conn, $ftpdir . '/mobile'); } $domain = strlen(str_replace('http://', '', $customerinfo->pc_domain)) > 0 ? $customerinfo->pc_domain . '/mobile' : $customerinfo->mobile_domain; ftp_put($conn, $ftpdir . "/mobile/m_unzip.php", public_path("packages/m_unzip.php"), FTP_ASCII); ftp_put($conn, $ftpdir . "/mobile/site.zip", public_path('packages/customernull.zip'), FTP_BINARY); @file_get_contents("{$domain}/m_unzip.php"); } ftp_close($conn); } }
public function procOrder($id) { $order = Order::findOrFail($id); $order->status = 2; $order->save(); $items = Order::findOrFail($id)->orderItems; $user = Order::findOrFail($id)->user; $customer = Customer::where('nama', '=', $user->nama)->first(); return View::make('admin.orders.process', compact('order', 'items', 'customer')); }
public function templateUploadZip() { set_time_limit(0); $files = Input::file(); $cus_id = Auth::id(); $temptype = Input::get("type"); $customization = Customer::where('id', $cus_id)->pluck('customization'); if ($customization <= 0 || $customization != 3 && $customization != $temptype) { return Response::json(['err' => 1001, 'msg' => '您未开启相应的高级定制,高级定制需要付费,如需要,请联系客服', 'data' => '您未开启高级定制,高级定制需要付费,如需要,请联系客服']); } $files = Input::file(); $file = $files['upload_zip']; if ($file->isValid()) { $type = $file->getClientOriginalExtension(); $truth_name = date('ymd') . mt_rand(100, 999) . '.' . $type; if ($type == "zip") { if (file_exists(public_path("temp_templates/{$truth_name}"))) { $result = ['err' => 1000, 'msg' => '模板覆盖成功']; } else { $up_result = $file->move(public_path("temp_templates/"), $truth_name); if ($up_result) { if ($temptype == 1) { $name = WebsiteInfo::leftJoin('template', 'pc_tpl_id', '=', 'template.id')->where('website_info.cus_id', $cus_id)->pluck('name'); } else { $name = WebsiteInfo::leftJoin('template', 'mobile_tpl_id', '=', 'template.id')->where('website_info.cus_id', $cus_id)->pluck('name'); } $tpl_name = $name; $result = $this->saveTemplate($truth_name, $tpl_name, $temptype); $pushed = WebsiteInfo::where("cus_id", $cus_id)->pluck("pushed"); if ($temptype == 1) { if ($pushed == 0 || $pushed == 2) { $pushed = 2; } else { $pushed = 1; } } else { if ($pushed == 0 || $pushed == 3) { $pushed = 3; } else { $pushed = 1; } } WebsiteInfo::where("cus_id", $cus_id)->update(array("pushed" => $pushed)); } else { $result = ['err' => 1001, 'msg' => '模板覆盖失败']; } } } else { $result = ['err' => 1002, 'msg' => '模板覆盖失败,请上传正确的文件类型']; } } else { $result = ['err' => 1002, 'msg' => '模板覆盖失败,请上传正确的文件类型']; } return Response::json($result); }
function getFacebook() { $auth = Config::get('hybridauth'); $config = array("base_url" => URL::to('user/google'), "providers" => array("Facebook" => array("enabled" => true, "keys" => array("id" => $auth['providers']['Facebook']['keys']['id'], "secret" => $auth['providers']['Facebook']['keys']['secret'])))); if (isset($_REQUEST['hauth_start']) || isset($_REQUEST['hauth_done'])) { Hybrid_Endpoint::process(); } $socialAuth = new Hybrid_Auth($config); $provider = $socialAuth->authenticate("facebook"); $userProfile = $provider->getUserProfile(); $provider->logout(); $user = Customer::where('email', '=', $userProfile->email)->first(); return self::autoSigninCus($user, $userProfile); //$user = User::where('email','=',$userProfile->email)->first();print_r($user); //return self::autoSignin($user); }
private function _processHistory($id, $daterange) { Larasset::start('header')->css('daterangepicker'); Larasset::start('footer')->js('moment', 'daterangepicker'); if (strpos($daterange, '-') !== FALSE) { $fromandto = explode('-', $daterange); $from = sqldate($fromandto[0]); $to_plus_1day = strtotime('now') - strtotime('yesterday') + strtotime($fromandto[1]); $to = sqldate(date('Y/n/d', $to_plus_1day)); $data['todate'] = $fromandto[1]; } else { $from = sqldate(date('Y/n/d', strtotime('first day of this month'))); $to = sqldate('+1day'); $data['todate'] = $to; } $customerlog = Salelog::with(array('product' => function ($q) { $q->select('id', 'name', 'productcat_id')->with(array('categories' => function ($qr) { $qr->select('id', 'type'); })); }))->where('customer_id', '=', $id)->whereBetween('created_at', array($from, $to))->orderBy('id', 'desc'); //tt(groupThem($customerlog->get()->toArray(), 'receipt_id')); $customerDetails = Customer::where('id', '=', $id)->first(); //$data['customerhistory'] = $customerlog->get()->toArray(); $data['customerhistory'] = groupThem($customerlog->get()->toArray(), 'receipt_id'); $data['customerdetail'] = $customerDetails; $data['fromdate'] = $from; $this->layout->title = 'Customer History'; $this->layout->content = View::make('admin.customerhistory', $data); }
/** * Get customers list * * @return json * @author Leo **/ public function _getCustomerListDropdownData() { $data = Input::all(); $hasData = false; if ($data) { $q = $data['q']; $customers = Customer::where('name', 'LIKE', "%{$q}%")->get(array('id', 'name')); if ($customers) { foreach ($customers as $key => $value) { $hasData = true; $results[] = array('id' => $value['id'], 'text' => $value['name']); } } } if (!$hasData) { $results[] = array('id' => " ", 'text' => "No results found, please refine your search parameter."); } return Response::json($results); }
/** * 推送 * * */ public function pushPrecent() { set_time_limit(0); if (Input::has("pushgrad") == 1) { echo '<script type="text/javascript">function refresh(str){parent.refresh(str);};</script>'; if (Input::has("push_c_id")) { $pushcid = Input::get("push_c_id"); } if (Input::has("end")) { $end = Input::get("end"); } // $pushcid = $this->pushcid; // $end = $this->end; // $this->percent=0; // $this->lastpercent=0; // $this->html_precent=0; // $this->last_html_precent=0; // $this->pcpush=0; // $this->mobilepush=0; // $this->quickbarpush=0; // $this->mobilehomepagepush=0; } else { if (!Input::has("name")) { echo '<script type="text/javascript">function refresh(str){parent.refresh(str);};</script>'; } if (Input::has("push_c_id")) { $pushcid = Input::get("push_c_id"); } if (Input::has("end")) { $end = Input::get("end"); } } $have_article = Articles::where('cus_id', $this->cus_id)->count(); if (!$have_article) { echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8">'; echo '<div class="prompt">没有文章不可推送</div><script type="text/javascript">alert("没有文章不可推送");refresh("没有文章不可推送");</script>'; ob_flush(); flush(); exit; } if (!isset($_GET['gradpush'])) { $this->needpush(); } else { $pc_domain = CustomerInfo::where('cus_id', $this->cus_id)->pluck('pc_domain'); $mobile_domain = CustomerInfo::where('cus_id', $this->cus_id)->pluck('mobile_domain'); $pc = str_replace('http://', '', $pc_domain); $mobile = str_replace('http://', '', $mobile_domain); if ($pc != '') { $this->pcpush = 1; } if ($mobile != '') { $this->mobilepush = 1; } $this->quickbarpush = 1; $this->mobilehomepagepush = 0; } echo '<div class="prompt">'; var_dump('pcpush:' . $this->pcpush); var_dump('mobilepush:' . $this->mobilepush); var_dump('quickbarpush:' . $this->quickbarpush); var_dump('mobilehomepagepush:' . $this->mobilehomepagepush); echo '</div>'; ob_flush(); flush(); $this->pushinit(); if (!isset($end) || $end == 1) { if ($this->quickbarpush) { $this->pushQuickbar(); } if (!$this->mobilepush) { if ($this->mobilehomepagepush) { $this->mobilehomepage_push(); } } } if ($this->pcpush || $this->mobilepush) { if (!$this->pcpush && $this->mobilepush) { $this->mobile_push(); return true; } if (ob_get_level() == 0) { ob_start(); } $pc_classify_ids = array(); $mobile_classify_ids = array(); $pc_article_ids = array(); $mobile_article_ids = array(); if ($this->mobilepush) { if (isset($pushcid)) { if (!isset($end) || $end == 1) { $mindexhtml = $this->homgepagehtml('mobile'); $msearchhtml = $this->sendData('mobile'); } $mobile_classify_ids = array(); $mobile_article_ids = array(); $mobile_show = Classify::where('cus_id', $this->cus_id)->where("id", $pushcid)->pluck("mobile_show"); if ($mobile_show) { $mobile_classify_ids[] = $pushcid; $mobile_article_ids = Articles::where('cus_id', $this->cus_id)->where('mobile_show', 1)->where("c_id", $pushcid)->lists('id'); } } else { $mindexhtml = $this->homgepagehtml('mobile'); $msearchhtml = $this->sendData('mobile'); $mobile_classify_ids = Classify::where('cus_id', $this->cus_id)->where('mobile_show', 1)->lists('id'); $mobile_article_ids = Articles::where('cus_id', $this->cus_id)->where('mobile_show', 1)->lists('id'); } } if ($this->pcpush) { if (isset($pushcid)) { if (!isset($end) || $end == 1) { $indexhtml = $this->homgepagehtml('pc'); $searchhtml = $this->sendData('pc'); } $pc_classify_ids = array(); $pc_article_ids = array(); $pc_show = Classify::where('cus_id', $this->cus_id)->where("id", $pushcid)->pluck("pc_show"); if ($pc_show) { $pc_classify_ids[] = $pushcid; $pc_article_ids = Articles::where('cus_id', $this->cus_id)->where('pc_show', 1)->where("c_id", $pushcid)->lists('id'); } } else { $indexhtml = $this->homgepagehtml('pc'); $searchhtml = $this->sendData('pc'); $pc_classify_ids = Classify::where('cus_id', $this->cus_id)->where('pc_show', 1)->lists('id'); $pc_article_ids = Articles::where('cus_id', $this->cus_id)->where('pc_show', 1)->lists('id'); } } $count = $this->htmlPagecount($pc_classify_ids, $mobile_classify_ids, $pc_article_ids, $mobile_article_ids); $this->html_precent = 70 / $count; if ($this->pcpush) { $categoryhtml = $this->categoryhtml($pc_classify_ids, 'pc'); $articlehtml = $this->articlehtml($pc_classify_ids, 'pc'); } if ($this->mobilepush) { $mcategoryhtml = $this->categoryhtml($mobile_classify_ids, 'mobile'); $marticlehtml = $this->articlehtml($mobile_classify_ids, 'mobile'); } $this->percent = 20 / $count; $path = public_path('customers/' . $this->customer . '/' . $this->customer . '.zip'); if (file_exists($path)) { @unlink($path); } $zip = new ZipArchive(); if ((!isset($end) || $end == 1) && $zip->open($path, ZipArchive::CREATE) === TRUE) { if ($this->pcpush) { $this->addFileToZip(public_path("quickbar/"), $zip, "quickbar"); $zip->addFile($indexhtml, 'index.html'); $zip->addFile($searchhtml, 'search.html'); $zip->addFile(public_path('customers/' . $this->customer . '/article_data.json'), 'article_data.json'); $nowpercent = $this->percent + $this->lastpercent; if (floor($nowpercent) != $this->lastpercent) { echo '<div class="prompt">' . floor($nowpercent) . '%</div><script type="text/javascript">refresh(' . floor($nowpercent) . ');</script>'; ob_flush(); flush(); $this->clearpushqueue(); } } $this->lastpercent += 70 + $this->percent; if ($this->mobilepush) { $this->addFileToZip(public_path("quickbar/"), $zip, "mobile/quickbar"); $zip->addFile($mindexhtml, 'mobile/index.html'); $zip->addFile($msearchhtml, 'mobile/search.html'); $zip->addFile(public_path('customers/' . $this->customer . '/mobile/article_data.json'), 'mobile/article_data.json'); $nowpercent = $this->percent + $this->lastpercent; if (floor($nowpercent) != floor($this->lastpercent)) { echo '<div class="prompt">' . floor($nowpercent) . '%</div><script type="text/javascript">refresh(' . floor($nowpercent) . ');</script>'; ob_flush(); flush(); $this->clearpushqueue(); } } $this->lastpercent += $this->percent; $zip->close(); } else { $this->lastpercent += 70 + $this->percent; } if ($this->pcpush) { $this->compareZip($categoryhtml, 'category', $path); $this->compareZip($articlehtml, 'detail', $path); } if ($this->mobilepush) { $this->compareZip($mcategoryhtml, 'mobile/category', $path); $this->compareZip($marticlehtml, 'mobile/detail', $path); } if (90 > floor($this->lastpercent)) { echo '<div class="prompt">' . '90%</div><script type="text/javascript">refresh(90);</script>'; ob_flush(); flush(); $this->clearpushqueue(); } PushQueue::where('cus_id', $this->cus_id)->delete(); $nextpush = PushQueue::where('push', 0)->first(); if ($nextpush) { PushQueue::where('id', $nextpush->id)->update(['push' => 1]); } if ($zip->open($path, ZipArchive::CREATE) === TRUE) { if ((!isset($end) || $end == 1) && $this->pcpush) { $pc_dir = Template::where('website_info.cus_id', $this->cus_id)->Leftjoin('website_info', 'website_info.pc_tpl_id', '=', 'template.id')->pluck('name'); $aim_dir = public_path("templates/{$pc_dir}/"); $this->addDir($aim_dir, $zip); } if ((!isset($end) || $end == 1) && $this->mobilepush) { $mobile_dir = Template::where('website_info.cus_id', $this->cus_id)->Leftjoin('website_info', 'template.id', '=', 'website_info.mobile_tpl_id')->pluck('name'); $maim_dir = public_path("templates/{$mobile_dir}/"); $this->addDir($maim_dir, $zip, 'mobile/'); } $zip->close(); $customerinfo = Customer::find($this->cus_id); $ftp_array = explode(':', $customerinfo->ftp_address); $port = $customerinfo->ftp_port; $ftpdir = $customerinfo->ftp_dir; $ftp = $customerinfo->ftp; $ftp_array[1] = isset($ftp_array[1]) ? $ftp_array[1] : $port; $conn = ftp_connect($ftp_array[0], $ftp_array[1]); $del_imgs = ImgDel::where('cus_id', $this->cus_id)->get()->toArray(); if (trim($ftp) == '1') { if ($conn) { ftp_login($conn, $customerinfo->ftp_user, $customerinfo->ftp_pwd); ftp_pasv($conn, 1); if (@ftp_chdir($conn, $this->customer) == FALSE) { ftp_mkdir($conn, $this->customer); } foreach ((array) $del_imgs as $v) { $this->delimg($v); @ftp_delete($conn, "/" . $this->customer . '/images/l/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, "/" . $this->customer . '/images/s/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, "/" . $this->customer . '/mobile/images/l/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, "/" . $this->customer . '/mobile/images/s/' . $v['target'] . '/' . $v['img']); } ImgDel::where('cus_id', $this->cus_id)->delete(); if ($this->pcpush) { @ftp_put($conn, "/" . $this->customer . "/search.php", public_path("packages/search.php"), FTP_ASCII); //@ftp_put($conn,"/".$this->customer."/quickbar.json",public_path('customers/'.$this->customer.'/quickbar.json'),FTP_ASCII); } if (file_exists($path)) { ftp_put($conn, "/" . $this->customer . "/site.zip", $path, FTP_BINARY); } ftp_put($conn, "/" . $this->customer . "/unzip.php", public_path("packages/unzip.php"), FTP_ASCII); if ($this->mobilepush) { ftp_put($conn, "/" . $this->customer . "/mobile/search.php", public_path("packages/search.php"), FTP_ASCII); if (@ftp_chdir($conn, "/" . $this->customer . "/mobile") == FALSE) { ftp_mkdir($conn, "/" . $this->customer . "/mobile"); } //ftp_put($conn,"/".$this->customer."/mobile/quickbar.json",public_path('customers/'.$this->customer.'/mobile/quickbar.json'),FTP_ASCII); } ftp_close($conn); } } else { if ($conn) { ftp_login($conn, $customerinfo->ftp_user, $customerinfo->ftp_pwd); ftp_pasv($conn, 1); foreach ((array) $del_imgs as $v) { $this->delimg($v); @ftp_delete($conn, $ftpdir . '/images/l/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, $ftpdir . '/images/s/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, $ftpdir . '/mobile/images/l/' . $v['target'] . '/' . $v['img']); @ftp_delete($conn, $ftpdir . '/mobile/images/s/' . $v['target'] . '/' . $v['img']); } ImgDel::where('cus_id', $this->cus_id)->delete(); if ($this->pcpush) { ftp_put($conn, $ftpdir . "/search.php", public_path("packages/search.php"), FTP_ASCII); //ftp_put($conn,$ftpdir."/quickbar.json",public_path('customers/'.$this->customer.'/quickbar.json'),FTP_ASCII); } ftp_put($conn, $ftpdir . "/unzip.php", public_path("packages/unzip.php"), FTP_ASCII); if (file_exists($path)) { ftp_put($conn, $ftpdir . "/site.zip", $path, FTP_BINARY); } if ($this->mobilepush) { ftp_put($conn, $ftpdir . "/mobile/search.php", public_path("packages/search.php"), FTP_ASCII); //ftp_put($conn,$ftpdir."/mobile/quickbar.json",public_path('customers/'.$this->customer.'/mobile/quickbar.json'),FTP_ASCII); } ftp_close($conn); } } $this->folderClear(); echo '<div class="prompt">' . '100%</div><script type="text/javascript">refresh(100);</script>'; if (!isset($end) || $end == 1) { Classify::where('cus_id', $this->cus_id)->where('pushed', '>', 0)->update(['pushed' => 0]); Articles::where('cus_id', $this->cus_id)->where('pushed', '>', 0)->update(['pushed' => 0]); WebsiteConfig::where('cus_id', $this->cus_id)->update(['pushed' => 0]); WebsiteInfo::where('cus_id', $this->cus_id)->update(['pushed' => 0]); MobileHomepage::where('cus_id', $this->cus_id)->update(['pushed' => 0]); CustomerInfo::where('cus_id', $this->cus_id)->update(['pushed' => 0, 'lastpushtime' => date('Y-m-d H:i:s', time())]); //date('Y-m-d H:i:s',time()) } /** * pc使用本服务器自带域名推送,后期需要改进! */ $weburl = Customer::where('id', $this->cus_id)->pluck('weburl'); $suf_url = str_replace('http://c', '', $weburl); $cus_name = strtolower(Customer::where('id', $this->cus_id)->pluck('name')); if (trim($ftp) == '1') { $ftp_pcdomain = "http://" . $cus_name . $suf_url; } else { $ftp_pcdomain = $customerinfo->pc_domain; } @file_get_contents("{$ftp_pcdomain}/unzip.php"); } else { echo '打包失败'; } ob_end_flush(); } else { echo '<div class="prompt">' . '100%</div><script type="text/javascript">refresh(100);</script>'; if (!isset($end) || $end == 1) { Classify::where('cus_id', $this->cus_id)->where('pushed', '>', 0)->update(['pushed' => 0]); Articles::where('cus_id', $this->cus_id)->where('pushed', '>', 0)->update(['pushed' => 0]); WebsiteConfig::where('cus_id', $this->cus_id)->update(['pushed' => 0]); WebsiteInfo::where('cus_id', $this->cus_id)->update(['pushed' => 0]); MobileHomepage::where('cus_id', $this->cus_id)->update(['pushed' => 0]); CustomerInfo::where('cus_id', $this->cus_id)->update(['pushed' => 0, 'lastpushtime' => date('Y-m-d H:i:s', time())]); //date('Y-m-d H:i:s',time()) ob_end_flush(); } } }
function postSave($id = 0) { $trackUri = $this->data['trackUri']; $rules = array(); $validator = Validator::make(Input::all(), $rules); if ($validator->passes()) { $data['post_note'] = Input::get('post_note'); $ID = Input::get('post_id'); $data_post = DB::table('post')->where('post_id', '=', $ID)->first(); if (Input::get('active') != '') { $data['status'] = '1'; $data['active'] = Input::get('active'); $this->cus = Customer::where('customer_id', '=', $data_post->customer_id)->first(); $link = URL::to('') . "/tin/" . $data_post->post_slug . '-' . $data_post->post_id . ".html"; $data_mail = array('link' => $link); Mail::send('emails.successpost', $data_mail, function ($message) { $message->from(CNF_EMAIL, 'Admin'); $message->to($this->cus->email, $this->cus->name)->subject('Xác nhận tin đã đăng'); }); } else { $data['status'] = Input::get('status'); } DB::table('post')->where('post_id', '=', $ID)->update($data); // Input logs if (Input::get('post_id') == '') { $this->inputLogs("New Entry row with ID : {$ID} , Has Been Save Successfull"); $id = SiteHelpers::encryptID($ID); } else { $this->inputLogs(" ID : {$ID} , Has Been Changed Successfull"); } // Redirect after save $md = str_replace(" ", "+", Input::get('md')); $redirect = !is_null(Input::get('apply')) ? 'post/add/' . $id . '?md=' . $md : 'post?md=' . $md . $trackUri; return Redirect::to($redirect)->with('message', SiteHelpers::alert('success', Lang::get('core.note_success'))); } else { return Redirect::to('post/add/' . $id)->with('message', SiteHelpers::alert('error', Lang::get('core.note_error')))->withErrors($validator)->withInput(); } }
Route::get('customer/legal_agreements', function () { return View::make('frontoffice.legal_agreements'); }); Route::post('customer/suscription', 'CustomerController@suscribe'); Route::post('customer/recommend', 'CustomerController@recommend'); Route::get('customer/voucher/{voucher}', function (Voucher $voucher) { return View::make('frontoffice.voucher')->with('voucher', $voucher); }); Route::get('customer/unsubscribe', function () { return View::make('frontoffice.unsubscribe'); }); Route::post('customer/unsubscribe', function () { $rules = array('email' => 'required|email'); $validator = Validator::make(Input::all(), $rules); if (!$validator->fails()) { $customer = Customer::where('email', '=', Input::get('email'))->first(); if ($customer) { $customer->delete(); Mail::send('emails.auth.unsubscribe', array('email' => Input::get('email')), function ($message) { $message->to(Input::get('email'), 'Invitado')->subject('Confirmación de baja.'); }); return Redirect::to('customer/vouchers')->with('success', 'Proceso finalizado con éxito!'); } else { return Redirect::back()->with('error', 'Este usuario ya no consta dado de alta.'); } } else { return Redirect::back()->with('error', 'Email erróneo'); } }); Route::get('customer/confirmation', function () { return View::make('frontoffice.confirmation');
/** * 获取用户信息 */ public function getSwitchCustomer() { $cus_id = Auth::id(); $switch_cus_id = Customer::where('id', $cus_id)->pluck('switch_cus_id'); if (empty($switch_cus_id)) { return null; } $current_cus_info = Customer::where('id', $cus_id)->first(); $switch_cus_info = Customer::where('id', $switch_cus_id)->first(); $data['switch_pc_domain'] = $switch_cus_info->pc_domain; $data['switch_mobile_domain'] = $switch_cus_info->mobile_domain; $data['current_pc_domain'] = $current_cus_info->pc_domain; $data['current_mobile_domain'] = $current_cus_info->mobile_domain; return $data; }
public function index() { $widget = ['baru' => Penjualan::where('status', 1)->whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'poBaru' => Penjualan::whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'rls' => Penjualan::where('status', '!=', 1)->whereBetween('tgl_order', [Carbon::now()->startOfMonth(), Carbon::today()])->count(), 'orders' => Order::where('status', 1)->count(), 'agen' => Customer::where('tipe', 2)->orWhere('tipe', 3)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'mitra' => Customer::where('tipe', 1)->orWhere('tipe', 6)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'biasa' => Customer::where('tipe', 4)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year)->count(), 'agenLastYear' => Customer::where('tipe', 2)->orWhere('tipe', 3)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count(), 'mitraLastYear' => Customer::where('tipe', 1)->orWhere('tipe', 6)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count(), 'biasaLastYear' => Customer::where('tipe', 4)->where(DB::raw('YEAR(created_at)'), Carbon::now()->year - 1)->count()]; $box = ['penjualans' => Penjualan::orderBy('tgl_order', 'DESC')->take(7)->get(), 'barangs' => Barang::orderBy('id', 'DESC')->take(4)->get(), 'customers' => Penjualan::with('customer')->orderBy('tgl_order', 'DESC')->take(8)->get(), 'followups' => Followup::orderBy('created_at', 'desc')->take(6)->get(), 'bahan' => DB::table('bahan')->where('stok', 0)->take(5)->get(), 'menipis' => DB::table('bahan')->where('stok', 0)->count()]; // CHART ========================================================================================= $laporanTahunan = Penjualan::select(DB::raw('MONTH(tgl_transfer) as month, count(`id`) as count, sum(`nominal`) as nominal'))->where('status', '!=', 1)->where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year)->groupBy(DB::raw('YEAR(tgl_transfer)'))->groupBy(DB::raw('MONTH(tgl_transfer)'))->orderBy('tgl_transfer', 'asc')->get(); $total = ['thisMonth' => Penjualan::where('status', '!=', 1)->where('tgl_transfer', '>=', Carbon::now()->startOfMonth())->sum('nominal'), 'thisMonthLastYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year - 1)->where(DB::raw('MONTH(tgl_transfer)'), Carbon::now()->month)->where('status', '!=', 1)->sum('nominal'), 'lastYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year - 1)->where('status', '!=', 1)->sum('nominal'), 'thisYear' => Penjualan::where(DB::raw('YEAR(tgl_transfer)'), Carbon::now()->year)->where('status', '!=', 1)->sum('nominal')]; // END OF CHART ========================================================================================= // dd($total['thisMonth']); return View::make('admin', compact('box', 'widget', 'total', 'laporanTahunan')); }
public function clientBookingStep3() { /* foreach(Session::get('reservation')['reservation_room'] as $rooms) { $room_id = $rooms['room_details']['id']; $available_rooms = []; $room_qty = RoomQty::with(array('roomPrice','roomReserved'=>function($query) use($i, $room_id){ $query->where(function($query2) use ($i, $room_id){ $query2->whereBetween('check_in', array($i['checkin'], $i['checkout'])) ->orWhereBetween('check_out', array($i['checkin'], $i['checkout'])) ->orWhereRaw('"'.$i["checkin"].'" between check_in and check_out') ->orWhereRaw('"'.$i["checkout"].'" between check_in and check_out'); })->where(function($query3) { $query3->where('status', '!=', 5)->orWhere('status', '!=', 3); }); }))->where('room_id', $room_id)->where('status',1)->get(); foreach($room_qty as $available) { if($available->roomReserved== '[]' || count($available->roomReserved) == 0) { array_push($available_rooms, $available); } } if(count($available_rooms) < $rooms['quantity']) { return Redirect::to('booking/step2')->with('error', 'Some rooms you booked is not available'); } } */ $i = Input::all(); if (isset($i['membership_id'])) { $membership = Customer::where('membership_id', $i['membership_id'])->first(); if ($membership) { Session::forget('reservation.customerdiscount'); //unset(Session::get('reservation.customerdiscount')); Session::put('reservation.customerdiscount', $membership->current_discount); } } Session::forget('reservation.customerinformation'); Session::put('reservation.customerinformation', $i); //return Session::get('reservation.customerinformation')['firstname']; return Redirect::to('booking/step4'); }
public function welcome() { $customers = Customer::where('home_page', '=', 1)->get(); $about_us = AboutUs::orderBy('id', 'desc')->first(); return View::make('jobs.index')->with(['customers' => $customers, 'about_us' => $about_us]); }
public function deleteCustomer() { $company = Input::get('company'); $customerDelete = Customer::where('company_name', '=', $company)->first(); $ID = $customerDelete->c_id; $customer = Customer::find($ID); $deleted = $customer->delete(); if ($deleted) { return Redirect::route('dashboard'); } else { return Redirect::route('viewCustomers'); } }
public function isDuplicateCustomer($email) { $customer = Customer::where('email', '=', $email)->first(); return is_null($customer) ? "no" : "yes"; }
public function export($id) { Excel::create('Customer', function ($excel) use($id) { $excel->sheet('Customer', function ($sheet) use($id) { $customers = Customer::where('tipe', $id)->get(); $sheet->loadView('admin.customers.csv', ['customers' => $customers, 'id' => $id]); }); })->export('xlsx'); }
public function getCustomerID($info) { if (strlen($info) > 5) { $explode = explode('|', $info); $token = extract_char($explode[1], array('int')); return Customer::where('token', '=', $token)->pluck('id'); } else { return 0; } }
public function post_sign_in() { $data = array(); $data['success'] = ''; $email = \Laravel\Input::get('email'); $postcode = strtolower(str_replace(' ', '', \Laravel\Input::get('postcode'))); // Ensure upper case and spaces removed for better compatability $customer = Customer::where('email', '=', $email)->where('postcode', '=', $postcode)->first(); if (!$customer) { $data['error'] = 'Unable to locate an account matching these details!'; } else { \Laravel\Session::put('quote_account_id', $customer->id); return Redirect::to_action('quotations/my_quotes'); } return View::make('quotations.sign_in')->with('data', $data); }
/** * * @return array */ function autocomplete() { $_term = Input::get('term'); $_aux = Input::get('aux'); $_aux = json_decode($_aux, true); $response = array(); $response = Customer::where('name', 'LIKE', "%{$_term}%")->orWhere('cpf', 'LIKE', "%{$_term}%")->get(); return $response; }