public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $id = $this->Request["id"]; $cmd = $this->db->createCommand("SELECT i.name FROM hr_install AS i LEFT JOIN hr_component AS c ON c.id_install=i.id WHERE i.id=:id AND c.parentmenu=0"); $cmd->bindValue(":id", $id, PDO::PARAM_INT); $cmd = $cmd->query(); $data = $cmd->read(); $this->cname->Text = $data["name"]; $xml = "." . DIRECTORY_SEPARATOR . "protected" . DIRECTORY_SEPARATOR . "pages" . DIRECTORY_SEPARATOR . "components" . DIRECTORY_SEPARATOR . $data["name"] . DIRECTORY_SEPARATOR . "config.xml"; if (file_exists($xml)) { $this->Repeater->DataSource = $this->setDataFromXml($xml); $this->Repeater->dataBind(); } else { $this->Apply->setEnabled(false); $this->Save->setEnabled(false); } } if (isset($this->Request['okMsg'])) { $this->displayMessage($this->Request['okMsg'], true); } if (isset($this->Request['koMsg'])) { $this->displayMessage($this->Request['koMsg'], false); } }
public function onLoad($param) { parent::onLoad($param); if ($this->Request['dispimage_p']) { $this->getImage_p($this->Request['dispimage_p']); } if ($this->Request['dispimage_s1']) { $this->getImage_s1(); } if ($this->Request['dispimage_s2']) { $this->getImage_s2($this->Request['dispimage_s2']); } if (!$this->IsPostBack) { $sql = "SELECT * FROM hr_vp_parking"; $cmd = $this->db->createCommand($sql); $data = $cmd->query(); $this->Repeater->DataSource = $data->readAll(); $this->Repeater->dataBind(); $sql = "SELECT * FROM hr_vp_subscription ORDER BY id"; $cmd = $this->db->createCommand($sql); $data = $cmd->query(); $this->Repeater2->DataSource = $data->readAll(); $this->Repeater2->dataBind(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $userId = $this->Application->getUser()->getUserId(); $this->blockRecord('hr_device', $this->Request['id'], $userId); $this->horuxControllerId->setDataValueField('id'); $this->horuxControllerId->setDataTextField('name'); $this->horuxControllerId->DataSource = $this->Controller; $this->horuxControllerId->dataBind(); $this->horuxControllerId->setSelectedIndex(0); $this->parent->setDataValueField('id'); $this->parent->setDataTextField('name'); $this->parent->DataSource = $this->Devices; $this->parent->dataBind(); $param = $this->Application->getParameters(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->Save->setEnabled(false); $this->Apply->setEnabled(false); } $this->id->Value = $this->Request['id']; $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $app = $this->getApplication(); $usedId = $app->getUser()->getUserID() == null ? 0 : $app->getUser()->getUserID(); $cmd = $this->db->createCommand("SELECT user_id FROM hr_superusers WHERE id={$usedId}"); $data = $cmd->query(); $dataUser = $data->read(); $userId = $dataUser['user_id']; $employee = new employee($userId); $role = $employee->getRole(); if ($role == 'employee' && $userId != $this->Request['userId']) { $this->Response->redirect($this->Service->constructUrl($this->Request['back'])); } $this->employee->DataSource = $this->PersonList; $this->employee->dataBind(); if ($this->employee->getItemCount() && $this->employee->getSelectedValue() == '') { $this->employee->setSelectedIndex(0); } $this->timecode->DataSource = $this->TimeCodeList; $this->timecode->dataBind(); $this->timecode->setEnabled(false); if (isset($this->Request['date'])) { $this->date->Text = $this->Request['date']; } if (isset($this->Request['userId'])) { $this->employee->setSelectedValue($this->Request['userId']); } } }
public function onLoad($param) { parent::onLoad($param); if ($this->isPanelDisplay('dispUserLoggedIn')) { $this->usersGrid->DataSource = $this->UsersLogged; $this->usersGrid->dataBind(); } if ($this->isPanelDisplay('dispLastTracking')) { $this->trackGrid->DataSource = $this->LastTrack; $this->trackGrid->dataBind(); } if ($this->isPanelDisplay('dispLastAlarm')) { $this->alarmsGrid->DataSource = $this->LastAlarms; $this->alarmsGrid->dataBind(); } $app = $this->getApplication(); $db = $app->getModule('horuxDb')->DbConnection; $sql = "SELECT `key` FROM hr_config"; $cmd = $db->createCommand($sql); $res = $cmd->query(); $res = $res->read(); $_SESSION['helpKey'] = $res['key']; $this->Repeater->DataSource = $this->getComponentShortCut(); $this->Repeater->dataBind(); }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $deviceId = $this->Request["deviceId"]; $cmd = $this->db->createCommand("SELECT * FROM `hr_horux_media` WHERE id_device=:id"); $cmd->bindParameter(":id", $deviceId, PDO::PARAM_STR); $row = $cmd->query(); $row = $row->read(); require_once 'XML/RPC.php'; $client = new XML_RPC_Client("RPC2", $row["ip"], $row["port"]); $msg = new XML_RPC_Message("horuxInfoDisplay.getMediaList"); @($response = $client->send($msg)); if ($response) { if (!$response->faultCode()) { $v = $response->value(); $result = explode(",", html_entity_decode($v->scalarval())); $media = array(); foreach ($result as $k => $v) { $media[] = array("Value" => $v, "Text" => $v); } $this->media->DataTextField = 'Text'; $this->media->DataValueField = 'Value'; $this->media->DataSource = $media; $this->media->dataBind(); if (count($media) > 0) { $this->media->setSelectedIndex(0); } } else { $content_error = "ERROR - "; $content_error .= "Code: " . $response->faultCode() . " Reason '" . $response->faultString() . "'<br/>"; } } } }
public function onLoad($param) { parent::onLoad($param); if (!is_writeable("." . DIRECTORY_SEPARATOR . "protected" . DIRECTORY_SEPARATOR . "messages")) { $this->displayMessage(Prado::localize("The directory {dir} must be writeable", array("dir" => "." . DIRECTORY_SEPARATOR . "protected" . DIRECTORY_SEPARATOR . "messages")), false); } }
public function onLoad($param) { parent::onLoad($param); $sql = "SELECT picturepath FROM hr_config WHERE id=1"; $cmd = $this->db->createCommand($sql); $data = $cmd->query(); $data = $data->read(); if ($data['picturepath'] != "") { if (!is_writeable('pictures' . DIRECTORY_SEPARATOR . $data['picturepath'])) { $this->displayMessage(Prado::localize('The directory ./pictures{p} must be writeable to save your logo', array('p' => DIRECTORY_SEPARATOR . $data['picturepath'])), false); } else { $this->picturepath = 'pictures' . DIRECTORY_SEPARATOR . $data['picturepath'] . DIRECTORY_SEPARATOR; } } else { if (!is_writeable('.' . DIRECTORY_SEPARATOR . 'pictures')) { $this->displayMessage(Prado::localize('The directory ./pictures{p} must be writeable to save your logo', array('p' => "")), false); } else { $this->picturepath = 'pictures' . DIRECTORY_SEPARATOR; } } if (!$this->isPostBack) { $this->setData(); $param = $this->Application->getParameters(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->tbb->Save->setEnabled(false); } } }
public function onLoad($param) { parent::onLoad($param); $app = $this->getApplication(); $usedId = $app->getUser()->getUserID() == null ? 0 : $app->getUser()->getUserID(); $cmd = $this->db->createCommand("SELECT user_id FROM hr_superusers WHERE id={$usedId}"); $data = $cmd->query(); $dataUser = $data->read(); $this->userId = $dataUser['user_id']; $this->employee = new employee($this->userId); if (!$this->isPostBack) { $this->timecode->DataSource = $this->TimeCodeList; $this->timecode->dataBind(); $this->id->Value = $this->Request['id']; // Secure the id to be sure that the id correspond to the employee $cmd = $this->db->createCommand("SELECT * FROM hr_timux_request WHERE id=:id AND userId=:userId"); $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR); $cmd->bindValue(":userId", $this->userId, PDO::PARAM_STR); $data = $cmd->query(); $data = $data->readAll(); if (count($data) == 0) { $pBack = array('koMsg' => Prado::localize('Cannot modify a leave request from an other employee')); $this->Response->redirect($this->Service->constructUrl('components.timuxuser.leaverequest.leaverequest', $pBack)); } $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (isset($this->Request['enterkey']) && $this->Request['enterkey'] == 1) { $authManager = $this->Application->getModule('Auth'); if ($authManager->login(strtolower($this->username->SafeText), $this->password->SafeText)) { $this->log($this->username->SafeText . " is logged in"); $userID = Prado::getApplication()->getUser()->getUserID(); $cmd = $this->db->createCommand("SELECT defaultPage FROM hr_superuser_group AS sg LEFT JOIN hr_superusers AS s ON s.group_id=sg.id WHERE s.id={$userID}"); $data = $cmd->query(); $dataUser = $data->read(); $defaultPage = $dataUser['defaultPage']; if ($defaultPage == '') { $this->Response->redirect($this->Service->constructUrl('controlPanel.ControlPanel', array('lang' => $this->lang->getSelectedValue()))); } else { $this->Response->redirect($this->Service->constructUrl($defaultPage, array('lang' => $this->lang->getSelectedValue()))); } //$this->Response->redirect($this->Service->constructUrl('controlPanel.ControlPanel',array('lang'=>$this->lang->getSelectedValue()))); } } $this->getClientScript()->registerStyleSheetFile('loginCss', './themes/letux/css/login.css'); $this->username->focus(); if (!$this->IsPostBack) { $this->lang->DataTextField = 'name'; $this->lang->DataValueField = 'param'; $this->lang->DataSource = $this->Data; $this->lang->dataBind(); $cmd = $this->db->createCommand("SELECT * FROM hr_install WHERE type='language' AND `default`=1"); $data = $cmd->query(); $data = $data->read(); $this->lang->setSelectedValue($data['param']); } }
public function onLoad($param) { parent::onLoad($param); $groupId = $this->Application->getUser()->getGroupID(); $param = $this->Application->getParameters(); if ($this->Request['id'] == 1 && $groupId != 1 && $param['appMode'] == 'saas') { $pBack = array('koMsg' => Prado::localize("You don't have the right to modify this users group")); $this->Response->redirect($this->Service->constructUrl('superuser.userGroupList', $pBack)); } if (!$this->isPostBack) { $userId = $this->Application->getUser()->getUserId(); $this->blockRecord('hr_superuser_group', $this->Request['id'], $userId); $this->id->Value = $this->Request['id']; $this->defaultPage->DataTextField = 'pagename'; $this->defaultPage->DataValueField = 'page'; $this->defaultPage->DataSource = $this->DataPage; $this->defaultPage->dataBind(); $this->setData(); $this->Session['dataPage'] = array(); $this->DataGrid->DataSource = $this->Data; $this->DataGrid->dataBind(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); $param = $this->Application->getParameters(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->tbb->apply->setEnabled(false); $this->tbb->Save->setEnabled(false); } $this->DataGrid->DataSource = $this->Data; $this->DataGrid->dataBind(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->accesspoint->DataSource = $this->Accesspoint; $this->accesspoint->dataBind(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->id->Value = $this->Request['id']; $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $result = $this->getSystemStatus(); $this->parseResponse($result); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->employee->DataSource = $this->PersonList; $this->employee->dataBind(); $this->id->Value = $this->Request['id']; $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $userId = $this->Application->getUser()->getUserId(); $this->blockRecord('hr_vp_period', $this->Request['id'], $userId); $this->id->Value = $this->Request['id']; $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $sql = "SELECT * FROM hr_vp_subscription_attribution WHERE id=:id"; $cmd = $this->db->createCommand($sql); $cmd->bindValue(":id", $this->Request["attid"], PDO::PARAM_INT); $query = $cmd->query(); $data = $query->read(); $sql2 = "SELECT * FROM hr_vp_subscription WHERE id=:id"; $cmd2 = $this->db->createCommand($sql2); $cmd2->bindValue(":id", $data['subcription_id'], PDO::PARAM_INT); $query2 = $cmd2->query(); $data2 = $query2->read(); $creditArray = array(); if ($data2['multiticket'] == 1) { for ($i = 0; $i <= $data2["credit"]; $i++) { $creditArray[] = array("Value" => $i, "Text" => $i); } } else { $creditArray[] = array("Value" => 0, "Text" => 0); } $this->credit->DataSource = $creditArray; $this->credit->dataBind(); if ($data2['multiticket'] == 1) { $this->credit->setSelectedValue($data2['credit'] - $data['credit']); } else { $this->credit->setSelectedIndex(0); } $this->createDate->Value = $data['create_date']; $this->createBy->Text = $data['create_by']; $this->type->Text = $data2['name']; if (substr($data['start'], 0, 10) != "0000-00-00") { $date = explode("-", substr($data['start'], 0, 10)); $this->start->Date = $date[2] . "-" . $date[1] . "-" . $date[0]; } if (substr($data['end'], 0, 10) != "0000-00-00") { $date = explode("-", substr($data['end'], 0, 10)); $this->end->Date = $date[2] . "-" . $date[1] . "-" . $date[0]; } if (substr($data['start'], 11, 8) != "00:00:00") { $time = explode(":", substr($data['start'], 11, 8)); $this->start_hours->Text = $time[0]; $this->start_minutes->Text = $time[1]; $this->start_secondes->Text = $time[2]; } if (substr($data['end'], 11, 8) != "00:00:00") { $time = explode(":", substr($data['end'], 11, 8)); $this->end_hours->Text = $time[0]; $this->end_minutes->Text = $time[1]; $this->end_secondes->Text = $time[2]; } $this->status->setSelectedValue($data['status']); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->timecode->DataSource = $this->TimeCode; $this->timecode->dataBind(); $this->timecode->setSelectedIndex(0); $this->employeelst->DataSource = $this->EmployeeList; $this->employeelst->dataBind(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $this->departmentId->DataSource = $this->DepartmentList; $this->departmentId->dataBind(); $this->departmentId->setSelectedValue(0); $this->validator1->DataTextField = 'name'; $this->validator1->DataValueField = 'id'; $this->validator1->DataSource = $this->DataPerson; $this->validator1->dataBind(); $this->validator1->setSelectedValue(0); $this->validator11->DataTextField = 'name'; $this->validator11->DataValueField = 'id'; $this->validator11->DataSource = $this->DataPerson; $this->validator11->dataBind(); $this->validator11->setSelectedValue(0); $this->validator12->DataTextField = 'name'; $this->validator12->DataValueField = 'id'; $this->validator12->DataSource = $this->DataPerson; $this->validator12->dataBind(); $this->validator12->setSelectedValue(0); $this->validator2->DataTextField = 'name'; $this->validator2->DataValueField = 'id'; $this->validator2->DataSource = $this->DataPerson; $this->validator2->dataBind(); $this->validator2->setSelectedValue(0); $this->validator21->DataTextField = 'name'; $this->validator21->DataValueField = 'id'; $this->validator21->DataSource = $this->DataPerson; $this->validator21->dataBind(); $this->validator21->setSelectedValue(0); $this->validator22->DataTextField = 'name'; $this->validator22->DataValueField = 'id'; $this->validator22->DataSource = $this->DataPerson; $this->validator22->dataBind(); $this->validator22->setSelectedValue(0); $this->validator3->DataTextField = 'name'; $this->validator3->DataValueField = 'id'; $this->validator3->DataSource = $this->DataPerson; $this->validator3->dataBind(); $this->validator3->setSelectedValue(0); $this->validator31->DataTextField = 'name'; $this->validator31->DataValueField = 'id'; $this->validator31->DataSource = $this->DataPerson; $this->validator31->dataBind(); $this->validator31->setSelectedValue(0); $this->validator32->DataTextField = 'name'; $this->validator32->DataValueField = 'id'; $this->validator32->DataSource = $this->DataPerson; $this->validator32->dataBind(); $this->validator32->setSelectedValue(0); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $cmd = $this->db->createCommand("SELECT text FROM hr_helloworld"); $data = $cmd->query(); // N'ayant qu'une seule ligne dans notre table, nous ne lisons que la première ligne $data = $data->read(); //initialisation du champs helloworld $this->helloworld->Text = $data['text']; } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { if (isset($this->Request['id'])) { $userId = $this->Application->getUser()->getUserId(); $this->blockRecord('hr_horux_media_message', $this->Request['id'], $userId); $this->id->Value = $this->Request['id']; $this->setData(); } } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $param = $this->Application->getParameters(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->Save->setEnabled(false); $this->Apply->setEnabled(false); } } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $cmd = $this->db->createCommand(SQL::SQL_GET_HARDWARE_LINK2GROUP); $query = $cmd->query(); $recordSet2 = $query->readAll(); $this->readerRepeater->DataSource = $recordSet2; $this->readerRepeater->dataBind(); $this->Session['listBoxAccessTime'] = $this->listBox; } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $year = $this->Session['nonWorkingDayYear']; if ($year) { $this->year->setSelectedValue($year); } } else { $this->Session['nonWorkingDayYear'] = $this->year->getSelectedValue(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->timecode->DataSource = $this->TimeCode; $this->timecode->dataBind(); $this->employeelst->DataSource = $this->EmployeeList; $this->employeelst->dataBind(); $this->id->Value = $this->Request['id']; $this->setData(); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $employee = new employee(0); $this->defaultEventMinutes = $employee->getHoursByDay() / 2 * 60; } if (isset($this->Request['ajax'])) { $func = $this->Request['ajax']; $this->{$func}(); exit; } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $date = getDate(); if (Prado::getApplication()->getSession()->contains('nonWorkingDayYear')) { $this->until->setTimeStamp(mktime(0, 0, 0, 1, 1, $this->Session['nonWorkingDayYear'])); $this->from->setTimeStamp(mktime(0, 0, 0, 1, 1, $this->Session['nonWorkingDayYear'])); } else { $this->until->setTimeStamp(mktime(0, 0, 0, 1, 1, $date['year'])); $this->from->setTimeStamp(mktime(0, 0, 0, 1, 1, $date['year'])); } } }
public function onLoad($param) { parent::onLoad($param); if (!$this->IsPostBack) { $this->id->Value = $this->Request['id']; $this->setData(); } $param = $this->Application->getParameters(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->tbb->Save->setEnabled(false); $this->tbb->apply->setEnabled(false); } }
public function onLoad($param) { parent::onLoad($param); if (!$this->isPostBack) { $this->Session['dataPage'] = array(); $this->DataGrid->DataSource = $this->Data; $this->DataGrid->dataBind(); $this->defaultPage->DataTextField = 'pagename'; $this->defaultPage->DataValueField = 'page'; $this->defaultPage->DataSource = $this->DataPage; $this->defaultPage->dataBind(); $this->defaultPage->setSelectedValue('controlPanel.ControlPanel'); } }
public function onLoad($param) { parent::onLoad($param); $this->superUserList->DataSource = $this->SUList; $this->superUserList->dataBind(); $this->userList->DataSource = $this->UList; $this->userList->dataBind(); $param = $this->Application->getParameters(); $superAdmin = $this->Application->getUser()->getSuperAdmin(); if ($param['appMode'] == 'demo' && $superAdmin == 0) { $this->tbb->Save->setEnabled(false); $this->tbb->apply->setEnabled(false); } }