public function buildForm() { $SiteCategories = SiteCategory::all(['id', 'name'])->sortBy('name')->pluck('name', 'id')->toArray(); //create (pane 1) $this->add('name', 'text', Helper::buildFormAddWithIcon('Name of your business', 'name', 'fa fa-edit')); $this->add('short_description', 'text', Helper::buildFormAddWithIcon('Short description', 'short_description', 'fa fa-info', 'success', 'required|min:2|max:255')); $this->add('email', 'email', Helper::buildFormAddWithIcon('Your business email, if empty your login email is used', 'email', 'fa fa-at', 'success', 'email', Auth::user()->email)); $this->add('city_id', 'text', Helper::buildFormAddWithIcon('Your city', 'city_id', 'fa fa-street-view', 'success', 'required')); $this->add('barangay_name', 'text', Helper::buildFormAddWithIcon('Your barangay (optional but can be handy)', 'barangay_name', 'fa fa-map-marker', 'success', 'max:40')); $this->add('categories', 'select', array_merge(['choices' => $SiteCategories, 'selected' => function () { return $this->model->categories->pluck('id')->toArray(); }], Helper::buildFormAddWithIcon('Choose the categories of your business', 'categories', '', 'success', '', '', 'vendor.laravel-form-builder.select-icon', false, true))); //address and options (pane 2) $this->add('phone_number', 'tel', Helper::buildFormAddWithIcon('Your contact number', 'phone_number', 'fa fa-phone', 'success')); $this->add('street', 'text', Helper::buildFormAddWithIcon('Your street address', 'street', 'fa fa-street-view', 'success', 'max:60')); $this->add('street_number', 'text', Helper::buildFormAddWithIcon('The house number', 'street_number', 'fa fa-street-view', 'success', 'max:10')); $this->add('long_description', 'textarea', Helper::buildFormAddWithIcon('Long description', 'long_description', 'fa fa-book', 'success', 'max:3000', '', 'vendor.laravel-form-builder.textarea-icon')); $this->add('can_comment', 'checkbox', Helper::buildFormAddWithIcon('Do you accept comments on your business page?', 'can_comment', '', 'success')); $this->add('auto_comments', 'checkbox', Helper::buildFormAddWithIcon('Do you wants comments to be auto-accepted?', 'auto_comments', '', 'success')); /*$this->add('file_uploads', 'button', ['label' => 'Upload pictures', 'attr' => ['class' => 'btn btn-primary btn-sm', 'data-toggle' => 'modal', 'data-target' => '#file_uploads']]);*/ //media (pane 3) $this->add('url', 'text', Helper::buildFormAddWithIcon('If you have a website, enter it here', 'url', 'fa fa-globe', 'success', 'max:100')); $this->add('facebook_url', 'text', Helper::buildFormAddWithIcon('Insert your Facebook page', 'url', 'fa fa-facebook-official', 'success', 'max:100')); $this->add('twitter_url', 'text', Helper::buildFormAddWithIcon('Insert your Twitter account', 'url', 'fa fa-twitter-square', 'success', 'max:100')); $this->add('instagram_url', 'text', Helper::buildFormAddWithIcon('Insert your Instagram account', 'url', 'fa fa-instagram', 'success', 'max:100')); }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::table('site_categories')->insert(['id' => 154, 'name' => 'Art and Collectibles']); DB::table('site_categories')->insert(['id' => 157, 'name' => 'Computers and Internet']); DB::table('site_categories')->insert(['id' => 158, 'name' => 'Entertainment']); DB::table('site_categories')->insert(['id' => 159, 'name' => 'Financial Services']); DB::table('site_categories')->insert(['id' => 160, 'name' => 'Food and Beverage']); DB::table('site_categories')->insert(['id' => 162, 'name' => 'Health and Medicine']); DB::table('site_categories')->insert(['id' => 163, 'name' => 'Home and Garden']); DB::table('site_categories')->insert(['id' => 164, 'name' => 'Home Contractors']); DB::table('site_categories')->insert(['id' => 165, 'name' => 'Insurance']); DB::table('site_categories')->insert(['id' => 166, 'name' => 'Legal Services']); DB::table('site_categories')->insert(['id' => 167, 'name' => 'Personal Care']); DB::table('site_categories')->insert(['id' => 168, 'name' => 'Pets']); DB::table('site_categories')->insert(['id' => 169, 'name' => 'Professional Services']); DB::table('site_categories')->insert(['id' => 170, 'name' => 'Real Estate']); DB::table('site_categories')->insert(['id' => 171, 'name' => 'Restaurants']); DB::table('site_categories')->insert(['id' => 173, 'name' => 'Sports and Recreation']); DB::table('site_categories')->insert(['id' => 174, 'name' => 'Travel and Transportation']); DB::table('site_categories')->insert(['id' => 175, 'name' => 'Resort']); DB::table('site_categories')->insert(['id' => 177, 'name' => 'Crafts and Hobbies']); DB::table('site_categories')->insert(['id' => 180, 'name' => 'Graphic Design']); DB::table('site_categories')->insert(['id' => 183, 'name' => 'Auto Parts']); DB::table('site_categories')->insert(['id' => 184, 'name' => 'Body Repair and Paint']); DB::table('site_categories')->insert(['id' => 185, 'name' => 'Brake Service']); DB::table('site_categories')->insert(['id' => 186, 'name' => 'Car Audio']); DB::table('site_categories')->insert(['id' => 187, 'name' => 'Car Dealers']); DB::table('site_categories')->insert(['id' => 188, 'name' => 'Car Washes']); DB::table('site_categories')->insert(['id' => 189, 'name' => 'Driving Schools']); DB::table('site_categories')->insert(['id' => 191, 'name' => 'Gas Stations']); DB::table('site_categories')->insert(['id' => 192, 'name' => 'Glass']); DB::table('site_categories')->insert(['id' => 193, 'name' => 'Motorcycle Dealers']); DB::table('site_categories')->insert(['id' => 194, 'name' => 'Moving and Movers']); DB::table('site_categories')->insert(['id' => 196, 'name' => 'Repair and Service']); DB::table('site_categories')->insert(['id' => 198, 'name' => 'Cemeteries']); DB::table('site_categories')->insert(['id' => 199, 'name' => 'Child Care']); DB::table('site_categories')->insert(['id' => 200, 'name' => 'Clubs and Organizations']); DB::table('site_categories')->insert(['id' => 201, 'name' => 'Education and Instruction']); DB::table('site_categories')->insert(['id' => 202, 'name' => 'Fire and Emergency']); DB::table('site_categories')->insert(['id' => 203, 'name' => 'Funeral Homes']); DB::table('site_categories')->insert(['id' => 204, 'name' => 'Government']); DB::table('site_categories')->insert(['id' => 205, 'name' => 'Law Enforcement']); DB::table('site_categories')->insert(['id' => 206, 'name' => 'Libraries']); DB::table('site_categories')->insert(['id' => 207, 'name' => 'Marriage Counseling']); DB::table('site_categories')->insert(['id' => 208, 'name' => 'Media and Publications']); DB::table('site_categories')->insert(['id' => 209, 'name' => 'Parks']); DB::table('site_categories')->insert(['id' => 210, 'name' => 'Post Offices']); DB::table('site_categories')->insert(['id' => 211, 'name' => 'Religion and Spirituality']); DB::table('site_categories')->insert(['id' => 212, 'name' => 'Senior Services']); DB::table('site_categories')->insert(['id' => 213, 'name' => 'Social and Welfare Services']); DB::table('site_categories')->insert(['id' => 214, 'name' => 'Youth Groups']); DB::table('site_categories')->insert(['id' => 215, 'name' => 'Classes and Instruction']); DB::table('site_categories')->insert(['id' => 216, 'name' => 'Accessories and Services']); DB::table('site_categories')->insert(['id' => 217, 'name' => 'Consultants']); DB::table('site_categories')->insert(['id' => 218, 'name' => 'Computer Retailers']); DB::table('site_categories')->insert(['id' => 219, 'name' => 'Internet Service Providers']); DB::table('site_categories')->insert(['id' => 220, 'name' => 'Web Design']); DB::table('site_categories')->insert(['id' => 221, 'name' => 'Web Development']); DB::table('site_categories')->insert(['id' => 222, 'name' => 'Web Hosting']); DB::table('site_categories')->insert(['id' => 223, 'name' => 'Web Services']); DB::table('site_categories')->insert(['id' => 224, 'name' => 'Bands and Musicians']); DB::table('site_categories')->insert(['id' => 225, 'name' => 'DJs']); DB::table('site_categories')->insert(['id' => 227, 'name' => 'Party Rentals']); DB::table('site_categories')->insert(['id' => 228, 'name' => 'Videoke Rentals']); DB::table('site_categories')->insert(['id' => 229, 'name' => 'Theatres']); DB::table('site_categories')->insert(['id' => 230, 'name' => 'Accounting and Auditing']); DB::table('site_categories')->insert(['id' => 231, 'name' => 'Banks']); DB::table('site_categories')->insert(['id' => 232, 'name' => 'Bookkeeping']); DB::table('site_categories')->insert(['id' => 233, 'name' => 'Credit Consulting']); DB::table('site_categories')->insert(['id' => 234, 'name' => 'Financial Planning']); DB::table('site_categories')->insert(['id' => 235, 'name' => 'Home Mortgages']); DB::table('site_categories')->insert(['id' => 236, 'name' => 'Investment Services']); DB::table('site_categories')->insert(['id' => 237, 'name' => 'Tax Preperation']); DB::table('site_categories')->insert(['id' => 238, 'name' => 'Catering']); DB::table('site_categories')->insert(['id' => 239, 'name' => 'Grocers']); DB::table('site_categories')->insert(['id' => 240, 'name' => 'Health Foods']); DB::table('site_categories')->insert(['id' => 241, 'name' => 'Restaurant Equipment']); DB::table('site_categories')->insert(['id' => 242, 'name' => 'Specialty Foods']); DB::table('site_categories')->insert(['id' => 243, 'name' => 'Wine and Liquor']); DB::table('site_categories')->insert(['id' => 246, 'name' => 'Gifts & Specialties']); DB::table('site_categories')->insert(['id' => 247, 'name' => 'Jewelers']); DB::table('site_categories')->insert(['id' => 248, 'name' => 'Jewelry']); DB::table('site_categories')->insert(['id' => 249, 'name' => 'Chiropractic']); DB::table('site_categories')->insert(['id' => 250, 'name' => 'Dentists & Dentistry']); DB::table('site_categories')->insert(['id' => 251, 'name' => 'Family Practice']); DB::table('site_categories')->insert(['id' => 252, 'name' => 'Medical Clinics']); DB::table('site_categories')->insert(['id' => 255, 'name' => 'Plastic & Reconstructive Surgery']); DB::table('site_categories')->insert(['id' => 257, 'name' => 'Pharmacies']); DB::table('site_categories')->insert(['id' => 258, 'name' => 'Physical Therapy']); DB::table('site_categories')->insert(['id' => 260, 'name' => 'Products and Services']); DB::table('site_categories')->insert(['id' => 261, 'name' => 'Speech Therapy']); DB::table('site_categories')->insert(['id' => 262, 'name' => 'Sports Medicine']); DB::table('site_categories')->insert(['id' => 263, 'name' => 'Appliance Repair']); DB::table('site_categories')->insert(['id' => 264, 'name' => 'Appliances']); DB::table('site_categories')->insert(['id' => 265, 'name' => 'Architecture']); DB::table('site_categories')->insert(['id' => 266, 'name' => 'Building Materials']); DB::table('site_categories')->insert(['id' => 269, 'name' => 'Doors and Windows']); DB::table('site_categories')->insert(['id' => 270, 'name' => 'Dry Cleaning']); DB::table('site_categories')->insert(['id' => 271, 'name' => 'Equipment and Tools']); DB::table('site_categories')->insert(['id' => 272, 'name' => 'Equipment Rental']); DB::table('site_categories')->insert(['id' => 273, 'name' => 'Furniture']); DB::table('site_categories')->insert(['id' => 274, 'name' => 'Furniture Repair']); DB::table('site_categories')->insert(['id' => 275, 'name' => 'Gardening']); DB::table('site_categories')->insert(['id' => 277, 'name' => 'House Cleaning']); DB::table('site_categories')->insert(['id' => 278, 'name' => 'Interior Decorating']); DB::table('site_categories')->insert(['id' => 279, 'name' => 'Laundromats']); DB::table('site_categories')->insert(['id' => 280, 'name' => 'Lawn Care']); DB::table('site_categories')->insert(['id' => 281, 'name' => 'Locks & Locksmiths']); DB::table('site_categories')->insert(['id' => 282, 'name' => 'Lumber']); DB::table('site_categories')->insert(['id' => 283, 'name' => 'Movers & Moving']); DB::table('site_categories')->insert(['id' => 284, 'name' => 'Nurseries']); DB::table('site_categories')->insert(['id' => 285, 'name' => 'Paint and Wall coverings']); DB::table('site_categories')->insert(['id' => 286, 'name' => 'Pest Control']); DB::table('site_categories')->insert(['id' => 287, 'name' => 'Playground Equipment']); DB::table('site_categories')->insert(['id' => 288, 'name' => 'Pools, Spas& Saunas']); DB::table('site_categories')->insert(['id' => 289, 'name' => 'Self Storage']); DB::table('site_categories')->insert(['id' => 290, 'name' => 'Tile & Flooring']); DB::table('site_categories')->insert(['id' => 291, 'name' => 'Tools & Hardware']); DB::table('site_categories')->insert(['id' => 294, 'name' => 'Cabinetmakers']); DB::table('site_categories')->insert(['id' => 295, 'name' => 'Concrete & Brick']); DB::table('site_categories')->insert(['id' => 296, 'name' => 'Electricians']); DB::table('site_categories')->insert(['id' => 297, 'name' => 'Fencing & Gates']); DB::table('site_categories')->insert(['id' => 298, 'name' => 'General Contractors']); DB::table('site_categories')->insert(['id' => 299, 'name' => 'Home Improvement']); DB::table('site_categories')->insert(['id' => 301, 'name' => 'Landscaping']); DB::table('site_categories')->insert(['id' => 302, 'name' => 'Painting']); DB::table('site_categories')->insert(['id' => 303, 'name' => 'Plumbing']); DB::table('site_categories')->insert(['id' => 304, 'name' => 'Pool Contractors']); DB::table('site_categories')->insert(['id' => 305, 'name' => 'Roofing Contractors']); DB::table('site_categories')->insert(['id' => 306, 'name' => 'Tile & Flooring Contractors']); DB::table('site_categories')->insert(['id' => 307, 'name' => 'Waste Management']); DB::table('site_categories')->insert(['id' => 308, 'name' => 'Auto Insurance']); DB::table('site_categories')->insert(['id' => 309, 'name' => 'Health Insurance']); DB::table('site_categories')->insert(['id' => 310, 'name' => 'Home Insurance']); DB::table('site_categories')->insert(['id' => 311, 'name' => 'Life Insurance']); DB::table('site_categories')->insert(['id' => 313, 'name' => 'Attorneys']); DB::table('site_categories')->insert(['id' => 314, 'name' => 'Estate and Probate Law']); DB::table('site_categories')->insert(['id' => 315, 'name' => 'Law Offices']); DB::table('site_categories')->insert(['id' => 316, 'name' => 'Barber Shops']); DB::table('site_categories')->insert(['id' => 317, 'name' => 'Beauty Supplies']); DB::table('site_categories')->insert(['id' => 318, 'name' => 'Personal Coaches']); DB::table('site_categories')->insert(['id' => 319, 'name' => 'Fitness']); DB::table('site_categories')->insert(['id' => 320, 'name' => 'Health Clubs']); DB::table('site_categories')->insert(['id' => 321, 'name' => 'Salon & Spa']); DB::table('site_categories')->insert(['id' => 327, 'name' => 'Pet Supplies']); DB::table('site_categories')->insert(['id' => 328, 'name' => 'Veterinarians']); DB::table('site_categories')->insert(['id' => 329, 'name' => 'Advertising']); DB::table('site_categories')->insert(['id' => 331, 'name' => 'Communications']); DB::table('site_categories')->insert(['id' => 332, 'name' => 'Consulting']); DB::table('site_categories')->insert(['id' => 333, 'name' => 'Courier / Delivery Service']); DB::table('site_categories')->insert(['id' => 334, 'name' => 'Employee Benefits']); DB::table('site_categories')->insert(['id' => 335, 'name' => 'Employment']); DB::table('site_categories')->insert(['id' => 336, 'name' => 'Graphic Design']); DB::table('site_categories')->insert(['id' => 337, 'name' => 'Mail Services']); DB::table('site_categories')->insert(['id' => 338, 'name' => 'Marketing Consultants']); DB::table('site_categories')->insert(['id' => 339, 'name' => 'Notaries']); DB::table('site_categories')->insert(['id' => 340, 'name' => 'Office Supplies']); DB::table('site_categories')->insert(['id' => 341, 'name' => 'Photographers / Portraits']); DB::table('site_categories')->insert(['id' => 342, 'name' => 'Printing & Print Services']); DB::table('site_categories')->insert(['id' => 343, 'name' => 'Shoe Repair']); DB::table('site_categories')->insert(['id' => 344, 'name' => 'Videographers']); DB::table('site_categories')->insert(['id' => 345, 'name' => 'Wedding / Event Planners']); DB::table('site_categories')->insert(['id' => 346, 'name' => 'Apartments']); DB::table('site_categories')->insert(['id' => 351, 'name' => 'Mortgage Brokers & Lenders']); DB::table('site_categories')->insert(['id' => 353, 'name' => 'Real Estate Agents']); DB::table('site_categories')->insert(['id' => 354, 'name' => 'Real Estate Offices']); DB::table('site_categories')->insert(['id' => 355, 'name' => 'Title Companies']); DB::table('site_categories')->insert(['id' => 361, 'name' => 'Fast Food']); DB::table('site_categories')->insert(['id' => 362, 'name' => 'Fine Dining']); DB::table('site_categories')->insert(['id' => 364, 'name' => 'Italian']); DB::table('site_categories')->insert(['id' => 365, 'name' => 'Mexican']); DB::table('site_categories')->insert(['id' => 366, 'name' => 'Other']); DB::table('site_categories')->insert(['id' => 368, 'name' => 'Deli']); DB::table('site_categories')->insert(['id' => 369, 'name' => 'Seafood']); DB::table('site_categories')->insert(['id' => 370, 'name' => 'Steak House']); DB::table('site_categories')->insert(['id' => 371, 'name' => 'Accessories & Jewelry']); DB::table('site_categories')->insert(['id' => 372, 'name' => 'Beauty Supplies']); DB::table('site_categories')->insert(['id' => 373, 'name' => 'Books & Music']); DB::table('site_categories')->insert(['id' => 375, 'name' => 'Department Stores']); DB::table('site_categories')->insert(['id' => 376, 'name' => 'Games & Accessories']); DB::table('site_categories')->insert(['id' => 377, 'name' => 'Gifts & Specialty Items']); DB::table('site_categories')->insert(['id' => 378, 'name' => 'Home Electronics']); DB::table('site_categories')->insert(['id' => 379, 'name' => 'Home Furnishings']); DB::table('site_categories')->insert(['id' => 380, 'name' => 'Luggage & Leather goods']); DB::table('site_categories')->insert(['id' => 381, 'name' => 'Photographic Equipt. & Supplies']); DB::table('site_categories')->insert(['id' => 383, 'name' => 'Boats & Accessories']); DB::table('site_categories')->insert(['id' => 384, 'name' => 'Cycling']); DB::table('site_categories')->insert(['id' => 385, 'name' => 'Golf Courses']); DB::table('site_categories')->insert(['id' => 386, 'name' => 'Golf Equipt. & Supplies']); DB::table('site_categories')->insert(['id' => 387, 'name' => 'Gymnastics']); DB::table('site_categories')->insert(['id' => 388, 'name' => 'Martial Arts']); DB::table('site_categories')->insert(['id' => 389, 'name' => 'Paintball']); DB::table('site_categories')->insert(['id' => 390, 'name' => 'Sporting Goods']); DB::table('site_categories')->insert(['id' => 391, 'name' => 'Sports Facilities']); DB::table('site_categories')->insert(['id' => 392, 'name' => 'Airport Shuttle']); DB::table('site_categories')->insert(['id' => 393, 'name' => 'Car Rental']); DB::table('site_categories')->insert(['id' => 394, 'name' => 'Hotels & Lodging']); DB::table('site_categories')->insert(['id' => 395, 'name' => 'Limousine Service']); DB::table('site_categories')->insert(['id' => 396, 'name' => 'Taxi Service']); DB::table('site_categories')->insert(['id' => 397, 'name' => 'Travel Agencies']); $site_categories = new SiteCategory(); $all_site_categories = $site_categories->all()->toArray(); foreach ($all_site_categories as $site_category) { $site_category['slug'] = str_slug($site_category['name']); DB::table('site_categories')->where('id', $site_category['id'])->update($site_category); } Model::reguard(); }
/** * Search all businesses * * @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View */ public function search() { $sites = Site::all()->sortBy(['name']); $categories = SiteCategory::all()->sortBy(['name']); return view('sites.search', compact('sites', 'categories')); }