public function getInitData($req) { $data = array(); $employees = new Employee(); $data['numberOfEmployees'] = $employees->Count("1 = 1"); $company = new CompanyStructure(); $data['numberOfCompanyStuctures'] = $company->Count("1 = 1"); $user = new User(); $data['numberOfUsers'] = $user->Count("1 = 1"); $project = new Project(); $data['numberOfProjects'] = $project->Count("status = 'Active'"); $attendance = new Attendance(); $data['numberOfAttendanceLastWeek'] = $attendance->Count("in_time > '" . date("Y-m-d H:i:s", strtotime("-1 week")) . "'"); if (empty($data['numberOfAttendanceLastWeek'])) { $data['numberOfAttendanceLastWeek'] = 0; } $empLeave = new EmployeeLeave(); $data['numberOfLeaves'] = $empLeave->Count("date_start > '" . date("Y-m-d") . "'"); $timeEntry = new EmployeeTimeEntry(); $data['numberOfAttendanceLastWeek'] = $timeEntry->Count("in_time > '" . date("Y-m-d H:i:s", strtotime("-1 week")) . "'"); $candidate = new Candidate(); $data['numberOfCandidates'] = $candidate->Count("1 = 1"); $job = new Job(); $data['numberOfJobs'] = $job->Count("status = 'Active'"); $course = new Course(); $data['numberOfCourses'] = $course->Count("1 = 1"); return new IceResponse(IceResponse::SUCCESS, $data); }
public function getDashboardItemData() { $data = array(); $company = new CompanyStructure(); $data['numberOfCompanyStuctures'] = $company->Count("1 = 1"); return $data; }
public function getChildCompanyStuctures($companyStructId) { $childIds = array(); $childIds[] = $companyStructId; $nodeIdsAtLastLevel = $childIds; $count = 0; do { $count++; $companyStructTemp = new CompanyStructure(); if (empty($nodeIdsAtLastLevel) || empty($childIds)) { break; } $idQuery = "parent in (" . implode(",", $nodeIdsAtLastLevel) . ") and id not in(" . implode(",", $childIds) . ")"; LogManager::getInstance()->debug($idQuery); $list = $companyStructTemp->Find($idQuery, array()); if (!$list) { LogManager::getInstance()->debug($companyStructTemp->ErrorMsg()); } $nodeIdsAtLastLevel = array(); foreach ($list as $item) { $childIds[] = $item->id; $nodeIdsAtLastLevel[] = $item->id; } } while (count($list) > 0 && $count < 10); return $childIds; }
public function actionAdmin() { $model = new CompanyStructure('search'); $model->unsetAttributes(); if (isset($_GET['CompanyStructure'])) { $model->setAttributes($_GET['CompanyStructure']); } $this->render('admin', array('model' => $model)); }
public function getCurrentEmployeeTimeZone() { $cemp = $this->getCurrentProfileId(); if (empty($cemp)) { return NULL; } $emp = new Employee(); $emp->Load("id = ?", array($cemp)); if (empty($emp->id) || empty($emp->department)) { return NULL; } $dept = new CompanyStructure(); $dept->Load("id = ?", array($emp->department)); return $dept->timezone; }
echo $form->dropDownList($model, 'type_id', GxHtml::listDataEx(CompanyStructureType::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'type_id'); ?> </div><!-- row --> <div class="row"> <?php echo $form->labelEx($model, 'location_id'); ?> <?php echo $form->dropDownList($model, 'location_id', GxHtml::listDataEx(Location::model()->findAllAttributes(null, true))); ?> <?php echo $form->error($model, 'location_id'); ?> </div><!-- row --> <label><?php echo GxHtml::encode($model->getRelationLabel('companyStructures')); ?> </label> <?php echo $form->checkBoxList($model, 'companyStructures', GxHtml::encodeEx(GxHtml::listDataEx(CompanyStructure::model()->findAllAttributes(null, true)), false, true)); ?> <?php echo GxHtml::submitButton('Save'); $this->endWidget(); ?> </div><!-- form -->
<?php $this->breadcrumbs = array($model->label(2) => array('index'), 'Manage'); $this->menu = array(array('label' => 'List' . ' ' . $model->label(2), 'url' => array('index')), array('label' => 'Create' . ' ' . $model->label(), 'url' => array('create'))); Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('company-structure-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n"); ?> <h1><?php echo 'Manage' . ' ' . GxHtml::encode($model->label(2)); ?> </h1> <p> You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done. </p> <?php echo GxHtml::link('Advanced Search', '#', array('class' => 'search-button')); ?> <div class="search-form"> <?php $this->renderPartial('_search', array('model' => $model)); ?> </div><!-- search-form --> <?php $this->widget('zii.widgets.grid.CGridView', array('id' => 'company-structure-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('id', 'name', array('name' => 'parent_id', 'value' => 'GxHtml::valueEx($data->parent)', 'filter' => GxHtml::listDataEx(CompanyStructure::model()->findAllAttributes(null, true))), array('name' => 'type_id', 'value' => 'GxHtml::valueEx($data->type)', 'filter' => GxHtml::listDataEx(CompanyStructureType::model()->findAllAttributes(null, true))), array('name' => 'location_id', 'value' => 'GxHtml::valueEx($data->location)', 'filter' => GxHtml::listDataEx(Location::model()->findAllAttributes(null, true))), 'create_at', array('class' => 'CButtonColumn'))));
<?php $this->breadcrumbs = array(CompanyStructure::label(2), 'Index'); //$this->mainT = 'AD'; //$this->subT = 'CS'; ?> <?php $this->beginWidget('yiiwheels.widgets.box.WhBox', array('title' => GxHtml::encode(CompanyStructure::label(2)), 'headerButtons' => array(TbHtml::buttonGroup(array(array('label' => 'Create', 'icon' => TbHtml::ICON_PLUS), array('label' => 'List', 'icon' => TbHtml::ICON_LIST, 'class' => 'active'), array('label' => 'Manage', 'icon' => TbHtml::ICON_WRENCH)), array('toggle' => TbHtml::BUTTON_TOGGLE_RADIO, 'color' => TbHtml::BUTTON_COLOR_PRIMARY)), ' ', TbHtml::buttonDropdown('More', array(array('label' => 'Update', 'url' => '#', 'icon' => TbHtml::ICON_EDIT), array('label' => 'Delete', 'url' => '#', 'icon' => TbHtml::ICON_TRASH), array('label' => 'Export', 'url' => '#', 'icon' => TbHtml::ICON_DOWNLOAD_ALT)))))); ?> <?php $this->widget('zii.widgets.CListView', array('dataProvider' => $dataProvider, 'itemView' => '_view')); $this->endWidget();
//include_once ("/usr/share/php/Mail.php"); include APP_BASE_PATH . 'lib/Mail.php'; include APP_BASE_PATH . 'adodb512/adodb.inc.php'; include APP_BASE_PATH . 'adodb512/adodb-active-record.inc.php'; $ADODB_ASSOC_CASE = 2; $user = getSessionObject('user'); include APP_BASE_PATH . "classes/BaseService.php"; include APP_BASE_PATH . "classes/FileService.php"; include APP_BASE_PATH . "classes/SubActionManager.php"; include APP_BASE_PATH . "classes/AbstractInitialize.php"; include APP_BASE_PATH . "classes/SettingsManager.php"; include APP_BASE_PATH . "classes/EmailSender.php"; include APP_BASE_PATH . "mysql_error_list.php"; include APP_BASE_PATH . "model/models.inc.php"; $dbLocal = NewADOConnection(APP_CON_STR); CompanyStructure::SetDatabaseAdapter($dbLocal); Country::SetDatabaseAdapter($dbLocal); Province::SetDatabaseAdapter($dbLocal); CurrencyType::SetDatabaseAdapter($dbLocal); JobTitle::SetDatabaseAdapter($dbLocal); ChucVu::SetDatabaseAdapter($dbLocal); PayGrade::SetDatabaseAdapter($dbLocal); EmploymentStatus::SetDatabaseAdapter($dbLocal); Skill::SetDatabaseAdapter($dbLocal); Education::SetDatabaseAdapter($dbLocal); Certification::SetDatabaseAdapter($dbLocal); Language::SetDatabaseAdapter($dbLocal); Nationality::SetDatabaseAdapter($dbLocal); Employee::SetDatabaseAdapter($dbLocal); User::SetDatabaseAdapter($dbLocal); EmployeeSkill::SetDatabaseAdapter($dbLocal);
<div class="row"> <?php echo $form->label($model, 'name'); ?> <?php echo $form->textField($model, 'name', array('maxlength' => 128)); ?> </div> <div class="row"> <?php echo $form->label($model, 'parent_id'); ?> <?php echo $form->dropDownList($model, 'parent_id', GxHtml::listDataEx(CompanyStructure::model()->findAllAttributes(null, true)), array('prompt' => 'All')); ?> </div> <div class="row"> <?php echo $form->label($model, 'type_id'); ?> <?php echo $form->dropDownList($model, 'type_id', GxHtml::listDataEx(CompanyStructureType::model()->findAllAttributes(null, true)), array('prompt' => 'All')); ?> </div> <div class="row"> <?php echo $form->label($model, 'location_id');