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);
}
}
