PHP Time::createFromFormat方法代码示例

 /**
  * Add method
  *
  * @return void Redirects on successful add, renders view otherwise.
  */
 public function add()
 {
     if ($this->request->is('post')) {
         $data_array = array();
         for ($i = 0; $i < sizeof($this->request->data['date']); $i++) {
             $montant = $this->request->data['montant'][$i];
             if ($this->request->data['transfere'][$i] === 'Credit') {
                 $montant = $montant * -1;
             }
             //  $time = new Time($this->request->data['date'][$i]);
             $time = Time::createFromFormat('d/m/Y', $this->request->data['date'][$i]);
             $data_array[] = array('datoper' => $time, 'montant' => $montant, 'libelle' => $this->request->data['libelle'][$i], 'id_client' => $id = $this->Auth->user()['id_client'], 'id_type_compte' => trim(explode('-', $this->request->data['compte'][$i])[0]));
         }
         $entities = $this->Operations->newEntities($data_array);
         $this->set('entities', $entities);
         //debug($entities);
         $success = 0;
         $fail = 0;
         foreach ($entities as $entity) {
             // Save entity
             if ($this->Operations->save($entity)) {
                 $success++;
             } else {
                 $fail++;
             }
         }
         if ($success > 0) {
             if ($success == 1) {
                 $this->Flash->success('<i class="md-icon material-icons" style="color:white">&#xE876;</i> ' . $success . ' operation a bien été sauvegardée.');
             } else {
                 $this->Flash->success('<i class="md-icon material-icons" style="color:white">&#xE877;</i> ' . $success . ' operations ont bien été sauvegardées.');
             }
         }
         if ($fail > 0) {
             if ($fail == 1) {
                 $this->Flash->error('<i class="md-icon material-icons" style="color:white">&#xE000;</i> ' . $fail . ' operation n\'a pas pu être sauvegardé, Veuillez verifier l\'historique des opérations.');
             } else {
                 $this->Flash->error('<i class="md-icon material-icons" style="color:white">&#xE000;</i> ' . $fail . ' operations n\'ont pas pu être sauvegardés, Veuillez verifier l\'historique des opérations.');
             }
         }
     }
     //$this->autoRender = false ;
     return $this->redirect(['action' => 'index']);
     $this->set(compact('operation'));
     $this->set('_serialize', ['operation']);
 }

 /**
  * Handler method that applies before dispatch.
  *
  * @param \Cake\Event\Event $event The event instance.
  * @return mixed
  */
 public function handle(Event $event)
 {
     if (is_file(MAINTENANCE_CONFIG_FILE) && is_readable(MAINTENANCE_CONFIG_FILE)) {
         // stop event
         $event->stopPropagation();
         $request = $event->data['request'];
         $response = $event->data['response'];
         $config = (require MAINTENANCE_CONFIG_FILE);
         $viewClass = $config['viewClass'];
         $view = new $viewClass($request, $response);
         $view->templatePath($config['templatePath']);
         $view->template($config['templateFile']);
         $view->layout($config['templateLayout']);
         $view->set('startAt', \Cake\I18n\Time::createFromFormat('YmdHis', $config['startAt']));
         $view->set('endAt', \Cake\I18n\Time::createFromFormat('YmdHis', $config['endAt']));
         $response->body($view->render());
         return $response;
     }
 }

 /**
  * Edit method
  *
  * @param string|null $id Shipping id.
  * @return void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     $shipping = $this->Shippings->get($id, ['contain' => []]);
     if ($this->request->is(['patch', 'post', 'put'])) {
         if ($this->request->data['laycan_com'] != null) {
             $this->request->data['laycan_com'] = Time::createFromFormat('m/d/Y', $this->request->data['laycan_com'], 'UTC');
             $this->request->data['laycan_end'] = Time::createFromFormat('m/d/Y', $this->request->data['laycan_end'], 'UTC');
         }
         $shipping = $this->Shippings->patchEntity($shipping, $this->request->data);
         if ($this->Shippings->save($shipping)) {
             $this->Flash->success(__('The shipping has been saved.'));
             return $this->redirect(['controller' => 'Fixtures', 'action' => 'view', $shipping->fixture_id]);
         } else {
             $this->Flash->error(__('The shipping could not be saved. Please, try again.'));
         }
     }
     $fixtures = $this->Shippings->Fixtures->find('list', ['limit' => 200]);
     $this->set(compact('shipping', 'fixtures'));
     $this->set('_serialize', ['shipping']);
 }

 /**
  * Add method
  *
  * @return void Redirects on successful add, renders view otherwise.
  */
 public function add()
 {
     $fixture = $this->Fixtures->newEntity();
     if ($this->request->is('post')) {
         $this->request->data['cp_date'] = Time::createFromFormat('m/d/Y', $this->request->data['cp_date'], 'UTC');
         $this->request->data['period_st'] = Time::createFromFormat('m/d/Y', $this->request->data['period_st'], 'UTC');
         $this->request->data['period_nd'] = Time::createFromFormat('m/d/Y', $this->request->data['period_nd'], 'UTC');
         $fixture = $this->Fixtures->patchEntity($fixture, $this->request->data);
         if ($this->Fixtures->save($fixture)) {
             $this->Flash->success(__('The fixture has been saved.'));
             return $this->redirect(['action' => 'index']);
         } else {
             $this->Flash->error(__('The fixture could not be saved. Please, try again.'));
         }
     }
     $users = $this->Fixtures->Users->find('list', ['limit' => 200]);
     $pics = $this->Fixtures->Pics->find('list', ['limit' => 200]);
     $charterers = $this->Fixtures->Charterers->find('list', ['limit' => 200]);
     $shipowners = $this->Fixtures->Shipowners->find('list', ['limit' => 200]);
     $this->set(compact('fixture', 'users', 'pics', 'charterers', 'shipowners'));
     $this->set('_serialize', ['fixture']);
 }

 /**
  * Edit method
  *
  * @param string|null $id Calendar id.
  * @return \Cake\Network\Response|void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     $calendar = $this->Calendars->get($id);
     $this->loadModel('Shows');
     $show = $this->Shows->findById($calendar->show_id)->first();
     if (!$calendar) {
         $this->Flash->error(__('Event not found!'));
         return $this->redirect(['action' => 'index']);
     }
     if (!$this->UserPerm->checkShow($this->Auth->user('id'), $calendar->show_id, 'is_cal')) {
         $this->Flash->error(__('You do not have access to this show'));
         return $this->redirect(['action' => 'index']);
     }
     if ($show->is_active < 1) {
         $this->Flash->error(__('Sorry, this show is now closed.'));
         return $this->redirect(['action' => 'index']);
     }
     if ($this->request->is(['patch', 'post', 'put'])) {
         $time = Time::createFromFormat('Y-m-d', $this->request->data['date'], 'UTC');
         $this->request->data['date'] = $time;
         $d_worked = $time;
         $time = Time::createFromFormat('H:i', $this->request->data['start_time'], 'UTC');
         $this->request->data['start_time'] = $time;
         $time = Time::createFromFormat('H:i', $this->request->data['end_time'], 'UTC');
         $this->request->data['end_time'] = $time;
         $calendar = $this->Calendars->patchEntity($calendar, $this->request->data);
         if ($this->Calendars->save($calendar)) {
             $this->Flash->success(__('The event has been saved.'));
             return $this->redirect(['action' => 'view', $calendar->show_id]);
         } else {
             $this->Flash->error(__('The event could not be saved. Please, try again.'));
         }
     }
     $this->set('crumby', [["/", __("Dashboard")], ["/calendars/", __("Calendars")], ["/calendars/view/" . $show->id . "/" . date("Y") . "/" . date("m"), __("{0} Calendar", $show->name)], [null, __("Edit Event")]]);
     $shows = [$show->id => $show->name];
     $this->set(compact('calendar', 'shows'));
     $this->set('_serialize', ['calendar']);
 }

 public function filter()
 {
     $this->loadModel('Campuses');
     $campuses = $this->Campuses->find('list');
     $this->set('campuses', $campuses);
     if ($this->request->is('post')) {
         $data = $this->request->data;
         $order_date = Time::createFromFormat('d/m/Y', $data['order_date']);
         $menu = $this->Menus->find('all')->where(['menu_date' => $order_date, 'campus_id' => $data['campus_id']])->first();
         $orders = $this->Orders->find('all', ['contain' => ['Users', 'Rooms', 'Menus'], 'condition' => ['menu_id' => $menu->id]]);
         $this->set('orders', $orders);
     }
 }

 /**
  * Edit method
  *
  * @param string|null $id Show id.
  * @return void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     if (!$this->Auth->user('is_admin')) {
         $this->Flash->error(__('You may not edit shows'));
         return $this->redirect(['action' => 'index']);
     }
     $show = $this->Shows->get($id, ['contain' => []]);
     if ($this->request->is(['patch', 'post', 'put'])) {
         $time = Time::createFromFormat('Y-m-d', $this->request->data['end_date'], 'UTC');
         $this->request->data['end_date'] = $time;
         $show = $this->Shows->patchEntity($show, $this->request->data);
         if ($this->Shows->save($show)) {
             $this->Flash->success(__('The show has been saved.'));
             return $this->redirect(['action' => 'index']);
         } else {
             $this->Flash->error(__('The show could not be saved. Please, try again.'));
         }
     }
     $this->set('crumby', [["/", __("Dashboard")], ["/shows/", __("Shows")], ["/shows/view/" . $show->id, $show->name], [null, __("Edit Show")]]);
     $this->set(compact('show'));
     $this->set('_serialize', ['show']);
 }

 public function statement($id = null)
 {
     if (empty($this->request->query('begin_date'))) {
         $this->request->query['begin_date'] = Time::now()->subMonth()->format('d/m/Y');
     }
     if (empty($this->request->query('end_date'))) {
         $this->request->query['end_date'] = Time::now()->format('d/m/Y');
     }
     $begin_date = Time::createFromFormat('d/m/Y', $this->request->query('begin_date'));
     $end_date = Time::createFromFormat('d/m/Y', $this->request->query('end_date'));
     $this->request->data['begin_date'] = $begin_date->format('d/m/Y');
     $this->request->data['end_date'] = $end_date->format('d/m/Y');
     if ($begin_date->isToday()) {
         $begin_date->subHours(12);
     }
     $account = $this->Accounts->get($id);
     $account_statement = $this->Accounts->Statements->findByAccountId($id)->where(['Statements.created >=' => $begin_date, 'Statements.created <' => $end_date]);
     $total_statement = $account_statement->sumOf('value');
     $this->set(compact('account_statement', 'account', 'total_statement', 'begin_date', 'end_date'));
 }

 protected function getBirthdate($data)
 {
     if ($data['month'] === '0' || $data['day'] === '0' || $data['year'] === '1899') {
         return false;
     }
     $month = $data['month'];
     $day = $data['day'];
     $year = $data['year'];
     $format = 'm-d-Y';
     $time = $month . '-' . $day . '-' . $year;
     $birthdate = Time::createFromFormat($format, $time);
     return $birthdate;
 }

 /**
  * Edit method
  *
  * @param string|null $id Budget id.
  * @return void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     $budget = $this->Budgets->get($id, ['contain' => []]);
     $this->loadModel('Shows');
     $show = $this->Shows->findById($budget->show_id)->first();
     if (!$show) {
         $this->Flash->error(__('Show not found!'));
         return $this->redirect(['action' => 'index']);
     }
     if (!$this->UserPerm->checkShow($this->Auth->user('id'), $budget->show_id, 'is_budget')) {
         $this->Flash->error(__('You do not have access to this show'));
         return $this->redirect(['action' => 'index']);
     }
     if ($show->is_active < 1) {
         $this->Flash->error(__('Sorry, this show is now closed.'));
         return $this->redirect(['action' => 'index']);
     }
     if ($this->request->is(['patch', 'post', 'put'])) {
         $time = Time::createFromFormat('Y-m-d', $this->request->data['date'], 'UTC');
         $this->request->data['date'] = $time;
         $budget = $this->Budgets->patchEntity($budget, $this->request->data, ['fieldList' => ['vendor', 'category', 'description', 'price', 'date']]);
         if ($this->Budgets->save($budget)) {
             $this->Flash->success(__('The budget has been saved.'));
             return $this->redirect(['action' => 'view', $show->id]);
         } else {
             $this->Flash->error(__('The budget could not be saved. Please, try again.'));
         }
     }
     $vendq = $this->Budgets->find()->select(['vendor'])->distinct(['vendor'])->order(['vendor' => 'ASC']);
     $vend = json_encode($vendq->extract('vendor'));
     $catq = $this->Budgets->find()->select(['category'])->distinct(['category'])->order(['category' => 'ASC']);
     $cat = json_encode($catq->extract('category'));
     $this->set('crumby', [["/", __("Dashboard")], ["/budgets/", __("Budget Lists")], ["/budgets/view/" . $show->id, __("{0} Budget", $show->name)], [null, "Edit Expense"]]);
     $shows = [$show->id => $show->name];
     $this->set(compact('budget', 'shows', 'cat', 'vend'));
     $this->set('_serialize', ['budget']);
 }

 /**
  * Edit method
  *
  * @param string|null $id Task id.
  * @return \Cake\Network\Response|void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     $task = $this->Tasks->get($id, ['contain' => ['Users']]);
     $this->set('adminTask', $this->UserPerm->checkShow($this->Auth->user('id'), $task->show_id, 'is_task_admin'));
     $this->loadModel('Shows');
     $this->loadModel('ShowUserPerms');
     $show = $this->Shows->findById($task->show_id)->first();
     if (!$show) {
         $this->Flash->error(__('Show not found!'));
         return $this->redirect(['action' => 'index']);
     }
     if (!$this->UserPerm->checkShow($this->Auth->user('id'), $task->show_id, 'is_task_user') && !$this->UserPerm->checkShow($this->Auth->user('id'), $task->show_id, 'is_task_admin')) {
         $this->Flash->error(__('You do not have access to this show'));
         return $this->redirect(['action' => 'index']);
     }
     if (!$this->UserPerm->checkShow($this->Auth->user('id'), $task->show_id, 'is_task_admin') && $task->created_by != $this->Auth->user('id')) {
         $this->Flash->error(__('You may only edit your own tasks in this show'));
         return $this->redirect(['action' => 'index']);
     }
     if ($show->is_active < 1) {
         $this->Flash->error(__('Sorry, this show is now closed.'));
         return $this->redirect(['action' => 'index']);
     }
     if ($this->request->is(['patch', 'post', 'put'])) {
         $time = Time::createFromFormat('Y-m-d', $this->request->data['due'], 'UTC');
         $this->request->data['due'] = $time;
         $task = $this->Tasks->patchEntity($task, $this->request->data);
         if ($this->Tasks->save($task)) {
             $this->Flash->success(__('The task has been saved.'));
             return $this->redirect(['action' => 'view', $show->id]);
         } else {
             $this->Flash->error(__('The task could not be saved. Please, try again.'));
         }
     }
     $assignee = [$task->user->id => $task->user->first . " " . $task->user->last];
     $catq = $this->Tasks->find()->select(['category'])->distinct(['category'])->order(['category' => 'ASC']);
     $cat = json_encode($catq->extract('category'));
     $this->set('crumby', [["/", __("Dashboard")], ["/tasks/", __("Task Lists")], ["/tasks/view/" . $show->id, __("{0} Tasks", $show->name)], [null, __("Edit Task")]]);
     $shows = [$show->id => $show->name];
     $this->set(compact('task', 'shows', 'assignee', 'cat'));
     $this->set('_serialize', ['task']);
 }

 public function demoreset($really)
 {
     if ($really != "YES") {
         throw new InternalErrorException("Wrong Parameter Supplied, Please Try Again.");
     }
     if (!$this->params['really']) {
         throw new InternalErrorException("Wrong Parameter Supplied, Please Try Again.");
     }
     $this->out("<warning>You have really read what this does, and are totally ok with the fact that it is going to nuke all of your data!?!</warning>");
     $selection = $this->in('Nuke it All, Start Over?', ['Y', 'N'], 'N');
     if ($selection == "Y") {
         $conn = ConnectionManager::get('default');
         $this->loadModel('Users');
         $this->loadModel('Shows');
         $this->loadModel('Budgets');
         $this->loadModel('Payrolls');
         $this->loadModel('Messages');
         $this->loadModel('Calendars');
         //$this->loadModel('Tasks');
         $this->Tasks = TableRegistry::get('Tasks');
         $this->loadModel('ShowUserPerms');
         $this->out('Removing all records.');
         if ($this->Payrolls->deleteAll([1 => 1])) {
             $this->out(' Delete: Payrolls');
         }
         if ($this->Budgets->deleteAll([1 => 1])) {
             $this->out(' Delete: Budgets');
         }
         if ($this->Tasks->deleteAll([1 => 1])) {
             $this->out(' Delete: Tasks');
         }
         if ($this->Calendars->deleteAll([1 => 1])) {
             $this->out(' Delete: Calendars');
         }
         if ($this->ShowUserPerms->deleteAll([1 => 1])) {
             $this->out(' Delete: ShowUserPerms');
         }
         if ($this->Shows->deleteAll([1 => 1])) {
             $this->out(' Delete: Shows');
         }
         if ($this->Messages->deleteAll([1 => 1])) {
             $this->out(' Delete: Messages');
         }
         if ($this->Users->deleteAll([1 => 1])) {
             $this->out(' Delete: Users');
         }
         $this->out($this->nl(1) . 'Resetting AUTO_INCREMENT');
         $conn->execute('ALTER TABLE `users` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `payrolls` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `budgets` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `tasks` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `calendars` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `shows` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `messages` AUTO_INCREMENT = 1');
         $conn->execute('ALTER TABLE `show_user_perms` AUTO_INCREMENT = 1');
         $this->out($this->nl(1) . 'Creating Data:');
         $adminUser = $this->Users->newEntity(['username' => 'admin@tdtrac.com', 'password' => 'password', 'phone' => 1234567890, 'first' => 'Administrative', 'last' => 'User', 'is_notified' => 0, 'is_admin' => 1, 'time_zone' => 'America/Detroit']);
         $managerUser = $this->Users->newEntity(['username' => 'manager@tdtrac.com', 'password' => 'password', 'phone' => 1234567890, 'first' => 'Manager', 'last' => 'User', 'is_notified' => 0, 'time_zone' => 'America/Detroit']);
         $regularUser = $this->Users->newEntity(['username' => 'regular@tdtrac.com', 'password' => 'password', 'phone' => 1234567890, 'first' => 'Regular', 'last' => 'User', 'is_notified' => 0, 'time_zone' => 'America/Detroit']);
         if ($this->Users->save($adminUser)) {
             $this->out(' Create: Admin User #' . $adminUser->id);
         }
         if ($this->Users->save($managerUser)) {
             $this->out(' Create: Manager User #' . $managerUser->id);
         }
         if ($this->Users->save($regularUser)) {
             $this->out(' Create: Regular User #' . $regularUser->id);
         }
         $show1 = $this->Shows->newEntity(['name' => 'Example Show #1', 'location' => 'Somewhere', 'end_date' => Time::createFromFormat('Y-m-d', '2020-02-14', 'UTC')]);
         $show2 = $this->Shows->newEntity(['name' => 'Example Show #2', 'location' => 'Somewhere', 'end_date' => Time::createFromFormat('Y-m-d', '2010-02-14', 'UTC'), 'is_active' => 0]);
         if ($this->Shows->save($show1)) {
             $this->out(' Create: Open Show - #' . $show1->id);
         }
         if ($this->Shows->save($show2)) {
             $this->out(' Create: Closed Show - #' . $show2->id);
         }
         $this->out(' Creating Permissions');
         $insertCol = ["user_id", "show_id", "is_pay_admin", "is_paid", "is_budget", "is_task_admin", "is_task_user", "is_cal"];
         $insertRow = [['user_id' => $adminUser->id, 'show_id' => $show1->id, 'is_pay_admin' => 1, 'is_paid' => 1, 'is_budget' => 1, 'is_task_admin' => 1, 'is_task_user' => 1, 'is_cal' => 1], ['user_id' => $adminUser->id, 'show_id' => $show2->id, 'is_pay_admin' => 1, 'is_paid' => 1, 'is_budget' => 1, 'is_task_admin' => 1, 'is_task_user' => 1, 'is_cal' => 1], ['user_id' => $managerUser->id, 'show_id' => $show1->id, 'is_pay_admin' => 1, 'is_paid' => 1, 'is_budget' => 1, 'is_task_admin' => 0, 'is_task_user' => 1, 'is_cal' => 1], ['user_id' => $managerUser->id, 'show_id' => $show2->id, 'is_pay_admin' => 1, 'is_paid' => 1, 'is_budget' => 1, 'is_task_admin' => 0, 'is_task_user' => 1, 'is_cal' => 1], ['user_id' => $regularUser->id, 'show_id' => $show1->id, 'is_pay_admin' => 0, 'is_paid' => 1, 'is_budget' => 0, 'is_task_admin' => 0, 'is_task_user' => 1, 'is_cal' => 1], ['user_id' => $regularUser->id, 'show_id' => $show2->id, 'is_pay_admin' => 0, 'is_paid' => 1, 'is_budget' => 0, 'is_task_admin' => 0, 'is_task_user' => 1, 'is_cal' => 1]];
         $insertQuery = $this->ShowUserPerms->query();
         $insertQuery->insert($insertCol);
         $insertQuery->clause('values')->values($insertRow);
         $insertQuery->execute();
         $this->out(' Creating Budget Items');
         $insertCol = ["show_id", "category", "vendor", "price", "description", "date"];
         $insertRow = [['show_id' => $show1->id, 'category' => 'Category #1', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #1', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #1', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #1', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #2', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #2', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'category' => 'Category #2', 'vendor' => 'Random Vendor #' . rand(12, 365), 'price' => rand(2234, 355433) / 100, 'description' => 'Random Description #' . rand(12, 365), 'date' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')]];
         $insertQuery = $this->Budgets->query();
         $insertQuery->insert($insertCol);
         $insertQuery->clause('values')->values($insertRow);
         $insertQuery->execute();
         $this->out(' Creating Payroll Items');
         $insertCol = ["show_id", "user_id", "is_paid", "notes", "start_time", "end_time", "date_worked"];
         $mins = ['00', '15', '30', '45'];
         $insertRow = [['show_id' => $show1->id, 'user_id' => $regularUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $regularUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $regularUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $regularUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $managerUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $managerUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $managerUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $adminUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')], ['show_id' => $show1->id, 'user_id' => $adminUser->id, 'is_paid' => 0, 'notes' => 'Random Note #' . rand(12, 365), 'start_time' => Time::createFromFormat('H:i', rand(8, 11) . ":" . $mins[rand(0, 3)], 'UTC'), 'end_time' => Time::createFromFormat('H:i', rand(13, 17) . ":" . $mins[rand(0, 3)], 'UTC'), 'date_worked' => Time::createFromFormat('Y-m-d', '2010-02-' . rand(10, 28), 'UTC')]];
         $insertQuery = $this->Payrolls->query();
         $insertQuery->insert($insertCol);
         $insertQuery->clause('values')->values($insertRow);
         $insertQuery->execute();
         $this->out(' Creating Task Items');
         $insertCol = ["created_by", "assigned_to", "show_id", "due", "title", "category", "note", "task_accepted", "task_done"];
//.........这里部分代码省略.........

 /**
  * Add method
  *
  * @return void Redirects on successful add, renders view otherwise.
  */
 public function add($ship = null)
 {
     //Obtencion de Parcels correspondientes al shipment a facturar
     $shipping = $this->Commisions->Shippings->get($ship, ['contain' => ['Fixtures', 'Parcels']]);
     //Entrega de la info al template
     $this->set('shipping', $shipping);
     $this->set('_serialize', ['shipping']);
     //declaracion de variables para calculo de valores
     $tot_dem = 0;
     $cont = 0;
     $tot_freight = 0;
     $freightsum = 0;
     $total_vol = 0;
     //calculo de cada valor por cada parcel correspondiente al shipment
     foreach ($shipping->parcels as $parcels) {
         $tot_freight = +$parcels->freight_100;
         if ($parcels->des_dem_char > 0) {
             $tot_dem = +$parcels->des_dem_char;
         }
         $port = $this->Commisions->Shippings->Parcels->Ports->get($parcels->port_id);
         if ($parcels->type_of_call == 'Loading Port') {
             $total_vol = +$parcels->volume;
             $load_port[] = $port->name;
         } else {
             $dis_port[] = $port->name;
         }
         $freightsum = +$parcels->dem_bro * $parcels->volume;
         $cont = +$parcels->volume;
         $cargo = $parcels->cargo;
         $unit = $parcels->unit;
     }
     //calculo final de variables de informacion
     $cargounit = [$total_vol, $unit];
     $finalfreight = $freightsum / $cont;
     $tot_com = ($tot_freight + $tot_dem) * ($shipping->fixture->broker_com / 100);
     $load_ports = implode('/', $load_port);
     $dis_ports = implode('/', $dis_port);
     //obtencion de datos de Shipowner y Charterer
     $shipowner = $this->Commisions->Shippings->Fixtures->Shipowners->get($shipping->fixture->shipowner_id);
     $charterer = $this->Commisions->Shippings->Fixtures->Charterers->get($shipping->fixture->charterer_id);
     $com_info = ['finalfreight' => $finalfreight, 'tot_com' => $tot_com, 'load_ports' => $load_ports, 'dis_ports' => $dis_ports, 'cargo' => $cargo, 'tot_freight' => $tot_freight, 'tot_dem' => $tot_dem, 'total_vol' => $total_vol, 'client' => $shipowner->full_style, 'charterer' => $charterer->nick, 'unit' => $unit];
     $this->set('com_info', $com_info);
     $commision = $this->Commisions->newEntity();
     if ($this->request->is('post')) {
         $this->request->data['date_com'] = Time::createFromFormat('m/d/Y', $this->request->data['date_com'], 'UTC');
         $commision = $this->Commisions->patchEntity($commision, $this->request->data);
         if ($this->Commisions->save($commision)) {
             $this->Flash->success(__('The commision has been saved.'));
             return $this->redirect(['action' => 'index']);
         } else {
             $this->Flash->error(__('The commision could not be saved. Please, try again.'));
         }
     }
     $shippings = $this->Commisions->Shippings->find('list', ['limit' => 200]);
     $this->set(compact('commision', 'shippings'));
     $this->set('_serialize', ['commision']);
 }

 public function clockPicker($name, $label, $time = null)
 {
     if (!is_null($time)) {
         $time = Time::createFromFormat('H:i', $time, 'UTC');
         $val = $time->i18nFormat('H:mm', 'UTC');
         $pretval = $time->i18nFormat('h:mm a', 'UTC');
     } else {
         $val = "";
         $pretval = "";
     }
     $retty = '<div class="form-group required">';
     $retty .= '<label class="control-label">' . $label . '</label>';
     $retty .= '<input type="text" data-role="datebox" data-datebox-mode="timeflipbox" id="' . $name . '-dbox" class="form-control" value="' . $pretval . '" data-options=\'{"linkedField": "#' . $name . '", "overrideTimeFormat": 12, "overrideTimeOutput": "%-I:%M %p", "linkedFieldFormat": "%H:%M", "minuteStep": 15 }\'>';
     $retty .= '<input type="hidden" name="' . $name . '" id="' . $name . '" value="' . $val . '" /></div>';
     return $retty;
 }

 /**
  * Edit method
  *
  * @param string|null $id Schedule id.
  * @return \Cake\Network\Response|void Redirects on successful edit, renders view otherwise.
  * @throws \Cake\Network\Exception\NotFoundException When record not found.
  */
 public function edit($id = null)
 {
     if (!$this->Auth->user('is_admin')) {
         $this->Flash->error(__('Only administrators may access the scheduled tasks module.'));
         return $this->redirect("/");
     }
     $this->loadModel('Shows');
     $showsq = $this->Shows->find('all')->select(['id', 'name'])->where(['Shows.is_active' => 1]);
     $shows = ["** Not Applicable **"];
     foreach ($showsq as $show) {
         $shows[$show->id] = $show->name;
     }
     $this->set('shows', $shows);
     $schedule = $this->Schedules->get($id, ['contain' => []]);
     if ($this->request->is(['patch', 'post', 'put'])) {
         $time = Time::createFromFormat('Y-m-d H:i:s', $this->request->data['start_time'], 'UTC');
         $this->request->data['start_time'] = $time;
         $schedule = $this->Schedules->patchEntity($schedule, $this->request->data);
         if ($this->Schedules->save($schedule)) {
             $this->Flash->success(__('The schedule has been saved.'));
             return $this->redirect(['action' => 'index']);
         } else {
             $this->Flash->error(__('The schedule could not be saved. Please, try again.'));
         }
     }
     $this->set(compact('schedule'));
     $this->set('_serialize', ['schedule']);
 }