/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$user = new User();
$user->name = 'mugekural';
$user->surname = str_random(10);
$user->email = $user->name . '@gmail.com';
$user->is_active = true;
$user->password = bcrypt('12345');
$user->type = 'App\\Supplier';
$user->save();
$supplier = new Supplier();
$supplier->phone = '023123';
$supplier->id = $user->id;
$supplier->save();
$user2 = new User();
$user2->name = str_random(10);
$user2->surname = str_random(10);
$user2->email = $user2->name . '@gmail.com';
$user2->is_active = true;
$user2->type = 'App\\Customer';
$user2->save();
$customer = new Customer();
$customer->phone = "053247557437";
$customer->id = $user2->id;
$customer->save();
$instagram = new InstagramAccount();
$instagram->instagram_id = "1231231";
$instagram->access_token = "asdaddads";
$instagram->username = "******";
$instagram->full_name = "omer faruk";
$instagram->bio = "fdsfasfdsf";
$instagram->website = "string";
$instagram->profile_picture = "";
$supplier->instagramAccount()->save($instagram);
$product = new Product();
$product->supplier_id = $supplier->id;
$product->id = "235";
$product->is_active = true;
$product->title = "kitap";
$product->description = "martı";
$product->price = "340";
$product->save();
$instagram2 = new InstagramAccount();
$instagram2->instagram_id = "700797";
$instagram2->access_token = "fjfjjfjfjf";
$instagram2->username = "******";
$instagram2->full_name = "muge kural";
$instagram2->bio = "comp stud";
$instagram2->website = "some string";
$instagram2->profile_picture = "";
$customer->instagramAccount()->save($instagram2);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$suppliers = Supplier::orderBy('name')->get();
$employees = Employee::orderBy('firstname')->get();
$customers = Customer::orderBy('name')->get();
return view('inventory.home', compact(['suppliers', 'employees', 'customers']));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$suppliers = ['KEMSA', 'MEDS', 'Others'];
foreach ($suppliers as $supplier) {
\App\Supplier::create(['name' => $supplier]);
}
}
public function update($id, Request $request)
{
$validator = Validator::make($request->all(), ['first_name' => 'required', 'last_name' => 'required']);
if ($validator->fails()) {
$messages = $validator->messages();
return Redirect::back()->withErrors($validator)->withInput();
} else {
$supplier = Supplier::find($id);
$supplier->fill($request->except('_token'));
$supplier->parent_id = Session::get('SUPPLIER_ACCESS_ID');
if ($request->password != '') {
$supplier->password = Hash::make($request->password);
}
if (Input::hasFile('profileimage')) {
$file = Input::file('profileimage');
$imagename = time() . '.' . $file->getClientOriginalExtension();
if (\File::exists(public_path('upload/supplierprofile/' . $supplier->image))) {
\File::delete(public_path('upload/supplierprofile/' . $supplier->image));
}
$path = public_path('upload/supplierprofile/' . $imagename);
$image = \Image::make($file->getRealPath())->save($path);
$th_path = public_path('upload/supplierprofile/thumb/' . $imagename);
$image = \Image::make($file->getRealPath())->resize(128, 128)->save($th_path);
$supplier->image = $imagename;
}
$supplier->save();
return Redirect::route('supplier_list')->with('succ_msg', 'Supplier has been created successfully!');
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$instagram = new InstagramAPI();
foreach (\App\Supplier::all() as $supplier) {
$instagram->setAccessToken($supplier->instagramAccount->access_token);
foreach ($supplier->products()->where('is_active', true)->get() as $product) {
$comments = $instagram->getMediaComments($product->instagram->id);
if ($comments->meta->code == 200) {
$lastScannedComment = null;
for ($i = count($comments->data) - 1; $i >= 0; $i--) {
$comment = $comments->data[$i];
if ($lastScannedComment == null) {
$lastScannedComment = $comment->id;
}
if ($product->instagram->last_scanned_comment >= $comment->id) {
break;
}
if (strpos(mb_strtolower($comment->text, 'UTF-8'), 'sepete at') !== false) {
if ($customer = \App\InstagramAccount::where('instagram_id', $comment->from->id)->first()) {
if ($customer->isCustomer()) {
$customer = $customer->instagramable;
\App\WishedProduct::create(['customer_id' => $customer->id, 'product_id' => $product->id, 'count' => 1]);
}
}
}
}
if ($lastScannedComment != null) {
$productInstagram = $product->instagram;
$productInstagram->last_scanned_comment = $lastScannedComment;
$productInstagram->update();
}
}
}
}
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(CookieJar $cookieJar, Request $request)
{
if ($request->isMethod('post')) {
$supplier_email = $request->get('supplier_email');
$supplier_password = $request->get('supplier_password');
$checkAgentExists = Supplier::where("email", "=", $supplier_email);
$checkAgentExists = $checkAgentExists->where("password", "=", md5($supplier_password . Config::get('constants.SITENAME')));
$checkAgentExists = $checkAgentExists->get();
if ($request->get('remember_login')) {
$cookieJar->queue(Cookie::make('supplier_email', $supplier_email, 60));
$cookieJar->queue(Cookie::make('supplier_password', $supplier_password, 60));
} else {
$cookieJar->queue(Cookie::forget('supplier_email'));
$cookieJar->queue(Cookie::forget('supplier_password'));
}
if (count($checkAgentExists) > 0) {
Session::put('SUPPLIER_ACCESS_ID', $checkAgentExists[0]->id);
Session::put('SUPPLIER_ACCESS_FNAME', $checkAgentExists[0]->first_name);
Session::put('SUPPLIER_ACCESS_LNAME', $checkAgentExists[0]->last_name);
return redirect('supplier/dashboard');
} else {
return Redirect::route('supplier_land')->with('message', ['Invalid email address or/and password.']);
}
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Requests\SupplierRequest $request)
{
//
$data = $request->except(['_token']);
Supplier::create($data);
return redirect()->to('supplier');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$suppliers = Supplier::all();
$ingredients = Ingredient::all();
$supplyorder = Supplyorder::find($id);
return view('supplyorder.show', ['supplyorder' => $supplyorder, 'ingredients' => $ingredients, 'suppliers' => $suppliers]);
}
public function edit($id, $page = 0)
{
$product = Product::find($id);
if ($page != 0) {
$supplier = Supplier::find($page);
}
return view('products.edit', compact('product', 'supplier'));
}
/**
* Returns a paginated supplier index.
*
* @param string $q
* @return Paginator
*/
public function query($q)
{
return Supplier::where(function ($query) use($q) {
if ($q) {
$query->where('name', 'like', "%{$q}%");
}
})->orderBy('name')->paginate();
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$order = Order::findOrFail($id);
$order_details = DB::table('order_details')->where('order_id', '=', $id)->get();
$supplier = Supplier::where('id', '=', $order->supplier_id)->firstOrFail();
$created_at = $order->created_at->format('Y M d');
return view('orders.single-order', compact('order', 'order_details', 'supplier', 'created_at'));
}
public function edit($id)
{
$price_log = PriceLog::find($id);
$supplierOptions = Supplier::lists('name', 'id');
$itemOptions = Item::lists('name', 'id');
$availability = ['1' => 'Yes', '0' => 'No'];
$date = $price_log->date;
return view('price_logs.edit', compact('date', 'availability', 'price_log', 'supplierOptions', 'itemOptions'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
if (Session::has('user_instagram_info')) {
$rules = array('firstname' => 'required', 'surname' => 'required', 'shopname' => 'required', 'shopemail' => 'required|email', 'pass' => 'required', 'repass' => 'required|same:pass');
// do the validation ----------------------------------
// validate against the inputs from our form
$validator = Validator::make($request->all(), $rules);
// check if the validator failed -----------------------
if ($validator->fails()) {
// get the error messages from the validator
$messages = $validator->messages();
// redirect our user back to the form with the errors from the validator
return back()->withInput()->withErrors($messages);
} else {
$instagramInfo = Session::pull('user_instagram_info');
$user = new User();
$user->name = $request->input('firstname');
$user->surname = $request->input('surname');
$user->setAsSupplier();
$user->is_active = false;
$user->email = $request->input('shopemail');
$user->password = bcrypt($request->input('pass'));
$user->save();
$supplier = new Supplier();
$supplier->id = $user->id;
$supplier->shop_name = $request->input('shopname');
$supplier->profile_image = $instagramInfo->user->profile_picture;
$supplier->save();
$instagramAccount = new InstagramAccount();
$instagramAccount->instagram_id = $instagramInfo->user->id;
$instagramAccount->username = $instagramInfo->user->username;
$instagramAccount->access_token = $instagramInfo->access_token;
$instagramAccount->full_name = $instagramInfo->user->full_name;
$instagramAccount->bio = $instagramInfo->user->bio;
$instagramAccount->website = $instagramInfo->user->website;
$instagramAccount->profile_picture = $instagramInfo->user->profile_picture;
$supplier->instagramAccount()->save($instagramAccount);
Storage::makeDirectory($user->id);
return redirect()->action('AuthenticationController@showRegister')->with('success', ['Successful']);
}
} else {
return redirect()->action('AuthenticationController@showRegister');
}
}
public function suppliers()
{
$term = \Input::get('term');
$suppliers = Supplier::where('supplier_name', 'like', "%{$term}%")->orderBy('supplier_name', 'asc')->get();
$json = [];
foreach ($suppliers as $s) {
array_push($json, array('value' => $s->id, 'label' => $s->supplier_name));
}
return response()->json($json);
}
/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function index()
{
$items = Item::where('type', 1)->count();
$item_kits = Item::where('type', 2)->count();
$customers = Customer::count();
$suppliers = Supplier::count();
$receivings = Receiving::count();
$sales = Sale::count();
$employees = User::count();
return view('home')->with('items', $items)->with('item_kits', $item_kits)->with('customers', $customers)->with('suppliers', $suppliers)->with('receivings', $receivings)->with('sales', $sales)->with('employees', $employees);
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
// $id = $this->po->max('id');
// $id = $id === null ? 1 : $id + 1;
$supplier = Supplier::get(['id', 'nama'])->toArray();
// $pr = $this->pr->get(['id'])->toArray();
// $terms = SyaratPembayaran::all()->toArray();
$pajak = Pajak::all()->toArray();
// $akun = Akun::all()->toArray();
return view('pembelian.pt.create', compact('supplier', 'pajak'));
}
public function update($id)
{
// save updated
$record = $this->records->find($id);
if (!$record) {
Supplier::create(Input::all());
return $this->respond($record);
}
$record->fill(Input::all())->save();
return $this->respond($record);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$search = \Request::get('search');
//<-- we use global request to get the param of URI
if ($search) {
$allSuppliers = Supplier::whereRaw('supplier_name = ?', [$search])->orderBy('id', 'desc')->paginate(5);
} else {
$allSuppliers = Supplier::orderBy('id', 'desc')->paginate(5);
}
return view('supplierBranch.index', ['suppliers' => $allSuppliers]);
}
public function shopDetail(Request $request, $id)
{
if ($supplier = Supplier::where('id', $id)->first()) {
$paginateNumber = 10;
$products = $supplier->products();
$paginator = $products->orderBy('created_at', 'desc')->paginate($paginateNumber);
$paginator->appends($request->except('page'));
$recentlyAddedProducts = $products->orderBy('created_at', 'desc')->limit(3)->get();
return view('user.shop', ['supplier' => $supplier, 'paginator' => $paginator, 'recentlyAddedProducts' => $recentlyAddedProducts]);
} else {
return redirect()->action('Frontend\\HomeController@index');
}
}
public function run()
{
//User::truncate();
DB::Table('suppliers')->delete();
//Supplier::create(['supplier_name' => '1010 Printing Australia']);
//Supplier::create(['supplier_name' => 'Abel Labels']);
foreach (explode("\n", "1010 PRINTING AUSTRALIA\n3L ELECTRONICS CO (SHEN ZHEN)\n7 DAYS PRINT\nABEL LABELS\nACE GRAPHICS & PRINT PTY LTD\nAD-MAG FRIDGE MAGNETS\nADHESIVE MAGNETIC SUPPLIES PTY LTD\nAGILITY LOGISTICS\nALLKOTES (VIC) PTY LTD\nANHUI PROVINCE TAIHU ZEHONG PLASTIC CO LTD\nANHUI TECHNOLOGY IMP & EXP CO LTD\nAO XIANG GREEN SHOPPING BAG\nART AND SOUL\nASIA PACIFIC OFFSET\nAUS ELECTRICAL SERVICES\nAWM ELECTRICAL\nB&H KING MOLD LIMITED\nBADGER MAKES BADGES PTY LTD\nBANNER CITY PTY LTD\nBASS STRAIT TRANSPORT\nBEE PRINTING CO LTD\nBETTER FINISH CO LTD\nBILTON GRAPHICS PTY LTD\nBIRK AND BLYME PTY LTD\nBLD SUPERIOR BAG CO LTD\nBOLG\nBRAYMAN GRAPHIC ENGINEERS PTY LTD\nBURELA INSTRUMENTATION PTY LTD\nC AND C OFFSET PRINTING CO LTD AUSTRALIA\nCANGNAN WELL BAGS CO LTD\nCARDPRO AUSTRALIA\nCARR GROUP\nCENTRUM PRINTING\nCHAINZONE TECHNOLOGY (FOSHAN) CO LTD\nCHANGCHUN TONG HUI TRADING CO LTD\nCHANGZHOU HUAPU CORK PRODUCTS CO LTD\nCHANGZHOU K K LIGHTING ELECTRIC CO LTD\nCHANGZHOU QUALITY FLAG INDUSTRY CO LTD\nCHAOZHOU SUKE PATE SANITARY WARE CO LTD\nCHECKEY/KOTOO LEATHER GOODS\nCHENGHAI MK TOYS CO LTD\nCHEQUEMATES\nCHER LEE LONG PACKING INDUSTRY CO LTD\nCHINA ELETA TECHNICAL CO LTD\nCHINA GOLD PRINTING GROUP LIMITED\nCHINESE-PRINTING CO LTD\nCHOICE DEVELOPMENT INC\nCHROMAPRINT INDIA PRIVATE LTD\nCITY SHELVING & STORAGE SYSTEMS\nCIXI CITY SMALL SAILBOAT STATIONERY CO LTD\nCIXI WEIER PLASTIC CO LTD\nCLEVER TRADE PRODUCTS\nCMYK HUB\nCOMPUFIX TAS\nCOMPUFIX TAS\nCONTEXT STATIONERY CO LTD\nCOPE SENSITIVE FREIGHT\nCORPORATE EXPRESS\nCOURTNEY\nCTI COLOUR PRINTERS\nCUSTOME-USB INTERNATIONAL CO LTD\nD & W INDUSTRY (ASIA) LIMITED\nDARK HORSE PRINT DESIGN\nDASTEK CORPORATOPN LIMITED\nDATAFLOW BUSINESS SYSTEMS\nDEBBIE JOSEPH\nDEEJAY SIGNS\nDHL EXPRESS\nDIGI LABELS\nDISK BANK\nDISK BANK\nDISPLAY POWER\nDOCKETS AND FORMS PTY LTD\nDONG QIAN LAKE INDUSTRIAL CO LTD\nDONG YANG JIRONG PLASTIC INDUSTRIAL CO LTD\nDONGGUAN CITY JINGLI CAN CO LTD\nDONGGUAN KLT & CASINE ELECTRONIC TERCHNOLOGY \nDONGGUAN SHUNTONG COLOR PRINTING CO LTD\nDREAMTIME STOCK IMAGES\nDUO TRADING\nE-PROMO CO LTD\nE-STAMPS\nEK INTERNATIONAL DEVELOPMENT CO LTD\nELECTRON KINGDOM CO LTD \nELITE MOLD (SHENZHEN) CO LTD\nENVOPRINT\nEURO SIGNS\nEVERBEST PRINTING CO LTD\nFC PRODUCTIONS\nFENG HUA SHUNFA ARTS & CRAFTS CO LTD\nFENG YUAN STATIONERY\nFENGHUA TECHNOLOGY DEVELOPMENT CO LTD\nFENGLOU PACKAGING & COLOUR PRINTING CO LTD\nFIRST PACK\nFLUIDLINE PTY LTD\nFLYING COLOURS\nFOILMASTERS\nFOOT & PLAYSTED\nFOXCIL\nFOYER PRINTING\nFRANKLIN DIRECT\nFRIDGE MAGNET FACTORY\nFUZHOU GREEN TRADING CO LTD\nG BOOK WRITING MATERIALS\nGARETH HOWARD\nGLJ LEDGER BAG MAKING FACTORY\nGLOBAL MARKET GROUP (ASIA) LTD\nGOLDBERRYBRONZE PTY LTD\nGOOD FLAG BIOTECHNOLOGY CORPORATION\nGRAPHFIX SOLUTIONS\nGRAPHIX LABELS PTY LTD\nGREENLAND MANUFACTURING & TRADING CO LTD\nGTL LIGHTING TECHNOLOGY LTD\nGUANG LI PAPER PDTS LTD\nGUANG ZHOU SUNSHINE ELECTRONIC TECHNOLOGY CO \nGUANGDONG BAOKE STATIONERY CO LTD\nGUANGDONG CLIPLEY ELECTRICAL INDUSTRIAL CO LT\nGUANGDONG TENGEN PRINTING CO LTD\nGUANGZHOU ANHORN INDUSTRIAL DEV CO LTD\nGUANGZHOU HOTIME PRINTING CO LTD\nGUANGZHOU HUIDUO ADVERTISING CO LTD\nGUANGZHOU KINGSONS LEATHER PRODUCTS CO LTD\nGUANGZHOU LETIAN PEN CO LTD\nGUANGZHOU LEVON SURPLUS PHOTOELECTRIC CO LTD\nGUANGZHOU LICAI ADVERTISEMENT PRODUCTS\nGUANGZHOU YANGLING ELECTRONIC SCIENCE & TECHN\nGUANGZHOU YINGMEI CRAFTS CO LTD\nGUANGZHOU YX PACKAGING PRODUCTS INDUSTRY CO L\nGUANGZHOU YXIANG PRINTING CO LTD\nGUMMING & VARNISHING SERVICES PTY LTD\nGUZHEN BAISHENG STATIONERY CO LTD\nH&C PRINTING CENTER LTD\nHANGZHOU TIGER ELECTRON & ELECTRIC CO LTD\nHAOYUAN ELECTRICAL LIGHTING FACTORY\nHEBEI LIGHT INDUSTRIAL PRODUCTS IMP & EXP GRO\nHEFEI HENGXIN ENVIRONMENTAL SCIENCE & TECH CO\nHEI LONG JIANG CHANNEL INTERNATIONAL TRADE CO\nHEIDELBERG GRAPHIC EQUIPMENT PTY LTD\nHENAN JIAOZUO FOREIGN TRADE CORP\nHENAN LIGHT IND PRODUCTS IMPORT & EXPORT CO L\nHENAN PREMTEC ENTERPRISE CORPORATION\nHENRY NISSICK\nHERBEN NUMBERING SYSTEMS\nHEROPRINT\nHIGHGATE GROUP\nHIPPO BIN\nHOBART HARDCHROME PTY LTD\nHOMI LIGHTING CO LTD\nHONG KONG DIANYI INDUSTRIAL CO LTD\nHONG KONG JNHE PAPER CO LTD\nHONG KONG TOTAL INDUSTRY\nHONGRUNDA (RUIAN) PHOTO ELECTRIC CO LTD\nHUAYI LIGHTING COMPANY LIMITED\nHUBEI PROVINCIAL LIGHT INDUSTRIAL PRODUCTS IM\nHUNAN DERUO TRADE CO LTD\nHUNAN FAMOUS TRADING CO LTD\nHYGRADE CUTTING FORMES\nI-LOVEPRINT CO LTD\nIBS CARDS\nINTUIT TECHNOLOGIES\nISO PRINTING\nISTOCKPHOTO\nJ L LENNARD PTY LTD\nJCS DIGITAL SOLUTION\nJIANGSU HIGH HOPE INTERNATIONAL GROUP\nJIANGSU SANTU GROUP CO LTD\nJIANGSU SHENGHUI LIGHTING & ELECTRONICS CO LT\nJIANGXI HUACAI PRINTING CO LTD\nJIANGXI LIANCHUANG OPTO-ELECTRONIC SCIENCE & \nJILIN PROVINCE BLUE AND GREEN WINE CO LTD\nJINYI PAPER PRODUCTS & PRINTING CO LTD\nJIUN YO CO LTD\nJIXIANG DECORATING & CRAFTS FACTORY CO LTD\nJOHN HOLTZCLAW\nJUIZHOU GREEBLE \nK W DOGGETT FINE PAPER\nKALAMAZOO\nKANPRINT\nKEEUP PROMOTIONAL LTD\nKING HOW LIMITED\nKING PRINT\nKING YUAN FU PACKING CO LTD\nKWALITY PRINTING & STATIONERY\nKWIK KOPY\nL T PROMOTION TOY CO LTD\nLABEL LINE PTY LTD\nLABEL NAMES\nLABEL POWER\nLABELPRESS PTY LTD\nLAMSON PARAGON\nLEP COLOUR PRINTERS\nLEVON SURPLUS (PEIYING) OPTOELECTRONIC CO LTD\nLIAONING BAOLIN GROUP ENERGY -SAVING TECH CO \nLITHOTECH INTERNATIONAL\nLIZ SMEEKS CONSULTING\nLOGO CARPET\nLOGOSON ARTS & CRAFTS CO LTD\nLONGPACK CO LTD\nLOUFOR STATIONERY MANUFACTURING CO LTD\nLP PHOTOGRAPHY\nLUMEN LED CO LIMITED\nLUMIX LIGHTING & ELECTRICAL CO LTD\nM & M BINDERS PTY LTD \nM2 STUDIO\nMAC PLUS MORE \nMAC SOLUTIONS\nMADE-IN-CHINA\nMAGNET EXPRESS\nMAGNETS.COM.AU\nMAILHOUSE TAS DISTRIBUTION SERVICES\nMAN FERROSTAAL PTY LTD\nMARK MEDIA\nMARSDEN BROTHERS\nMCPHERSON BOOKBINDERS\nMCPHERSONS PRINTING GROUP\nMENG HUAN PLUSH TOYS\nMERCURY WALCH PTY LTD\nMIDAS PRINTING INTERNATIONAL LTD\nMOIRS PAPER\nMONOTONE ART PRINTERS\nMORNING PRINT\nMULLER MARTINI AUSTRALIA PTY LTD\nMY STICKER FACTORY\nNEW STAR CRAFTS CO LTD\nNINGBO BIN BIN STATIONERY CO LTD\nNINGBO FINELIFE PRODUCTS CO LTD\nNINGBO GELANTE ELECTRIC CO LTD\nNINGBO HIKING ENTERPRISE CO LTD\nNINGBO KAIXIANG ELECTRICAL APPLIANCE CO LTD\nNINGBO LUCKY CRAFT CO LTD\nNINGBO SHINSKY ELECTRICAL APPLIANCE CO LTD\nNINGBO TOPCOM LIGHTING CO LTD\nNINGBO YAMAO LIGHTING ELECTRIC APPLIANCE CO L\nNINGBO YONGTAI METAL PRODUCTS CO LTD\nNINGHAI HUIHUI STATIONERY CO LTD\nNINGHAI ZELYNN STATIONERY CO LTD\nOFFICE NATIONAL\nOFFICE WORKS\nONSITE BELTING\nPAC HOLDINGS PTY LTD\nPACK QUEEN\nPACKAGING PLUS\nPAPER ROLLS AUSTRALIA PTY LTD\nPAPERLINX OFFICE\nPENDA INTERNATIONAL TRADING CO LTD\nPLASTIC PASSPORT\nPLATYPUS GRAPHICS\nPML PRINT\nPNS GRAPHICS AUSTRALIA PTY LTD\nPOWERBEAUTY (DONGGUAN) INDUSTRIAL CO LTD\nPRESTIGE BOOKBINDERS\nPRESTIGE COURIERS\nPRINT BOUND\nPRINTERS CHOICE PTY LTD\nPRINTING AUTHORITY\nPRIORITY CARGO AUST PTY LTD\nPROMOTION PRODUCTS\nQINGDAO HUALONG PACKING CO LTD\nQPS ELECTRONICS CO LTD\nQUALITY BINDERS\nQUANZHOU QUANKANG CRAFT CO LTD\nRAYSON GLOBAL CO LTD\nREADY STEADY PRINT\nRED & BLUE COLOR PRINTING CO LTD\nRENOMA PRINTERY\nRMV (QUANZHOU) INTERNATIONAL TRADING CO LTD\nROASTAR\nROLLMAKERS PTY LTD\nS W GRAPHICS\nSAILING INTERNATIONAL LIMITED\nSALMAT LETTERBOX DROP SERVICES\nSANMAR INDUSTRIAL SUPPLIES\nSCORPION PRECISION INDUSTRY (HK) CO LTD\nSCREENSPRINT\nSEAGA (VIC) PTY LTD\nSHANGHAI BAGIFT ARTWARE CO LTD\nSHANGHAI DAHUA STATIONERY & SPORTING GOODS FA\nSHANGHAI DENGQING IMP & EXP CO LTD\nSHANGHAI FOREST PACKING CO LTD\nSHANGHAI GOODWIEW ELECTRONIC CO LTD\nSHANGHAI HONGTUO ECO-TECHNOLOGY CO LTD\nSHANGHAI SUNKEA PAPER CUP CO LTD\nSHANTOU BO CHUAN MACHINERY CO LTD\nSHANTOU CHENGHAI HUAJUN AERMODELLING & PLASTI\nSHANTOU WEIZIN INDUSTRIAL CO LTD\nSHANTOU XITONG STATIONERY INDUSTRY CO LTD\nSHEA PLASTICS\nSHENZHEN ANDASHENG BAG MANUFACTURING CO LTD\nSHENZHEN AOJIN HANDBAG CO LTD\nSHENZHEN CHUANGXINJIA RFID TAG CO LTD\nSHENZHEN FLEXWILL CO LTD\nSHENZHEN FONACA TECH\nSHENZHEN GUTON TECHNOLOGY CO LTD\nSHENZHEN LANCER ELECTRONIC CO LTD\nSHENZHEN NEW JIN KE CYBER DEVELOPING CO LTD\nSHENZHEN SANFENG PLASTIC PACKING CO LTDSANFEN\nSHENZHEN SCOPE SCIENTIFIC DEVELOPMENT CO LTD\nSHENZHEN SEMILUX LIGHTING TECHNOLOGY CO LTD\nSHENZHEN SHINEWAY LTD\nSHENZHEN SUNLANRFID TECHNOLOGY CO LTD\nSHENZHEN SUNLIGHT ELECTRONIC TECHNOLOGY CO LT\nSHENZHEN SUPERTAI TECHNOLOGY CO LTD\nSHENZHEN TOP TECHNOLOGY CO LTD\nSHENZHEN WANIDA TECHNOLOGY CO LTD\nSHENZHEN XINGZHIYE PRINTING & PACKING CO LTD\nSHENZHEN ZHONGHENGHUA TECHNOLOGY CO LTD \nSHUNKI TECHNOLOGY CO LTD\nSIGNWORKS\nSINO PATH ENTERPRISES LIMITED\nSLIMLINE WAREHOUSE\nSMARTEE\nSOCIAL PRINTING PTY LTD\nSOUTHERN SAW SERVICE\nSPEEDY\nSPICERS HOBART\nST VINCENT DE PAUL\nSTANDOUT MATS PTY LTD\nSTAR TRACK\nSTICKER COMPANY\nSTRAPMARK PTY LTD\nSTS SANTUCCI TAILORED SERVICES PTY LTD.\nSTUART AGAR EQUIPMENT SERVICES\nSTYGIAN STUDIO\nSUN-FLY\nSUNLIGHT ELECTRONIC TECHNOLOGY CO LTD\nSUNNY & SANDY CRAFTS CO LTD\nSUNNY YOUNG ENTERPRISE CO LTD\nTADPAC PRINT\nTAGS & TICKETS\nTAI ZHOU GODDESS PLAYING CARDS CO LTD\nTAIZHOU IDEAPAD STATIONERY CO LTD\nTASMANIAN FREIGHT SERVICES PTY LTD\nTENDER INTERNATIONAL CO LTD\nTENG FEI INTERNATIONAL DEVELOPMENT LTD\nTEST SUPPLIER\nTEST SUPPLIER2\nTHE POLYTHENE COMPANY\nTHE SIGN & PRINT SHOP\nTHE WORKS PRINTING GROUP PTY LTD\nTIEN WAH PRESS (PTE) LIMITED\nTIM CARTER\nTLC DIGITAL +\nTONGLU AI-DE IMP & EXP CO LTD\nTOP PRINT\nTOTAL NETWORKS\nTOURISM BROCHURE EXCHANGE\nTRADEKOREA.COM\nTST PRINTING\nTUNG YUNG INTERNATIONAL LIMITED\nTYPEFACE\nTest supplier\nUSB BOOK COMPANY LTD\nUSB SKY ELECTRONIC TECHNOLOGY CO LTD\nUSB-LIFETIME ELECTRONIC TECHNOLOGY CO LTD\nVISTAPRINT\nWAH SHING PACKING PRODUCTS CO LTD\nWALKABOUT ENTERPRISES\nWASSYS TRNSPORT\nWEIFANG TOPSUN TEXTILE CO LTD\nWELSON MOLD (HONG KONG) CO LTD\nWENZHOU DIVINE LAND DECORATION LIGHT CO LTD\nWENZHOU GUANGXIN PACKAGING CO LTD\nWENZHOU SUCCESS GROUP CO LTD\nWENZHOU TIANHAO PEN INDUSTRIAL CO LTD\nWENZHOU TREASURE CRAFTS CO LTD\nWENZHOUSHENGCAIGONGYILIPINCHANG\nWENZHOUY FEIYA STATIONERY CO LTD\nWHOLE VIEW SUPPLY CHAIN MANAGEMENT CO LTD\nWINBO INDUSTRIAL CO LTD\nXIAMEN BONSTAR BAGS CO LTD\nXIAMEN HAIRISHENG NON WOVEN PRIDUCTS LTD\nXIAMEN NOVELTY FLAG CO LTD\nXIAMEN WISELINK INDUSTRY & TRADE CO LTD\nXIAYI COUNTY SHENGONG PEN IDUSTRY CO LTD\nXING CHEN HAT INDUSTRY CO LTD\nYESING LABEL COMPANY\nYIWU BAILONG ELECTRICAL APPLIANCE CO LTD\nYIWU CITY JIANPING SCHOOL SUPPLY AND STATIONE\nYIWU HANFENG HANDBAG CO LTD\nYIWU HUA DA STATIONERY FIRM\nYIWU SHUANGDELI COLOR PRINTING FACTORY\nYIWU WAHU GIFT PACKING CO LTD\nYIWU XIAO BO SHI STATIONERY CO LTD\nYIWU XINGQIBA TOY BUSINESS\nYIWU ZHUO YUAN PACKAGING FACTORY\nYOUNG SUN TRADING CO LTD\nZHANGJIAGANG JINGGONG PACKAGING & COLOR PRINT\nZHEJIANG HUAXU INDUSTRIAL CO LTD\nZHEJIANG OTOR CONTAINER TECHNOLOGY CO LTD\nZHEJIANG SANBAO PRINTING CO LTD\nZHEJIANG VOLONG SANITARY WARES CO LTD\nZHEJINAG YIWU BAOLONG WRAPPING S&T CO LTD\nZHONGQIAN LIGHTING\nZHONGSHAN LEADER LIGHTING TECHNOLOGY CO LTD\nZHONGSHAN NORSLAN LIGHTING & ELECTRONICS CO L\n") as $supplier_name) {
Supplier::create(['supplier_name' => $supplier_name]);
}
$franklin = Supplier::where('supplier_name', '=', 'FRANKLIN DIRECT')->firstOrFail();
$compufix = Supplier::where('supplier_name', '=', 'COMPUFIX TAS')->firstOrFail();
SupplierContact::create(['supplier_id' => $franklin->id, 'first_name' => 'David', 'last_name' => 'Thorne', 'email' => '*****@*****.**']);
SupplierContact::create(['supplier_id' => $compufix->id, 'first_name' => 'Craig', 'last_name' => 'Marshall', 'email' => '*****@*****.**']);
}
public function index()
{
$modele = Modeles::with('category', 'brand')->get();
$supp = Supplier::all();
$articles_modeles = Article::with('theModels.brand', 'theModels.category', 'supplier')->get();
$leftmenu['model'] = 'active';
$leftmenu['model_article'] = 'active';
if (isset($_GET['sel_modele'])) {
$response = ['leftmenu' => $leftmenu, 'modeles' => $modele, 'article_modele' => $articles_modeles, 'suppliers' => $supp, 'selection' => $_GET['sel_modele']];
} else {
$response = ['leftmenu' => $leftmenu, 'modeles' => $modele, 'article_modele' => $articles_modeles, 'suppliers' => $supp];
}
return view('/articles/index', $response);
}
public function query()
{
$input = Input::all();
$response = array();
$response['product'] = Product::where('name', 'like', $input['query'] . '%')->orderBy('name')->first();
$response['supplier'] = Supplier::find($response['product']->supplier_id);
$response['category'] = ProductCategory::find($response['product']->product_category_id);
$response['boxes'] = Box::where('product_id', $response['product']->id)->get();
$response['stocks'] = array();
foreach ($response['boxes'] as $box) {
$stock = Box::countStock($box->id);
array_push($response['stocks'], $stock);
}
return $response;
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
switch ($this->method()) {
case 'POST':
return ['name' => 'required', 'telephone_number' => 'required|numeric', 'address' => 'required', 'tin' => 'required|numeric|unique:suppliers'];
case 'PATCH':
$supplier = Supplier::find($this->segment(2));
//this gets the second segment in the url which is the id of the supplier
if ($this->get('tin') == $supplier['tin']) {
return ['name' => 'required', 'telephone_number' => 'required|numeric', 'address' => 'required', 'tin' => 'required|numeric|unique:suppliers,tin,' . $this->segment(2)];
} else {
return ['name' => 'required', 'telephone_number' => 'required|numeric', 'address' => 'required', 'tin' => 'required|numeric|unique:suppliers'];
}
default:
break;
}
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create(Request $request)
{
if ($request->isMethod('post')) {
$validator = Validator::make($request->all(), ['first_name' => 'required', 'last_name' => 'required', 'email' => 'required|email|unique:suppliers', 'password' => 'required']);
if ($validator->fails()) {
return redirect::route('add_supplier')->with('errmsg', [$validator->messages()->all()]);
} else {
$first_name = $request->first_name;
$last_name = $request->last_name;
$phone = $request->phone;
$password = $request->password;
$email = $request->email;
$password = $request->password;
$insert_arr = array('first_name' => $first_name, 'last_name' => $last_name, 'phone' => $phone, 'email' => $email, 'password' => Hash::make($password));
Supplier::insert($insert_arr);
return redirect::route('add_supplier')->with('successmsg', 'Supplier is added successfully');
}
}
return view('supplier/create_supplier');
}
public function handleAction(Request $request)
{
$action = $request->input('_action');
if ($action == 'createSupplier') {
//Creation :
Supplier::create($request->all());
// FLash messaging :
flash()->success('Opération réussie!', 'Fournisseur créé avec succès.');
} else {
if ($action == 'addArt') {
try {
$this->validate($request, ['reference' => 'unique:articles']);
Article::create($request->all());
} catch (\Exception $e) {
return response(['status' => 'doublon'], 500);
}
return response(['status' => 'success']);
} else {
}
}
return redirect('/suppliers');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$companies = \DB::table('companies')->lists('store_name', 'id');
$channels = \DB::table('marketing_channels')->lists('channel_name', 'id');
$suppliers = \DB::table('suppliers')->lists('supplier_name', 'id');
$supplier_id = \Request::get('supplier_id');
$marketing_channel_id = \Request::get('marketing_channel_id');
$company_id = \Request::get('company_id');
$from = \Request::get('from') . ' 00:00:00';
$to = \Request::get('to') . ' 23:59:59';
if ($supplier_id && $marketing_channel_id && $company_id) {
$supplier_branches = \App\Supplier::find($supplier_id)->supplierBranches;
foreach ($supplier_branches as $supplier_branch) {
$branch_ids[] = $supplier_branch->id;
}
$allFiscalDocuments = FiscalDocument::whereBetween('created_at', [$from, $to])->WhereIn('supplier_branch_id', $branch_ids)->Where('company_id', $company_id)->orderBy('id', 'desc')->paginate(5);
$allCost = Cost::whereBetween('created_at', [$from, $to])->Where('supplier_id', $supplier_id)->Where('marketing_channel_id', $marketing_channel_id)->Where('company_id', $company_id)->orderBy('id', 'desc')->get();
} else {
$allFiscalDocuments = FiscalDocument::orderBy('id', 'desc')->paginate(5);
$allCost = Cost::orderBy('id', 'desc')->paginate(5);
}
return view('cost.join', ['fiscalDocuments' => $allFiscalDocuments, 'companies' => $companies, 'suppliers' => $suppliers, 'channels' => $channels, 'costs' => $allCost]);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$messages = ['required' => 'This field MUST not be empty.', 'unique' => 'The data EXISTED already.'];
$rules = ['drug_name' => 'required', 'drug_lowlimit' => 'required', 'dateOfPurchase' => 'required', 'dateOfExpiry' => 'required', 'drug_supplier' => 'required', 'unitsOnHand' => 'required'];
$validation = Validator::make($request->all(), $rules, $messages);
if ($validation->fails()) {
return redirect()->back()->withErrors($validation)->withInput($request->all());
}
$dName = $request->input('drug_name');
$dLow = $request->input('drug_lowlimit');
$dType = $request->input('drug_type');
$dRemarks = $request->input('drug_remarks');
$dPreCau = $request->input('drug_precaution');
$dDPur = $request->input('dateOfPurchase');
$dDExp = $request->input('dateOfExpiry');
$dSupp = $request->input('drug_supplier');
$suppID = Supplier::where('supp_name', $dSupp)->first();
//change name to ID
$dInt = $request->input('intakeTime');
$dFreq = $request->input('frequency');
$dSpu = $request->input('spu');
$dUnitHnd = $request->input('unitsOnHand');
$inventory = Inventory::find($id);
$inventory->drug_name = $dName;
$inventory->drug_lowlimit = $dLow;
$inventory->drug_type = $dType;
$inventory->drug_remarks = $dRemarks;
$inventory->drug_precaution = $dPreCau;
$inventory->dateOfPurchase = $dDPur;
$inventory->dateOfExpiry = $dDExp;
$inventory->drug_supplier = $suppID->id;
$inventory->intakeTime = $dInt;
$inventory->frequency = $dFreq;
$inventory->spu = $dSpu;
$inventory->unitsOnHand = $dUnitHnd;
$inventory->save();
Alert::success('Save!')->persistent("Close")->autoclose(2000);
return redirect()->action('InvController@index');
}
// }, 'json');
var items = <?php
echo Item::all()->lists('unit', 'id');
?>
;
$(unitChange).text(items[searcher]);
$.get('getTopSuppliers', {item: searcher}, function(data){
var terms = <?php
echo Supplier::all()->lists('payment_terms', 'id');
?>
;
var contact = <?php
echo Supplier::all()->lists('telephone_number', 'id');
?>
;
if (data[0]) {
$(".supplierChange1").val(data[0].supplier_id);
$(".itemPrice1").attr("placeholder", data[0].price);
$(".lastUpdated1").text(data[0].date);
$(".yesNo1").val(data[0].stock_availability);
$(".supplierTerms1").text(terms[data[0].supplier_id]);
$(".contact1").text(contact[data[0].supplier_id]);
} else {
$(".itemPrice1").attr("placeholder", "");
$(".lastUpdated1").text('');
$(".supplierTerms1").text('');
$(".contact1").text('');
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$supplier = Supplier::findOrFail($id);
$supplier->delete();
return Redirect::action('SupplierController@index');
}
function import_product_supplier($product, $refs, $sku)
{
$refs = $this->parse($refs);
foreach ($refs as $ref) {
$t = Supplier::where('ref', $ref)->first();
if (!$t) {
$this->errors[] = sprintf("%s in product %s (row %d) is missing from Suppliers. Skipping this Supplier association.", $ref, $sku, $this->idx);
continue;
}
ProductSupplier::create(['product_id' => $product->id, 'supplier_id' => $t->id]);
}
}
