Ejemplo n.º 1
0
 /**
  * @before _secure, _vendor, _admin
  */
 public function payments()
 {
     $this->seo(array("title" => "Vendor Profile", "view" => $this->getLayoutView()));
     $view = $this->getActionView();
     $where["organization_id = ?"] = $this->organization->id;
     $period = RequestMethods::get("period", "total");
     switch ($period) {
         case 'year':
             $year = strftime("%Y-%m-%d", strtotime('-1 year'));
             $where["created > ?"] = $year;
             break;
         case 'week':
             $week = strftime("%Y-%m-%d", strtotime('-1 year'));
             $where["created > ?"] = $week;
             break;
         case 'day':
             $day = strftime("%Y-%m-%d", strtotime('-1 day'));
             $where["created > ?"] = $day;
             break;
     }
     $centres = Centre::all(array("organization_id = ?" => $this->organization->id), array("id", "location_id"));
     $revenue = 0;
     $cash = 0;
     $online = 0;
     $appointments = Appointment::all($where);
     foreach ($appointments as $a) {
         $order = Order::first(array("id = ?" => $a->order_id), array("amount"));
         $revenue += $order->amount;
         switch ($order->mode) {
             case 'cash':
                 $cash += $order->amount;
                 break;
             default:
                 $online += $order->amount;
                 break;
         }
     }
     if (RequestMethods::get("action") == "invoice") {
         $this->paymentsInvoice($this->organization, $appointments, $revenue, $cash, $online, "show");
     }
     $view->set("appointments", $appointments);
     $view->set("period", $period);
     $view->set("revenue", $revenue);
     $view->set("cash", $cash);
     $view->set("online", $online);
     $view->set("centres", $centres);
 }
Ejemplo n.º 2
0
 /**
  * @before _secure, _vendor
  */
 public function create()
 {
     $this->seo(array("title" => "Create runner", "view" => $this->getLayoutView()));
     $view = $this->getActionView();
     $msg = "";
     $centres = Centre::all(array("organization_id = ?" => $this->organization->id), array("id", "location_id"));
     $upload = function ($key) {
         if (isset($_FILES["image"]["name"][$key])) {
             $file = $_FILES["image"];
             $path = APP_PATH . "/public/assets/uploads/images/";
             $extension = pathinfo($file["name"][$key], PATHINFO_EXTENSION);
             if (!preg_match("/^(jpe?g|gif|png|bmp)\$/", $extension)) {
                 return false;
             }
             $filename = uniqid() . ".{$extension}";
             if (move_uploaded_file($file["tmp_name"][$key], $path . $filename)) {
                 return $filename;
             } else {
                 return FALSE;
             }
         } else {
             return false;
         }
     };
     if (RequestMethods::post("phone")) {
         $phone = RequestMethods::post("phone");
         $name = RequestMethods::post("name");
         $centre_id = RequestMethods::post("centre_id");
         foreach ($phone as $key => $value) {
             if (!empty($value)) {
                 $exist = User::first(array("phone = ?" => $phone[$key]), array("id"));
                 $img = $upload($key);
                 if (!$img) {
                     $msg = 'Not a vaild image';
                 } else {
                     if ($exist) {
                         $msg = 'Phone number already exists';
                     }
                 }
                 if (!$exist && $img) {
                     $user = new User(array("name" => $name[$key], "email" => "", "phone" => $phone[$key], "password" => sha1(rand(100000, 9999999)), "gender" => $gender[$key], "birthday" => "", "live" => true));
                     $user->save();
                     foreach ($centre_id[$key] as $k => $v) {
                         $runner = new Member(array("user_id" => $user->id, "organization_id" => $this->organization->id, "centre_id" => $v, "designation" => "runner", "image" => $img, "live" => true));
                         $runner->save();
                     }
                     $msg = "Runner Created Successfully";
                 } else {
                     $msg .= ", Not all were added";
                 }
             }
         }
         $view->set("message", $msg);
     }
     $locations = array();
     foreach ($centres as $c) {
         $l = Location::first(array("id = ?" => $c->location_id), array("area_id"));
         $a = Area::first(array("id = ?" => $l->area_id), array("name", "id"));
         $data = array("id" => $c->id, "name" => $a->name);
         $data = ArrayMethods::toObject($data);
         $locations[$c->id] = $data;
     }
     $view->set("centres", $locations);
 }
Ejemplo n.º 3
0
 /**
  * Crea un nou grup
  */
 public function nouGrup()
 {
     if (Input::has('nom')) {
         $grup = new Grup();
         $nom = Input::get('nom');
         $nom = strip_tags($nom);
         $nom = trim($nom);
         $descripcio = Input::get('descripcio');
         $descripcio = strip_tags($descripcio);
         $descripcio = trim($descripcio);
         $aula = Input::get('aula');
         $aula = strip_tags($aula);
         $aula = trim($aula);
         $centre = Input::get('centre');
         $validator = Validator::make(array('nombre' => $nom, 'descripción' => $descripcio, 'aula' => $aula, 'centro' => $centre), array('nombre' => array('required', 'max:60'), 'descripción' => array('max:255'), 'aula' => array('max:25'), 'centro' => array('max:150')));
         if ($validator->fails()) {
             return Redirect::route('grup.nou')->withErrors($validator);
         }
         $grup->nom_grup = $nom;
         $grup->descripcio_grup = $descripcio;
         $grup->aula = $aula;
         $grup->centre_nom_centre = $centre;
         $grup->curs_nom_curs = '2013-2014';
         $slug = $nom . uniqid();
         $grup->slug_grup = $slug;
         $emaillog = Auth::user()->email_estudiant;
         $grup->estudiant_email_estudiant = $emaillog;
         $grup->save();
         try {
             $estudiant = Estudiant::findOrFail($emaillog);
         } catch (ModelNotFoundException $e) {
             return Redirect::route('grups.meus');
         }
         $estudiant->matricularEstudiant($slug);
         return Redirect::route('assignatures.nou', array('slug' => $slug));
     } else {
         $centres = Centre::all();
         $this->layout->title = 'Workshome - Nuevo grupo';
         $this->layout->description = 'Crear nuevo grupo';
         $this->layout->content = View::make('grups/nou', array('centres' => $centres));
     }
 }
 public function test()
 {
     $output = '<table>';
     foreach (Centre::all() as $centre) {
         $output .= '<tr><td>' . $centre->name . '</td><td>' . $centre->address . '</td><td>' . $centre->city->name . '</td><td>' . $centre->city->state->name . '</td><td>' . $centre->pincode . '</td></tr>';
     }
     $output .= '</table>';
     return $output;
     return PDF::loadView('admin.certi')->stream('certi_final.pdf');
     //        return View::make('admin.centrecerti');
     //        $pdf = PDF::loadView('admin.centrecerti');
     //        return $pdf->stream('certi.pdf');
     $out = '<table>';
     $out .= '<tr><td>Name</td><td>Address</td><td>City</td><td>Pincode</td></tr>';
     $count = 0;
     foreach (Centre::orderBy('city_id')->get() as $centre) {
         $out .= '<tr><td>' . $centre->name . '</td><td>' . $centre->address . '</td><td>' . $centre->city->name . '</td><td>' . $centre->pincode . '</td></tr>';
     }
     //        foreach (DB::table('results_2015')->where('rank','<','51')->where('kv',1)->get() as $user)
     //        {
     //            if(User::where('roll',$user->roll)->count()) {
     //                $users = User::where('roll',$user->roll)->first();
     //                if($users->status == 3 || $users->status == 5) {
     ////                    dd($users);
     //                    $out .= '<tr><td>'.$user->rank.'</td><td>'.$user->roll.'</td><td>'.$user->mobile.'</td><td>'.$users->name1.'</td><td>'.$users->name2.'</td><td>'.$user->path.'</td><td></td><td></td><td></td><td></td><td></td><td></td><td>'.$users->squad.'</td></tr>';
     //                }
     //                else {
     //                    try {
     //                        $out .= '<tr><td>'.$user->rank.'</td><td>'.$user->roll.'</td><td>'.$user->mobile.'</td><td>'.$users->name1.'</td><td>'.$users->name2.'</td><td>'.$users->school->name.'</td><td>'.$users->city->name.'</td><td>'.$users->school->address.'</td><td>'.$users->school->pincode.'</td><td>'.$users->school->contact.'</td><td>'.$users->contact1.'</td><td>'.$users->contact2.'</td><td>'.$users->squad.'</td></tr>';
     //                    }catch (Exception $e) {
     //                        return var_dump($users);
     //                    }
     //                }
     ////                $count++;
     //            }
     //        }
     //        return $count;
     return $out . '</table>';
     $pdf = PDF::loadView('admin.certi');
     return $pdf->stream('certi.pdf');
     $det = '<table>';
     foreach (City::orderBy('state_id')->get() as $city) {
         $count = User::whereCityId($city->id)->count();
         if ($count) {
             $det .= '<tr><td>' . $city->name . '</td><td>' . $city->state->name . '</td><td>' . $count . '</td></tr>';
         }
     }
     $det .= '</table>';
     return $det;
     //        $list = '<table>';
     //        foreach(DB::table('results_2015')->where('rank','<','27')->where('kv','!=',1)->where('roll','LIKE',"H%")->get() as $res)
     //        {
     //            $user = User::whereRoll($res->roll)->first();
     //            if(!$user) {
     //                $name1 = 'User1';
     //                $name2 = 'User2';
     //            }
     //            else {
     //                $name1 = $user->name1;
     //                $name2 = $user->name2;
     //            }
     //            $list .= '<tr><td>'.$res->rank.'</td><td>'.$res->roll.'</td><td>'.$name1.'</td><td>'.$name2.'</td><td>'.$res->mobile.'</td><td>'.$res->path.'</td></tr>';
     //        }
     //        $list .= '</table>';
     //        return $list;
     //        $rolls = array('HE53600040','HE53600004','HE53600027','HE53600022','HE53600023','HE53600002','HE53600005','HE53600003','HE53600006','HE53600034','HE53600033','HE53600037','HE53600001','HE53600039','HE53600038','HE53600018','HE53600011','HE53600010','HE53600009','HE53600008','HE53600007','HE53600025','HE53600026','HE53600020','HE53600019','HE53600016','HE53600017','HE53600015','HE53600014','HE53600013','HE53600012');
     //        $list = '';
     //        foreach($rolls as $roll)
     //        {
     //            $old = User::whereRoll($roll)->first();
     //            $user = $old->replicate();
     //            $user->squad = 'JUNIOR';
     //            $lastroll = User::withTrashed()->where('roll', 'LIKE', "%JE5360%")->count();
     //            $roll = 'JE5360'.str_pad(strval($lastroll + 1), 4, "0", STR_PAD_LEFT);
     //            $user->roll = $roll;
     //            $user->comments = 'Change squad';
     //            $user->push();
     //            $list .= $old->roll.'  '.$user->roll.'<br>';
     //        }
     //        return $list;
     $user = User::whereRoll('HE52530018')->first();
     return $user->roll . '<br>' . Crypt::decrypt($user->result_pass) . '<br>' . $user->name1 . '<br>' . $user->name2;
     foreach (User::where('city_id', 21)->where('paid', 1)->get() as $user) {
         $password = str_random(6);
         $school = $user->school;
         $user->password = Hash::make($password);
         $user->save();
         if ($user->email1 !== "") {
             Queue::push(function ($job) use($user, $password, $school) {
                 Mail::send('emails.offline', array('user' => $user, 'school' => $school, 'password' => $password, 'name' => $user->name1), function ($message) use($user) {
                     $message->to($user->email1, $user->name1)->subject('Technothlon Registration Details');
                 });
                 $job->delete;
             });
         }
         if ($user->email1 !== "") {
             Queue::push(function ($job) use($user, $password, $school) {
                 Mail::send('emails.offline', array('user' => $user, 'school' => $school, 'password' => $password, 'name' => $user->name2), function ($message) use($user) {
                     $message->to($user->email2, $user->name2)->subject('Technothlon Registration Details');
                 });
                 $job->delete;
             });
         }
     }
     return View::make('emails.kvroll');
     return $pdf = PDF::loadView('technopedia.onlineadmitcard')->stream('admit-cards/users/' . Auth::user()->get()->roll . '.pdf');
     return View::make('technopedia.onlineadmitcard');
     $schools = '';
     foreach (Centre::all() as $centre) {
         $count = User::where('centre_id', $centre->id)->count();
         $schools .= $count . ' ' . ($centre->strength - $centre->left) . ' ' . $centre->id;
     }
     return $schools;
     foreach (School::where('verified', 2)->get() as $school) {
         $junior = User::where('school_id', $school->id)->where('squad', 'JUNIOR')->count();
         $hauts = User::where('school_id', $school->id)->where('squad', 'HAUTS')->count();
         $schools .= $school->name . '<br>' . $school->address . '<br>' . $school->city->name . ' Pin: ' . $school->pincode . '<br>' . $school->city->state->name . '<br>Ph.: ' . $school->contact . '<br>Junior:' . $junior . ' Hauts: ' . $hauts . '<br><br>';
     }
     return $schools;
     //        return View::make('admin.test');
 }
Ejemplo n.º 5
0
 /**
  * @before _secure, _admin
  */
 public function unverified()
 {
     $this->seo(array("title" => "Unverified Labs", "view" => $this->getLayoutView()));
     $view = $this->getActionView();
     $date = RequestMethods::get("date", date('Y-m-d', strtotime("now")));
     $live = RequestMethods::get("live", 0);
     $centres = Centre::all(array("live = ?" => $live, "created LIKE ?" => "%{$date}%"), array("id", "location_id", "created", "organization_id", "live", "user_id"));
     $view->set("centres", $centres);
     $view->set("date", $date);
     $view->set("live", $live);
 }
Ejemplo n.º 6
0
 /**
  * Retorna tots els centres de la BBDD
  */
 public static function showCentres()
 {
     return Centre::all();
 }
Ejemplo n.º 7
0
 /**
  * @before _secure, _vendor
  */
 public function download()
 {
     $this->noview();
     $tests = Test::all(array("live = ?" => true), array("title"));
     $centres = Centre::all(array("organization_id = ?" => $this->organization->id), array("location_id"));
     $locations = array();
     foreach ($centres as $centre) {
         $loc = Location::first(array("id = ?" => $centre->location_id), array("city"));
         array_push($locations, $loc->city);
     }
     header('Content-Type: text/csv; charset=utf-8');
     header('Content-Disposition: attachment; filename=medicaltests.csv');
     // create a file pointer connected to the output stream
     $output = fopen('php://output', 'w');
     $first = array("Medical Test");
     $locations = array_unique($locations);
     foreach ($locations as $location) {
         array_push($first, "Price at " . $location);
     }
     fputcsv($output, $first);
     foreach ($tests as $test) {
         $data = array();
         array_push($data, $test->title);
         foreach ($locations as $location) {
             array_push($data, "");
         }
         fputcsv($output, $data);
     }
 }