Example #1
0
 public function setPriority()
 {
     $first_day = SelectList::where('subject', '<', 20000)->get();
     $second_day = SelectList::where('subject', '>', 20000)->get();
     foreach ($first_day as $first_day_people) {
         $user_name = RegisterDetails::where('phone', $first_day_people->phone)->get(['account_id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->account_id)) {
                 RegisterSubjects::where('reg_subject_1', $first_day_people->subject)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
             }
         }
         $user_name = RegisterUsers::where('pid', $first_day_people->pid)->get(['id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->account_id)) {
                 RegisterSubjects::where('reg_subject_1', $first_day_people->subject)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
             }
         }
         $user_name = RegisterDetails::where('name', $first_day_people->name)->get(['account_id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->account_id)) {
                 RegisterSubjects::where('reg_subject_1', $first_day_people->subject)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
             }
         }
         $user_name = RegisterUsers::where('email', $first_day_people->email)->get(['id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->id)) {
                 RegisterSubjects::where('reg_subject_1', $first_day_people->subject)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
             }
         }
     }
     foreach ($second_day as $second_day_people) {
         $user_name = RegisterDetails::where('phone', $second_day_people->phone)->get(['account_id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->account_id)) {
                 if ($second_day_people->subject == 40005) {
                     RegisterSubjects2::where('reg_subject_2', '>=', 20002)->where('reg_subject_2', '<=', 20003)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
                 } else {
                     RegisterSubjects2::where('reg_subject_2', $second_day_people->subject)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
                 }
             }
         }
         $user_name = RegisterUsers::where('pid', $second_day_people->pid)->get(['id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->id)) {
                 if ($second_day_people->subject == 40005) {
                     RegisterSubjects2::where('reg_subject_2', '>=', 20002)->where('reg_subject_2', '<=', 20003)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
                 } else {
                     RegisterSubjects2::where('reg_subject_2', $second_day_people->subject)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
                 }
             }
         }
         $user_name = RegisterDetails::where('name', $second_day_people->name)->get(['account_id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->account_id)) {
                 if ($second_day_people->subject == 40005) {
                     RegisterSubjects2::where('reg_subject_2', '>=', 20002)->where('reg_subject_2', '<=', 20003)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
                 } else {
                     RegisterSubjects2::where('reg_subject_2', $second_day_people->subject)->where('account_id', $user_name[0]->account_id)->update(['priority' => '1']);
                 }
             }
         }
         $user_name = RegisterUsers::where('email', $second_day_people->email)->get(['id']);
         if (isset($user_name[0])) {
             if (isset($user_name[0]->id)) {
                 if ($second_day_people->subject == 40005) {
                     RegisterSubjects2::where('reg_subject_2', '>=', 20002)->where('reg_subject_2', '<=', 20003)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
                 } else {
                     RegisterSubjects2::where('reg_subject_2', $second_day_people->subject)->where('account_id', $user_name[0]->id)->update(['priority' => '1']);
                 }
             }
         }
     }
     return 'SUCCESS';
 }
Example #2
0
 public function PriorityMemberQuery()
 {
     $select_count = SelectList::all()->count();
     $select_list = SelectList::all();
     $count = 0;
     for ($i = 0; $i < $select_count; $i++) {
         if (isset($select_list[0]->pid)) {
             $count += RegisterUsers::where('pid', $select_list[0]->pid)->take(1)->count();
         } elseif (isset($select_list[0]->email)) {
             $count += RegisterUsers::where('email', $select_list[0]->email)->take(1)->count();
         } elseif (isset($select_list[0]->phone)) {
             $count += RegisterDetails::where('phone', $select_list[0]->phone)->take(1)->count();
         } elseif (isset($select_list[0]->phone)) {
             $count += RegisterDetails::where('name', $select_list[0]->name)->take(1)->count();
         }
     }
 }