/** * bool insert(Patient $patient, History $historyP, History $historyF, int $idUser, string $login) * * Inserts a new deleted patient into the database. * * @param Patient $patient patient to insert * @param History $historyP patient's personal antecedents to insert * @param History $historyF patient's family antecedents to insert * @param int $idUser key of user that makes deletion * @param string $login login session of user that makes deletion * @return boolean returns false, if error occurs * @access public */ function insert($patient, $historyP, $historyF, $idUser, $login) { $sql = "INSERT INTO " . $this->_table; $sql .= " (id_patient, nif, first_name, surname1, surname2, address, phone_contact, "; $sql .= "sex, race, birth_date, birth_place, decease_date, nts, nss, "; $sql .= "family_situation, labour_situation, education, insurance_company, "; $sql .= "id_member, collegiate_number, birth_growth, growth_sexuality, feed, habits, "; $sql .= "peristaltic_conditions, psychological, children_complaint, venereal_disease, "; $sql .= "accident_surgical_operation, medicinal_intolerance, mental_illness, "; $sql .= "parents_status_health, brothers_status_health, spouse_childs_status_health, "; $sql .= "family_illness, create_date, id_user, login) VALUES ("; $sql .= "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "; $sql .= "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "; $sql .= "?, ?, ?, ?, NOW(), ?, ?);"; $params = array($patient->getIdPatient(), urlencode($patient->getNIF()), urlencode($patient->getFirstName()), urlencode($patient->getSurname1()), urlencode($patient->getSurname2()), urlencode($patient->getAddress()), urlencode($patient->getPhone()), $patient->getSex(), urlencode($patient->getRace()), $patient->getBirthDate(), urlencode($patient->getBirthPlace()), $patient->getDeceaseDate(), urlencode($patient->getNTS()), urlencode($patient->getNSS()), urlencode($patient->getFamilySituation()), urlencode($patient->getLabourSituation()), urlencode($patient->getEducation()), urlencode($patient->getInsuranceCompany()), $patient->getIdMember(), urlencode($patient->getCollegiateNumber()), urlencode($historyP->getBirthGrowth()), urlencode($historyP->getGrowthSexuality()), urlencode($historyP->getFeed()), urlencode($historyP->getHabits()), urlencode($historyP->getPeristalticConditions()), urlencode($historyP->getPsychological()), urlencode($historyP->getChildrenComplaint()), urlencode($historyP->getVenerealDisease()), urlencode($historyP->getAccidentSurgicalOperation()), urlencode($historyP->getMedicinalIntolerance()), urlencode($historyP->getMentalIllness()), urlencode($historyF->getParentsStatusHealth()), urlencode($historyF->getBrothersStatusHealth()), urlencode($historyF->getSpouseChildsStatusHealth()), urlencode($historyF->getFamilyIllness()), intval($idUser), urlencode($login)); return $this->exec($sql, $params); }
public function action_history() { $data = array('content' => $this->executeCommand(), 'currentdb' => Request::factory()->getDb(), 'cmd' => Request::factory()->getCmd(), 'dbkeys' => Helper_Info::getCountKeysInDb(), 'history' => History::getLast($_SESSION['login'])); if (Request::factory()->getAjax()) { header('Content-Type: application/json'); echo json_encode($data); } else { echo View::factory('layout', $data); } }
public function actionUnban($id) { $ban_model = $this->loadModel($id); if (!Webadmins::checkAccess('bans_unban', $ban_model->admin_nick)) { throw new CHttpException(403, "У Вас недостаточно прав"); } $history_model = new History(); $history_model->unsetAttributes(); $history_model->player_ip = $ban_model->player_ip; $history_model->player_id = $ban_model->player_id; $history_model->player_nick = $ban_model->player_nick; $history_model->admin_ip = $ban_model->admin_ip; $history_model->admin_id = $ban_model->admin_id; $history_model->admin_nick = $ban_model->admin_nick; $history_model->ban_type = $ban_model->ban_type; $history_model->ban_reason = $ban_model->ban_reason; $history_model->ban_created = $ban_model->ban_created; $history_model->ban_length = $ban_model->ban_length; $history_model->server_ip = $ban_model->server_ip; $history_model->server_name = $ban_model->server_name; $history_model->unban_created = time(); $history_model->unban_reason = 'Разбанен с сайта'; $history_model->unban_admin_nick = Yii::app()->user->name; if ($history_model->save()) { if ($ban_model->delete()) { Yii::app()->end('Игрок разбанен'); } } Yii::app()->end(CHtml::errorSummary($ban_model)); }
/** * Initialize the object with raw data * * @param $data * @return History */ public static function initializeWithRawData($data) { $item = new History(); if (isset($data['created_at'])) { $item->setCreatedAt(new \DateTime('@' . strtotime($data['created_at']))); } if (isset($data['message'])) { $item->setMessage($data['message']); } return $item; }
protected function createHistory() { $user = $this->getMockBuilder('Application\\UserBundle\\Document\\User')->setMethods(array('getUsernameCanonical', 'getCreatedAt'))->getMock(); $user->expects($this->once())->method('getUsernameCanonical')->will($this->returnValue('joe')); $user->expects($this->once())->method('getCreatedAt')->will($this->returnValue(new \DateTime())); $history = new History($user); foreach (array(1 => 1200, 2 => 1250, 3 => 1300, 4 => 1250, 5 => 1300, 6 => 1100) as $ts => $elo) { $history->addUnknownGame($ts, $elo); } return $history; }
/** * method that checks if the contidion is satisfied * for the passed id_user in the passed id_course_instance * * @param int $id_course_instance * @param int $id_user * @return boolean true if condition is satisfied * @access public */ private function isSatisfied($id_course_instance = null, $id_student = null) { require_once ROOT_DIR . '/include/history_class.inc.php'; $history = new History($id_course_instance, $id_student); $history->get_visit_time(); if ($history->total_time > 0) { $timeSpentInCourse = intval($history->total_time / 60); } else { $timeSpentInCourse = 0; } return $timeSpentInCourse >= $this->_param; }
static function createFor(HistoricalObjectI $object) { $data = $object->getDataForHistory(); if (!is_array($data)) { $data = array($data); } foreach ($data as $historyDataEntry) { $history = new History(); $history->setUserId($historyDataEntry->getUserId()); $history->setEntityType(get_class($object)); $history->setData(serialize($historyDataEntry->getData())); $history->save(); } }
public function testPositioning() { $other_file = tempnam(sys_get_temp_dir() . 'tmp', 'history'); $el1 = $this->_history->append($other_file); $el2 = $this->_history->append($other_file); $el3 = $this->_history->append($other_file); $this->assertEquals(3, $this->_history->getCount()); $this->assertEquals($el3, $this->_history->getFirst()); $this->assertEquals($el1, $this->_history->getLast()); $this->assertEquals($el2, $this->_history->getNth(1)); $this->assertEquals($el1, $this->_history->getNext()); $this->assertFalse($this->_history->getNext()); unlink($other_file); }
public function update(array $data, $where) { //save a snapshot now require_once 'History.php'; $historyTable = new History('trainer'); //cheezy way to get the id $parts = explode('=', $where[0]); $pid = trim($parts[1]); //link to the last history row $personHistoryTable = new History('person'); $hrow = $personHistoryTable->fetchAll("person_id = {$pid}", "vid DESC", 1); $historyTable->insert($this, $hrow->current()->vid); $rslt = parent::update($data, $where); return $rslt; }
public function getHistoryNews() { $newspaper_id = Input::get('newspaper', '') != '' ? Input::get('newspaper') : false; $tag_id = Input::get('tag', '') != '' ? Input::get('tag') : false; $query = History::with('newspaper')->with('tag')->select(DB::raw('MAX(total_day) as total_day'), DB::raw('DATE(date) as sdate'), 'history.id as id', 'history.url as url', 'history.id_newspaper as id_newspaper', 'history.id_tag as id_tag', 'history.final_url as final_url', 'history.title as title', 'history.date as date', 'history.facebook as facebook', 'history.twitter as twitter', 'history.total as total', 'history.googleplus as googleplus', 'history.linkedin as linkedin', 'history.image as image')->groupBy('sdate')->orderBy('date', 'DESC'); return Response::json($query->get()); }
public function clear() { $this->autoRender = false; if ($this->request->is('post')) { return json_encode(History::clear($this->Session)); } }
private function writeHistory($response, $transactionRequest) { $id_pedido = (int) $this->module->currentOrder; $id_transacao = $response->transactionId; $id_status = (int) Configuration::get('PS_OS_BCASH_IN_PROGRESS'); $status = urldecode($response->descriptionStatus); $paymentMethodHelper = new PaymentMethodHelper(); $pagamento_meio = $paymentMethodHelper->getById(Tools::getValue('payment-method')); if (PaymentMethodHelper::isCard($pagamento_meio)) { $parcelas = Tools::getValue('card-installment'); } else { $parcelas = 1; } $history = new History($id_pedido, $id_transacao, $id_status, $status, $pagamento_meio->title, $parcelas); $history->write(); }
public static function Roll($chance) { $coinCode = Input::get('coinCode'); $betSize = Input::get('betsize'); $profit = Input::get('profit'); $payout = Input::get('payout'); $roll = rand(1, 100); if ($roll < $chance) { $result = 'Win'; } else { $result = 'Lose'; } $wallet_balance = strtolower($coinCode) . "_wallet_balance"; if (Auth::user()->{$wallet_balance} >= $betSize) { if ($result == 'Win') { $balance = Coin::Give($coinCode, $profit); } else { $balance = Coin::Take($coinCode, $betSize); } History::Add($betSize, $payout, $profit, $coinCode); } else { $result = "No Funds"; $balance = Auth::user()->{$wallet_balance}; } return json_encode(['result' => $result, 'profit' => $balance]); }
function show_GET($w) { list($lotid, $householdid) = $w->pathMatch("lotid", "householdid"); if (empty($lotid)) { $w->error("Need a Lot ID"); } if (empty($householdid)) { $w->error("Need a household ID"); } $lot = $w->Bend->getLotForId($lotid); if (empty($lot)) { $w->error("Lot {$lotid} does not exist"); } $household = $w->Bend->getHouseholdForId($householdid); if (empty($household)) { $w->error("Household {$householdid} does not exist"); } History::add("Bend Household: " . $household->streetnumber); $lotTable = array(); $lotTable["Household"] = array(array(array("Lot Number", "static", "", $lot->lot_number), array("Occupancy", "static", "", $lot->occupancy)), array(array("Street Number", "static", "", $household->streetnumber), array("Is CHL?", "static", "", $household->is_chl ? "yes" : "no"), array("Is Occupied?", "static", "", $household->is_occupied ? "yes" : "no"), array("Number of Occupants", "static", "", $household->num_occupants))); $w->ctx("lot", $lot); $w->ctx("table", Html::multiColTable($lotTable)); $w->ctx("household", $household); $w->ctx("currentOccupants", $household->getCurrentOccupants()); $w->ctx("pastOccupants", $household->getPastOccupants()); }
function index() { $h = new History(); $events = $h->include_related('user')->order_by('id DESC')->get_iterated(); foreach ($events as $e) { $message = unserialize($e->message); if (is_string($message)) { $message = $this->messages[$message]; } else { $key = array_shift($message); $message = vsprintf($this->messages[$key], $message); } echo $message . ' by ' . $e->user_username . ' ' . time_ago($e->created_on) . '<br>'; } exit; }
function viewtaskgrouptypes_ALL(Web $w) { $w->Task->navigation($w, "Manage Task Groups"); History::add("Manage Task Groups"); $task_groups = $w->Task->getTaskGroups(); if ($task_groups) { usort($task_groups, array("TaskService", "sortbyGroup")); } // prepare column headings for display $line = array(array("Title", "Type", "Description", "Default Assignee")); // if task group exists, display title, group type, description, default assignee and button for specific task group info if ($task_groups) { foreach ($task_groups as $group) { $line[] = array(Html::a(WEBROOT . "/task-group/viewmembergroup/" . $group->id, $group->title), $group->getTypeTitle(), $group->description, $group->getDefaultAssigneeName()); } } else { // if no groups for this group type, say as much $line[] = array("There are no Task Groups Configured. Please create a New Task Group.", "", "", "", ""); } // display list of task groups in the target task group type $w->ctx("dashboard", Html::table($line, null, "tablesorter", true)); // tab: new task group // get generic task group permissions $arrassign = $w->Task->getTaskGroupPermissions(); // unset 'ALL' given all can never assign a task unset($arrassign[0]); // set Is Task Active dropdown $is_active = array(array("Yes", "1"), array("No", "0")); $grouptypes = $w->Task->getAllTaskGroupTypes(); // build form to create a new task group within the target group type $f = Html::form(array(array("Task Group Attributes", "section"), array("Task Group Type", "select", "task_group_type", null, $grouptypes), array("Title", "text", "title"), array("Who Can Assign", "select", "can_assign", null, $arrassign), array("Who Can View", "select", "can_view", null, $w->Task->getTaskGroupPermissions()), array("Who Can Create", "select", "can_create", null, $w->Task->getTaskGroupPermissions()), array("Active", "select", "is_active", null, $is_active), array("", "hidden", "is_deleted", "0"), array("Description", "textarea", "description", null, "26", "6"), array("Default Assignee", "select", "default_assignee_id", null, $w->Auth->getUsers())), $w->localUrl("/task-group/createtaskgroup"), "POST", "Save"); // display form $w->ctx("creategroup", $f); }
function list_GET(Web $w) { History::add("List Workhours"); list($userid, $periodid) = $w->pathMatch("a", "b"); // get the user if (!empty($userid)) { $user = $w->Auth->getUser($userid); } else { $user = $w->Auth->user(); } // calculate total work hours for this period $workentries = $w->Bend->getWorkhoursForUser($user, $periodid); $total_worked = 0; $total_accredited = 0; if (!empty($workentries)) { foreach ($workentries as $we) { $total_worked += $we->hours; if ($we->user_id == $we->attributed_user_id) { $total_accredited += $we->hours; } } } $w->ctx("total_worked", $total_worked); $w->ctx("total_accredited", $total_accredited); $w->ctx("user", $user); $w->ctx("workentries", $workentries); $w->ctx("workPeriod", $w->Bend->getWorkPeriodForId($periodid)); $w->ctx("allWorkPeriods", $w->Bend->getAllWorkPeriods()); }
function admin_ALL(Web $w) { History::add("Workhours Admin"); $w->ctx("workperiods", $w->Bend->getAllWorkPeriods()); $w->ctx("focusgroups", $w->Bend->getTopLevelWorkCategories()); $w->enqueueStyle(["uri" => "/modules/bend/assets/css/bend.css", "weight" => 500]); }
/** * Modifies an Issue's Reporter. * * @param integer $issue_id The id of the issue. * @param string $fullname The id of the user. * @param boolean $add_history If this should be logged. * @return int */ public static function update($issue_id, $email, $add_history = true) { $email = strtolower(Mail_Helper::getEmailAddress($email)); $usr_id = User::getUserIDByEmail($email, true); // If no valid user found reset to system account if (!$usr_id) { $usr_id = APP_SYSTEM_USER_ID; } $sql = 'UPDATE {{%issue}} SET iss_usr_id = ? WHERE iss_id = ?'; try { DB_Helper::getInstance()->query($sql, array($usr_id, $issue_id)); } catch (DbException $e) { return -1; } if ($add_history) { // TRANSLATORS: %1: email, %2: full name $current_usr_id = Auth::getUserID(); History::add($issue_id, $current_usr_id, 'issue_updated', 'Reporter was changed to {email} by {user}', array('email' => $email, 'user' => User::getFullName($current_usr_id))); } // Add new user to notification list if ($usr_id > 0) { Notification::subscribeEmail($usr_id, $issue_id, $email, Notification::getDefaultActions()); } return 1; }
public function Install() { Settings::CreateTable(); History::CreateTable(); User::CreateTable(); Coin::CreateTable(); return Redirect::to('/'); }
public function testGetLength() { $instance = new History(); $this->assertEquals(0, $instance->getLength()); $instance->add('foo'); $this->assertEquals(1, $instance->getLength()); $instance->add('bar'); $this->assertEquals(2, $instance->getLength()); $instance->clear(); $this->assertEquals(0, $instance->getLength()); }
/** * Execute the console command. * * @return mixed */ public function fire() { $log = new Process(); $log->name = "make-history"; $log->status = "running"; $log->save(); $today = Carbon::today(); $topToday = array(); $newspapers = Newspaper::select('id')->get(); $tags = Tag::select('id')->get(); foreach ($newspapers as $key => $n) { $top = $this->getTopLink($today, $n->id, false); if ($top) { $topToday[] = $top; } } foreach ($tags as $key => $t) { $top = $this->getTopLink($today, false, $t->id); if ($top) { $topToday[] = $top; } } $topToday = array_unique($topToday); //Remove links for today History::where('date', '=', $today)->delete(); //Save history foreach ($topToday as $key => $t) { $this->info($t->title); try { $h = new History(); $h->id_ref = $t->id; unset($t->id); $h->fill($t->toArray()); $h->date = $today; $h->save(); } catch (Exception $e) { } } $log->status = "finished"; $log->save(); }
function showperiod_GET(Web $w) { list($id) = $w->pathMatch("a"); $wp = $w->Bend->getWorkperiodForId($id); if (empty($wp)) { $w->error("Workperiod does not exist", "/bend-workhours/admin"); } History::add("Work Period: " . formatDate($wp->d_start)); $w->ctx("workperiod", $wp); $w->ctx("categories", $w->Bend->getTopLevelWorkCategories()); $w->ctx("households", $w->Bend->getAllHouseholds()); }
/** * PDO query() extend history and callback * * @param string $query SQL sentence * @param callable $callback callback function binded PDO object * @param bool $noLog If true, History not add * @return object PDO query object */ public function query($query, $callback = null, $noLog = false) { if (!$noLog && isset($this->history)) { $this->history->set($query); } $result = parent::query($query); if ($callback instanceof \Closure) { $callback = $callback->bindTo($result); $callback($result); } return $result; }
/** * Method used to log the changes made against a specific issue. * * @param integer $iss_id The issue ID * @param integer $usr_id The ID of the user. * @param integer|string $htt_id The type ID of this history event. * @param string $summary The summary of the changes * @param array $context parameters used in summary */ public static function add($iss_id, $usr_id, $htt_id, $summary, $context = array()) { if (!is_numeric($htt_id)) { $htt_id = History::getTypeID($htt_id); } $params = array('his_iss_id' => $iss_id, 'his_usr_id' => $usr_id, 'his_created_date' => Date_Helper::getCurrentDateGMT(), 'his_summary' => $summary, 'his_context' => json_encode($context), 'his_htt_id' => $htt_id); $stmt = 'INSERT INTO {{%issue_history}} SET ' . DB_Helper::buildSet($params); try { DB_Helper::getInstance()->query($stmt, $params); } catch (DbException $e) { } }
function writeHistory($orderId, $response) { $novoStatus = array(); if ($response->transactionStatusId == 7) { $novoStatus['id'] = (int) Configuration::get('PS_OS_BCASH_CANCELLED'); $novoStatus['status'] = 'Cancelada'; } else { $novoStatus['id'] = (int) Configuration::get('PS_OS_BCASH_REFUNDED'); $novoStatus['status'] = 'Devolvida'; } $result = History::writeNewOrderStatus($orderId, $novoStatus); }
public function index() { if (!Auth::check()) { return Redirect::to('/'); } $user = Auth::user(); if (Scheduler::where('uid', '=', $user->id)->count() > 0) { return Redirect::to('/inline'); } $count_matches = History::where('uid', '=', $user->id)->count(); //return Scheduler::where('uid', '=', $user->id)->count(); return View::make('sessions.index', ['count' => $count_matches]); }
public static function forward() { if (self::is_forward()) { $_SESSION['client']['__history_id__']++; } self::$action = true; $data = DB::GetOne('SELECT data FROM history WHERE session_name=%s AND page_id=%d AND client_id=%d', array(self::session_id(), $_SESSION['client']['__history_id__'] - 1, CID)); // $data = DB::BlobDecode($data); if (GZIP_HISTORY && function_exists('gzuncompress')) { $data = gzuncompress($data); } $_SESSION['client']['__module_vars__'] = unserialize($data); location(array()); }
public static function getHistorys($arr) { if (!$arr) { return null; } foreach ($arr as $value) { $historys[] = History::getHistory($value); } if (isset($historys)) { return $historys; } else { return null; } }
public function editHistory() { $id = Input::get('id'); $history_entry = History::find($id); $history_entry->ban = Input::get('ban'); $history_entry->save(); return Redirect::to('/history'); }