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'));
}
/**
* Show the sites of a category
* @param string $slug
*
* @return array
*/
public function getCategories($slug)
{
$category = SiteCategory::findBySlug($slug);
$categoryName = $category->name;
$sites = SiteCategory::find($category->id)->sites()->orderBy('name', 'asc')->get();
return compact('sites', 'categoryName');
}
/**
* 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();
}
/**
* @return \Illuminate\Http\JsonResponse
*/
public function ajax_destroy()
{
Helper::allow('admin');
$data = $this->request;
$category = SiteCategory::find($data['id']);
if (count($category->sites) > 0) {
return response()->json(['type' => 'error', 'message' => 'This category has children! Can\'t delete.']);
}
$category->delete();
return response()->json(['type' => 'success', 'id' => $data['id']]);
}
