/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$employee_ids = Employee::all()->lists('id')->toArray();
$order_states = OrderState::lists('id')->toArray();
$products = Product::all();
$municipalities = Municipality::all();
factory(App\Customer::class, 50)->create()->each(function ($customer) use($employee_ids, $products, $municipalities, $order_states) {
shuffle($employee_ids);
shuffle($order_states);
$customer->user()->save(factory(User::class, 'customer')->create());
$customer->city_id = $municipalities->shuffle()->first()->id;
$customer->save();
$customer->products()->attach($products->shuffle()->first(), ['vote' => rand(1, 5), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
$customer->orders()->save(factory(App\Order::class)->create(['acquired_by' => $employee_ids[0], 'state_id' => $order_states[0]]));
});
$user = new User();
$user->name = 'Vid';
$user->surname = 'Mahovic';
$user->email = '*****@*****.**';
$user->password = '******';
$user->verified = true;
$user->save();
$customer = new Customer();
$customer->street = 'Celovška 21';
$customer->city_id = $municipalities->shuffle()->first()->id;
$customer->phone = '+38640850993';
$customer->save();
$customer->user()->save($user);
}
public function add_seek_announcement()
{
if (!Auth::user() || Auth::user()->role != 2) {
return redirect('/');
}
$fields = Field::orderBy('name')->lists('name', 'id');
$terms = Term::lists('name', 'id');
$municipalities = Municipality::all();
$municipality_regions = array();
foreach ($municipalities as $m) {
$municipality_regions[] = array('municipality' => $m, 'region' => $m->region);
}
$regions = Region::lists('name', 'id');
$type = array(0 => 'ვატარებ', 1 => 'ვეძებ');
return view('add_forms.add_seek_announcement', ['fields' => $fields, 'terms' => $terms, 'regions' => $regions, 'municipality_regions' => $municipality_regions, 'type' => $type]);
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
if (\Schema::hasTable('positions')) {
$positions = Position::all();
$selectPositions = array();
$selectPositions[0] = "Select / All";
foreach ($positions as $position) {
$selectPositions[$position->slug] = $position->name;
}
\View::share('selectPositions', $selectPositions);
}
if (\Schema::hasTable('cases_priorities')) {
$priorities = CasePriority::all();
$selectPriorities = array();
$selectPriorities[0] = "Select / All";
foreach ($priorities as $priority) {
$selectPriorities[$priority->slug] = $priority->name;
}
\View::share('selectPriorities', $selectPriorities);
}
if (\Schema::hasTable('titles')) {
$titles = Title::all();
$selectTitles = array();
$selectTitles[0] = "Select / All";
foreach ($titles as $title) {
$selectTitles[$title->slug] = $title->name;
}
\View::share('selectTitles', $selectTitles);
}
if (\Schema::hasTable('languages')) {
$languages = Language::all();
$selectLanguages = array();
$selectLanguages[0] = "Select / All";
foreach ($languages as $language) {
$selectLanguages[$language->slug] = $language->name;
}
\View::share('selectLanguages', $selectLanguages);
}
if (\Schema::hasTable('departments')) {
$departments = Department::all();
$selectDepartments = array();
$selectDepartments[0] = "Select / All";
foreach ($departments as $department) {
$selectDepartments[$department->slug] = $department->name;
}
\View::share('selectDepartments', $selectDepartments);
}
if (\Schema::hasTable('users_roles')) {
$roles = UserRole::all();
$selectRoles = array();
$selectRoles[0] = "Select / All";
foreach ($roles as $role) {
$selectRoles[$role->slug] = $role->name;
}
\View::share('selectRoles', $selectRoles);
}
if (\Schema::hasTable('provinces')) {
$provinces = Province::all();
$selectProvinces = array();
$selectProvinces[0] = "Select / All";
foreach ($provinces as $Province) {
$selectProvinces[$Province->slug] = $Province->name;
}
\View::share('selectProvinces', $selectProvinces);
}
if (\Schema::hasTable('districts')) {
$districts = District::all();
$selectDistrict = array();
$selectDistricts[0] = "Select / All";
foreach ($districts as $district) {
$selectDistricts[$district->slug] = $district->name;
}
\View::share('selectDistricts', $selectDistricts);
}
if (\Schema::hasTable('municipalities')) {
$municipalities = Municipality::all();
$selectMunicipalities = array();
$selectMunicipalities[0] = "Select / All";
foreach ($municipalities as $municipality) {
$selectMunicipalities[$municipality->slug] = $municipality->name;
}
\View::share('selectMunicipalities', $selectMunicipalities);
}
if (\Schema::hasTable('wards')) {
$wards = Ward::all();
$selectWards = array();
$selectWards[0] = "Select / All";
foreach ($wards as $ward) {
$selectWards[$ward->slug] = $ward->name;
}
\View::share('selectWards', $selectWards);
}
if (\Schema::hasTable('categories')) {
$categories = Category::all();
$selectCategories = array();
$selectCategories[0] = "Select / All";
foreach ($categories as $category) {
$selectCategories[$category->slug] = $category->name;
}
\View::share('selectCategories', $selectCategories);
}
if (\Schema::hasTable('sub_categories')) {
$subCategories = SubCategory::all();
$selectSubCategories = array();
$selectSubCategories[0] = "Select / All";
foreach ($subCategories as $subCategory) {
$selectSubCategories[$subCategory->slug] = $subCategory->name;
}
\View::share('selectSubCategories', $selectSubCategories);
}
if (\Schema::hasTable('sub_sub_categories')) {
$subSubCategories = SubSubCategory::all();
$selectSubSubCategories = array();
$selectSubSubCategories[0] = "Select / All";
foreach ($subSubCategories as $subSubCategory) {
$selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name;
}
\View::share('selectSubSubCategories', $selectSubSubCategories);
}
if (\Schema::hasTable('relationships')) {
$relationships = Relationship::all();
$selectRelationships = array();
$selectRelationships[0] = "Select / All";
foreach ($relationships as $relationship) {
$selectRelationships[$relationship->id] = $relationship->name;
}
\View::share('selectRelationships', $selectRelationships);
}
if (\Schema::hasTable('cases')) {
$cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`first_name`, ' ', `surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get();
$reporters = array();
$reporters[0] = "Select / All";
foreach ($cases as $case) {
$reporters[$case->reporterName] = $case->reporterName;
}
\View::share('selectReporters', $reporters);
}
View()->composer('master', function ($view) {
$view->with('addressBookNumber', addressbook::all());
if (\Auth::check()) {
$number = addressbook::where('user', '=', \Auth::user()->id)->get();
$view->with('addressBookNumber', $number);
$allUsers = User::where('id', '<>', \Auth::user()->id)->get();
$view->with('loggedInUsers', $allUsers);
$noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('message_type', '=', 0)->get();
$view->with('noPrivateMessages', $noPrivateMessages);
$noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('message_type', '=', 0)->get();
$view->with('noInboxMessages', $noInboxMessages);
$noDepartments = Department::all();
$view->with('noDepartments', $noDepartments);
$noUsers = User::all();
$view->with('noUsers', $noUsers);
$noRoles = UserRole::all();
$view->with('noRoles', $noRoles);
$noPositions = Position::all();
$view->with('noPositions', $noPositions);
$noRelationships = Relationship::all();
$view->with('noRelationships', $noRelationships);
$noProvinces = Province::all();
$view->with('noProvinces', $noProvinces);
$noCaseStatuses = CaseStatus::all();
$view->with('noCaseStatuses', $noCaseStatuses);
$userRole = UserRole::where('id', '=', \Auth::user()->role)->first();
$view->with('systemRole', $userRole);
$noCasesPriorities = CasePriority::all();
$view->with('noCasesPriorities', $noCasesPriorities);
}
});
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
if (\Schema::hasTable('positions')) {
$positions = Position::orderBy('name', 'ASC')->get();
$selectPositions = array();
$selectPositions[0] = "Select / All";
foreach ($positions as $position) {
$selectPositions[$position->slug] = $position->name;
}
\View::share('selectPositions', $selectPositions);
}
if (\Schema::hasTable('departments')) {
$departments = Department::orderBy('name', 'ASC')->get();
$selectDepartments = array();
$selectDepartments[0] = "Select / All";
foreach ($departments as $department) {
$selectDepartments[$department->slug] = $department->name;
}
\View::share('selectDepartments', $selectDepartments);
}
if (\Schema::hasTable('provinces')) {
$provinces = Province::all();
$selectProvinces = array();
$selectProvinces[0] = "Select / All";
foreach ($provinces as $Province) {
$selectProvinces[$Province->slug] = $Province->name;
}
\View::share('selectProvinces', $selectProvinces);
}
if (\Schema::hasTable('districts')) {
$districts = District::all();
$selectDistrict = array();
$selectDistricts[0] = "Select / All";
foreach ($districts as $district) {
$selectDistricts[$district->slug] = $district->name;
}
\View::share('selectDistricts', $selectDistricts);
}
if (\Schema::hasTable('municipalities')) {
$municipalities = Municipality::all();
$selectMunicipalities = array();
$selectMunicipalities[0] = "Select / All";
foreach ($municipalities as $municipality) {
$selectMunicipalities[$municipality->slug] = $municipality->name;
}
\View::share('selectMunicipalities', $selectMunicipalities);
}
if (\Schema::hasTable('categories')) {
$categories = Category::all();
$selectCategories = array();
$selectCategories[0] = "Select / All";
foreach ($categories as $category) {
$selectCategories[$category->slug] = $category->name;
}
\View::share('selectCategories', $selectCategories);
}
if (\Schema::hasTable('sub-categories')) {
$subCategories = SubCategory::all();
$selectSubCategories = array();
$selectSubCategories[0] = "Select / All";
foreach ($subCategories as $subCategory) {
$selectSubCategories[$subCategory->slug] = $subCategory->name;
}
\View::share('selectSubCategories', $selectSubCategories);
}
if (\Schema::hasTable('sub-sub-categories')) {
$subSubCategories = SubSubCategory::all();
$selectSubSubCategories = array();
$selectSubSubCategories[0] = "Select / All";
foreach ($subSubCategories as $subSubCategory) {
$selectSubSubCategories[$subSubCategory->slug] = $subSubCategory->name;
}
\View::share('selectSubSubCategories', $selectSubSubCategories);
}
if (\Schema::hasTable('relationships')) {
$relationships = Relationship::all();
$selectRelationships = array();
$selectRelationships[0] = "Select / All";
foreach ($relationships as $relationship) {
$selectRelationships[$relationship->id] = $relationship->name;
}
\View::share('selectRelationships', $selectRelationships);
}
if (\Schema::hasTable('cases')) {
$cases = \DB::table('cases')->join('users', 'cases.reporter', '=', 'users.id')->select(\DB::raw("\n IF(`cases`.`addressbook` = 1,(SELECT CONCAT(`FirstName`, ' ', `Surname`) FROM `addressbook` WHERE `addressbook`.`id`= `cases`.`reporter`), (SELECT CONCAT(users.`name`, ' ', users.`surname`) FROM `users` WHERE `users`.`id`= `cases`.`reporter`)) as reporterName\n\n "))->get();
$reporters = array();
$reporters[0] = "Select / All";
foreach ($cases as $case) {
$reporters[$case->reporterName] = $case->reporterName;
}
\View::share('selectReporters', $reporters);
}
View()->composer('master', function ($view) {
$view->with('addressBookNumber', addressbook::all());
if (\Auth::check()) {
$number = addressbook::where('user', '=', \Auth::user()->id)->get();
$view->with('addressBookNumber', $number);
$allUsers = User::where('id', '<>', \Auth::user()->id)->get();
$view->with('loggedInUsers', $allUsers);
$noPrivateMessages = Message::where('to', '=', \Auth::user()->id)->where('read', '=', 0)->where('online', '=', 0)->get();
$view->with('noPrivateMessages', $noPrivateMessages);
$noInboxMessages = Message::where('to', '=', \Auth::user()->id)->where('online', '=', 0)->get();
$view->with('noInboxMessages', $noInboxMessages);
}
});
}
public function get_seek_announcements(Request $request)
{
$field_search = input::get('field');
$term_search = input::get('term');
$region_search = input::get('region');
$municipalities_search = input::get('municipalities');
if ($field_search == '0' || empty($field_search)) {
$fields_all = Field::all(['id']);
foreach ($fields_all as $field) {
$fields[] = $field->id;
}
} else {
$fields[] = $field_search;
}
if ($term_search == '0' || empty($term_search)) {
$terms_all = Term::all(['id']);
foreach ($terms_all as $term) {
$terms[] = $term->id;
}
} else {
$terms[] = $term_search;
}
if ($municipalities_search[0] == '0' || empty($municipalities_search)) {
if ($region_search != '0' && !empty($region_search)) {
$any_municipality = Region::find($region_search)->get_municipalities()->get();
} else {
$any_municipality = Municipality::all(['id']);
}
foreach ($any_municipality as $instance) {
$municipality_id[] = $instance->id;
}
} else {
$municipality_id = $municipalities_search;
}
$select = DB::select(' SELECT seek_trainings.id, field_seek_training.field_id, municipality_seek_training.municipality_id
FROM seek_trainings
JOIN field_seek_training ON seek_trainings.id = field_seek_training.seek_training_id
JOIN municipality_seek_training ON seek_trainings.id = municipality_seek_training.seek_training_id
WHERE field_seek_training.field_id in(' . implode(',', $fields) . ')
AND municipality_seek_training.municipality_id in (' . implode(',', $municipality_id) . ')
group by seek_trainings.id
');
foreach ($select as $instance) {
$seek_training_filtered = new \stdClass();
$seek_training_instance = SeekTraining::find($instance->id);
$seek_training_field = Field::find($instance->field_id);
$seek_training_municipality = Municipality::find($instance->municipality_id);
$training_terms = DB::select('SELECT terms.name FROM seek_training_term JOIN terms ON terms.id = seek_training_term.term_id WHERE seek_training_id = ' . $instance->id);
$seek_training_terms_array = [];
foreach ($training_terms as $term) {
$seek_training_terms_array[] = $term->name;
}
$seek_training_filtered->id = $seek_training_instance->id;
$seek_training_filtered->header = $seek_training_instance->name;
$seek_training_filtered->description = $seek_training_instance->description;
$seek_training_filtered->file = $seek_training_instance->file;
$seek_training_filtered->link = $seek_training_instance->link;
$seek_training_filtered->per = $seek_training_instance->per;
$seek_training_filtered->terms = implode(',', $seek_training_terms_array);
$seek_training_filtered->contact = $seek_training_instance->contact;
$seek_training_filtered->quantity = $seek_training_instance->quantity;
$seek_training_filtered->field = $seek_training_field->name;
$seek_training_filtered->municipality = $seek_training_municipality->name;
$seek_training_filtered->isAdmin = !(!Auth::user() || Auth::user()->role == 100);
$seek_training_filtered_array[] = $seek_training_filtered;
unset($seek_training_filtered);
unset($seek_training_months_array);
unset($seek_training_terms_array);
}
return response(json_encode($seek_training_filtered_array), 200)->header('Content-Type', 'application/json');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$municipalities = Municipality::all();
return view('poi.region.index')->with('municipalities', $municipalities);
}
