PHP Schedule::create方法代码示例

 public function run()
 {
     DB::table('schedules')->delete();
     Schedule::create(array('start_time' => '18:00:00', 'end_time' => '6:00:00', 'brightness' => 20, 'start_date' => '2014-04-10', 'end_date' => '2014-04-20'));
     Schedule::create(array('start_time' => '17:00:00', 'end_time' => '5:30:00', 'brightness' => 80, 'start_date' => '2014-04-01', 'end_date' => '2014-04-02'));
     Schedule::create(array('start_time' => '17:30:00', 'end_time' => '6:00:00', 'brightness' => 80, 'start_date' => '2014-03-27', 'end_date' => '2014-03-28'));
 }

 public function run()
 {
     $faker = Faker::create();
     foreach (range(1, 10) as $index) {
         Schedule::create(['from_time' => $faker->time($format = 'H:i:s', $max = 'now'), 'to_time' => $faker->time($format = 'H:i:s', $max = 'now'), 'group_id' => rand(1, 10), 'day' => rand(1, 7)]);
     }
 }

 public function run()
 {
     $faker = Faker::create();
     foreach (range(1, 10) as $index) {
         Schedule::create([]);
     }
 }

 /**
  * Update a specific schedule for a campaign
  * @param string $accessToken - Constant Contact OAuth2 access token
  * @param int $campaignId - Campaign id to be scheduled
  * @param Schedule $schedule - Schedule to retrieve
  * @return Schedule
  */
 public function updateSchedule($accessToken, $campaignId, Schedule $schedule)
 {
     $baseUrl = Config::get('endpoints.base_url') . sprintf(Config::get('endpoints.campaign_schedule'), $campaignId, $schedule->id);
     $url = $this->buildUrl($baseUrl);
     $response = parent::getRestClient()->put($url, parent::getHeaders($accessToken), $schedule->toJson());
     return Schedule::create(json_decode($response->body, true));
 }

 /**
  * Store a newly created schedule in storage.
  *
  * @return Response
  */
 public function store()
 {
     $validator = Validator::make($data = Input::all(), Schedule::$rules, Schedule::$messages);
     if ($validator->fails()) {
         return Redirect::back()->withErrors($validator)->withInput();
     }
     Schedule::create($data);
     return Redirect::route('schedules.index');
 }

function schedule_controller()
{
    global $session, $route, $mysqli, $user;
    $result = false;
    require "Modules/schedule/schedule_model.php";
    $schedule = new Schedule($mysqli, $user->get_timezone($session['userid']));
    if ($route->format == 'html') {
        if ($route->action == "view" && $session['write']) {
            $result = view("Modules/schedule/Views/schedule_view.php", array());
        }
        if ($route->action == 'api') {
            $result = view("Modules/schedule/Views/schedule_api.php", array());
        }
    }
    if ($route->format == 'json') {
        if ($route->action == 'list') {
            if ($session['userid'] > 0 && $session['userid'] && $session['read']) {
                $result = $schedule->get_list($session['userid']);
            }
        } elseif ($route->action == "create") {
            if ($session['userid'] > 0 && $session['write']) {
                $result = $schedule->create($session['userid']);
            }
        } else {
            $scheduleid = (int) get('id');
            if ($schedule->exist($scheduleid)) {
                $scheduleget = $schedule->get($scheduleid);
                // if public or belongs to user
                if ($session['read'] && ($scheduleget['public'] || $session['userid'] > 0 && $scheduleget['userid'] == $session['userid'])) {
                    if ($route->action == "get") {
                        $result = $scheduleget;
                    }
                    if ($route->action == "expression") {
                        $result = $schedule->get_expression($scheduleid);
                    }
                    if ($route->action == "test") {
                        $result = $schedule->test_expression($scheduleid);
                    }
                }
                // if public
                if (isset($session['write']) && $session['write'] && $session['userid'] > 0 && $scheduleget['userid'] == $session['userid']) {
                    if ($route->action == "delete") {
                        $result = $schedule->delete($scheduleid);
                    }
                    if ($route->action == 'set') {
                        $result = $schedule->set_fields($scheduleid, get('fields'));
                    }
                }
            } else {
                $result = array('success' => false, 'message' => 'Schedule does not exist');
            }
        }
    }
    return array('content' => $result);
}

 public function run()
 {
     DB::table('schedules')->delete();
     Schedule::create(array('date' => '2015-08-27', 'period' => 0, 'doctor_id' => 1));
     Schedule::create(array('date' => '2015-08-27', 'period' => 1, 'doctor_id' => 1));
     Schedule::create(array('date' => '2015-08-28', 'period' => 0, 'doctor_id' => 1));
     Schedule::create(array('date' => '2015-08-27', 'period' => 0, 'doctor_id' => 2));
     Schedule::create(array('date' => '2015-08-28', 'period' => 1, 'doctor_id' => 2));
     Schedule::create(array('date' => '2015-08-27', 'period' => 1, 'doctor_id' => 3));
     Schedule::create(array('date' => '2015-08-28', 'period' => 0, 'doctor_id' => 3));
     Schedule::create(array('date' => '2015-08-29', 'period' => 0, 'doctor_id' => 3));
 }

 public function run()
 {
     Eloquent::unguard();
     /**
      * Clearing table
      */
     DB::table('schedules')->delete();
     /**
      * Creating event schedules
      */
     Schedule::create(array('schdl_title' => 'Example event template', 'schdl_time_preparation_start' => '20:00', 'schdl_password' => Hash::make('password'), 'evnt_id' => '1', 'schdl_is_template' => '1'));
     /* 
      * Creating tasks
      */
     Schedule::create(array('schdl_title' => 'Example task', 'schdl_due_date' => '2015-04-01', 'schdl_is_template' => '0'));
     /**
      * Reporting result to console
      */
     $this->command->info('One event schedule for event ID 1 and one example task created on 01.04.2015.');
 }

 protected function insert_schedules()
 {
     $doctors = Doctor::all();
     foreach ($doctors as $doctor) {
         $count = rand(300, 500);
         while ($count--) {
             $date = $this->get_random_date();
             $schedules = Schedule::where('date', $date)->where('doctor_id', $doctor->id)->get();
             if ($schedules->count()) {
                 continue;
             }
             // 添加早上排班
             if (rand(0, 1)) {
                 Schedule::create(['date' => $date, 'period' => 0, 'doctor_id' => $doctor->id]);
             }
             // 添加下午排班
             if (rand(0, 1)) {
                 Schedule::create(['date' => $date, 'period' => 1, 'doctor_id' => $doctor->id]);
             }
         }
     }
 }

 public function createSchedule()
 {
     if (!empty($_POST['taskdate']) && !empty($_POST['cid']) && !empty($_POST['empid'])) {
         $thisclientproduct = Cproduct::find_by_id((int) preg_replace('#[^0-9]#i', '', $_POST['cid']));
         $thisemployee = Employee::find_by_id((int) preg_replace('#[^0-9]#i', '', $_POST['empid']));
         $thisSchedule = new Schedule();
         $thisSchedule->emp_id = $_POST['empid'];
         $thisSchedule->emp_name = $thisemployee->emp_fname . " " . $thisemployee->emp_lname;
         $thisSchedule->client_id = "   ";
         $thisSchedule->prod_id = $_POST['cid'];
         $thisSchedule->prod_name = $thisclientproduct->prod_name;
         $thisSchedule->s_date = $_POST['taskdate'];
         //$thisSchedule->s_time_in       ;
         //$thisSchedule->s_time_out;
         $thisSchedule->issue = $_POST["tissue"];
         $thisSchedule->datecreated = date("Y-m-d H:i:s");
         $thisSchedule->maint_type = $_POST['mtype'];
         $msg = "Maintenance task alert for {$thisclientproduct->prod_name} at";
         $msg .= $thisclientproduct->install_location . "," . $thisclientproduct->branch;
         $msg .= "\r\n issue:" . $_POST["tissue"];
         if ($thisSchedule->create()) {
             sendSms($thisemployee->emp_phone, $msg);
             return true;
         } else {
             return false;
         }
     }
 }

<?php

require_once 'core/init.php';
$member_role = $_SESSION['roles'];
if (in_array("Laboratory Administrator", $member_role)) {
} else {
    header('location:restricted_page.php');
}
$start_date = $_POST["sem_start_date"];
$end_date = $_POST["sem_end_date"];
if (strtotime($start_date) < strtotime($end_date)) {
    $data = array("schedule_id" => null, "semester_no" => $_POST["semester"], "academic_year" => $_POST["academic_year"], "schedule_start_date" => $_POST["sem_start_date"], "schedule_end_date" => $_POST["sem_end_date"]);
    $newSchedule = new Schedule();
    $newSchedule->create($data);
    if ($newSchedule->add()) {
        echo "You have successfully added a schedule !";
    } else {
        echo "Schedule creation was unsuccessful !";
    }
} else {
    echo "Schedule start date must be less than schedule end date !!";
}

 public static function getAllSchedules()
 {
     $result = DB::getInstance()->directSelect("SELECT * FROM schedule;");
     $schedules = array();
     if (count($result) == 0) {
         return null;
     }
     foreach ($result as $key => $value) {
         $schedule = array("schedule_id" => $value["schedule_id"], "semester_no" => $value["semester_no"], "academic_year" => $value["academic_year"], "schedule_start_date" => $value["schedule_start_date"], "schedule_end_date" => $value["schedule_end_date"]);
         $newSchedule = new Schedule();
         $newSchedule->create($schedule);
         $schedules[] = $newSchedule;
     }
     return $schedules;
 }

 public function schedule($elements = array())
 {
     return Schedule::create($elements);
 }

 public function user_of_run($start)
 {
     $query = new Query('USER_OF_RUN', $this->dbh);
     $query->where('STARTDATE', '>', $start);
     $query->order('STARTDATE');
     $result = $query->get('STARTDATE,ENDDATE,USERID,NUM_OF_RUN_ID');
     foreach ($result as $row) {
         Schedule::create(['start_date' => $row['STARTDATE'], 'end_date' => $row['ENDDATE'], 'employee_id' => $row['USERID'], 'weekly_schedule_id' => $row['NUM_OF_RUN_ID']]);
     }
     $size = count($result);
     $this->num_data += $size;
     return $size > 0 ? $result[$size - 1]['STARTDATE'] : $start;
 }

 public function createSchedule_Detail($id = "")
 {
     header('Content-Type: application/json');
     $data = json_decode(stripslashes($_POST['data']));
     foreach ($data as $d => $value) {
         $cntdata[] = $d;
     }
     if (!empty($data->taskdate) && !empty($data->cid) && !empty($data->empid)) {
         $issuefield = get_object_vars($data);
         // get the properties of an object into an array
         $thisclientproduct = Cproduct::find_by_id((int) preg_replace('#[^0-9]#i', '', $data->cid));
         $thisemployee = Employee::find_by_id((int) preg_replace('#[^0-9]#i', '', $data->empid));
         $thisSchedule = new Schedule();
         $thisSchedule->emp_id = $issuefield['empid'];
         $thisSchedule->emp_name = $thisemployee->emp_fname . " " . $thisemployee->emp_lname;
         $thisSchedule->client_id = $thisclientproduct->client_id;
         $thisClient = Client::find_by_id($thisclientproduct->client_id);
         //print_r($thisclientproduct);
         //print_r($thisClient);
         //print_r($thisemployee);
         $thisSchedule->prod_id = $issuefield['cid'];
         $thisSchedule->prod_name = $thisclientproduct->prod_name;
         /**
          * this is to check if ticket
          * is in existence
          */
         //print_r($theUser);
         global $session;
         //$partTicket                             =   ($id!="") ? Ticket::find_by_id($id) : ""; // get the ticket to get details needed for sending mail
         $theUser = Employee::find_by_id($_SESSION["emp_ident"]);
         // get cse detail to retrieve email
         $thisSchedule->s_date = $data->taskdate;
         /**
          * section to configure and setup sms and email message 
          */
         $issue = array();
         $objIssue = Issue::find_all();
         // creating the issue log object
         $message_issue = "";
         //$thisemployee->emp_phone
         foreach ($objIssue as $objI) {
             foreach ($issuefield as $key => $value) {
                 if ($key == $objI->issue_accronym) {
                     $message_issue .= $objI->issue_name . ", ";
                 }
             }
         }
         $cemail = array();
         $cemail = isset($_POST['cemail']) && !empty($_POST['cemail']) ? explode(",", $_POST['cemail']) : array('iarowolo@robertjohsonholdings.com');
         array_push($cemail, $thisemployee->emp_email, is_array($partTicket) ? $partTicket->contact_email : "", $theUser->emp_email, $thisClient->email);
         //print_r($cemail);
         $thisSchedule->status = "Open";
         $thisSchedule->issue = $message_issue;
         $thisSchedule->datecreated = date("Y-m-d H:i:s");
         $thisSchedule->maint_type = $_POST['mtype'];
         $subject = "Maintenance Alert";
         $smsmsg = "Maintenance alert for {$thisclientproduct->prod_name} at";
         $smsmsg .= $thisclientproduct->install_location . "," . $thisclientproduct->branch;
         $smsmsg .= "\r\n Issue:" . $message_issue . "\r\n";
         $smsmsg .= "\r\n Comment:" . $issuefield["tissue"] . "\r\n";
         $msg = "<h3>Maintenance Detail</h3> <hr />";
         $msg .= "<p><strong>Machine: </strong>{$thisclientproduct->prod_name} </p>";
         $msg .= "<p><strong>Client: </strong> {$thisClient->name}</p>";
         $msg .= "<p><strong>Location: </strong>{$thisclientproduct->install_location} {$thisclientproduct->branch} {$thisclientproduct->install_city} </p>";
         $msg .= "<p><strong>Issues: </strong>" . $message_issue . "</p>";
         $msg .= "<p><strong>Comment: </strong>" . $issuefield["tissue"] . "</p>";
         $msg .= "<br /><br /> <h4>Technician Details</h4> <hr />";
         $msg .= "<p><strong>Name: </strong>" . $thisemployee->emp_fname . " " . $thisemployee->emp_lname . "</p>";
         $msg .= "<p><strong>Email: </strong>" . $thisemployee->emp_email . "</p>";
         $msg .= "<p><strong>Telephone: </strong>" . $thisemployee->emp_phone . "</p>";
         $msg .= "<br /><br /><h4>Scheduled Date</h4> <hr />";
         $msg .= "<p><strong>{$thisSchedule->s_date}</strong></p><br /><br /><br /><br />";
         /**
          * the transaction log is created
          * to ensure that the product already 
          * has history and cannot be deleted
          */
         $Tlog2 = new Transaction();
         $Tlog2->com_id = $thisclientproduct->main_id;
         $Tlog2->trans_type = "TASK ASSIGNMENT";
         $Tlog2->trans_description = $issuefield["mtype"] . " task assigned to " . $thisemployee->emp_fname . " " . $thisemployee->emp_lname . "";
         $Tlog2->datecreated = date("Y-m-d H:i:s");
         $Tlog2->user_id = $_SESSION['emp_ident'];
         // print_r($msg);
         if ($thisSchedule->create()) {
             $Tlog2->create();
             /**
              * this section is needed
              * to post issues to database table
              * issuelog for statistical analysis on
              * issues
              */
             //$thisemployee->emp_phone
             foreach ($objIssue as $objI) {
                 foreach ($issuefield as $key => $value) {
                     if ($key == $objI->issue_accronym) {
                         $issueLog = new Issuelog();
                         $issueLog->ticket_id = 0;
                         $issueLog->issue_id = $objI->id;
                         $issueLog->issue_accronym = $objI->issue_accronym;
//.........这里部分代码省略.........