/**
  * 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 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());
 }