public function run() { Illuminate\Support\Facades\DB::table('customers')->delete(); for ($i = 0; $i < 50; $i++) { Customer::create(['name' => '测试客户' . ($i + 1), 'phoneNum' => (string) (15253212675.0 + $i), 'wx' => 'jm_god_father_' . $i, 'address' => '青岛市香港中路132号3号楼1505', 'customer_category_id' => $i % 2 == 0 ? 1 : 2]); } }
public function run() { Illuminate\Support\Facades\DB::table('suppliers')->delete(); for ($i = 0; $i < 45; ++$i) { Suppliers::create(['name' => '测试供应商1' . $i, 'address' => '首尔' . $i . '路' . $i . '号', 'wx_num' => 'aasdd_dd', 'phone_num' => '18653292593', 'qq' => '22345642']); } }
public function run() { Illuminate\Support\Facades\DB::table('products')->delete(); // 插入100条测试数据 for ($i = 0; $i < 100; ++$i) { Product::create(['model_id' => 'EFG4' . (string) ($i * 100), 'name' => '测试产品' . (string) $i, 'origin_price' => 332.34 * $i, 'demestic_price' => 123 * $i, 'count' => $i, 'thumbnail' => 'test.jpg', 'detail_image' => '', 'category_id' => $i % 2 == 0 ? 1 : 2, 'brand_id' => $i % 2 == 0 ? 2 : 1]); } }
function select($query, $parameters = array()) { return Illuminate\Support\Facades\DB::select($query, $parameters); }
|Guest Routes |-------------------------------------------------------------------- | Here defining Guest User's routes | | */ // seasrch Route::POST('tickets/search/', function () { $keyword = Illuminate\Support\Str::lower(Input::get('auto')); $models = App\Model\Ticket\Tickets::where('ticket_number', '=', $keyword)->orderby('ticket_number')->take(10)->skip(0)->get(); $count = count($models); return Illuminate\Support\Facades\Redirect::back()->with("contents", $models)->with("counts", $count); }); Route::any('getdata', function () { $term = Illuminate\Support\Str::lower(Input::get('term')); $data = Illuminate\Support\Facades\DB::table("tickets")->distinct()->select('ticket_number')->where('ticket_number', 'LIKE', $term . '%')->groupBy('ticket_number')->take(10)->get(); foreach ($data as $v) { return ['value' => $v->ticket_number]; } }); Route::get('getform', ['as' => 'guest.getform', 'uses' => 'Client\\helpdesk\\FormController@getForm']); /* get the form for create a ticket by guest user */ Route::post('postform/{id}', 'Client\\helpdesk\\FormController@postForm'); /* post the AJAX form for create a ticket by guest user */ Route::post('postedform', 'Client\\helpdesk\\FormController@postedForm'); /* post the form to store the value */ Route::get('check', 'CheckController@getcheck'); //testing checkbox auto-populate Route::post('postcheck/{id}', 'CheckController@postcheck'); Route::get('home', ['as' => 'home', 'uses' => 'Client\\helpdesk\\WelcomepageController@index']); //guest layout
/** * This will get the data rows from the database * with the all where queries * * @return void */ private function setResultRows() { $this->query->select($this->columnsToSelect); $this->resultRows = $this->query->get(); }