/**
* Performs the work of inserting or updating the row in the database.
*
* If the object is new, it inserts it; otherwise an update is performed.
* All related objects are also updated in this method.
*
* @param PropelPDO $con
* @return int The number of rows affected by this insert/update and any referring fk objects' save() operations.
* @throws PropelException
* @see save()
*/
protected function doSave(PropelPDO $con)
{
$affectedRows = 0;
// initialize var to track total num of affected rows
if (!$this->alreadyInSave) {
$this->alreadyInSave = true;
// We call the save method on the following object(s) if they
// were passed to this object by their coresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aDepartment !== null) {
if ($this->aDepartment->isModified() || $this->aDepartment->isNew()) {
$affectedRows += $this->aDepartment->save($con);
}
$this->setDepartment($this->aDepartment);
}
if ($this->isNew()) {
$this->modifiedColumns[] = InstructorPeer::ID;
}
// If this object has been modified, then save it to the database.
if ($this->isModified()) {
if ($this->isNew()) {
$pk = InstructorPeer::doInsert($this, $con);
$affectedRows += 1;
// we are assuming that there is only 1 row per doInsert() which
// should always be true here (even though technically
// BasePeer::doInsert() can insert multiple rows).
$this->setId($pk);
//[IMV] update autoincrement primary key
$this->setNew(false);
} else {
$affectedRows += InstructorPeer::doUpdate($this, $con);
}
$this->resetModified();
// [HL] After being saved an object is no longer 'modified'
}
if ($this->collCourseInstructorAssociations !== null) {
foreach ($this->collCourseInstructorAssociations as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
if ($this->collInstructorDetails !== null) {
foreach ($this->collInstructorDetails as $referrerFK) {
if (!$referrerFK->isDeleted()) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->department_id));
}
}
$this->render('create', array('model' => $model));
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if ($model->save()) {
Yii::app()->user->setFlash('success', '创建成功');
$this->redirect(array('update', 'id' => $model->d_id));
}
}
$this->render('create', array('model' => $model));
}
/**
* Store a newly created branch in storage.
*
* @return Response
*/
public function store()
{
$validator = Validator::make($data = Input::all(), Department::$rules, Department::$messages);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$department = new Department();
$department->department_name = Input::get('name');
$department->organization_id = '1';
$department->save();
return Redirect::route('departments.index');
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if ($model->save()) {
$this->redirect(array('admin'));
}
}
$this->render('create', array('model' => $model));
}
public function executeAdd(sfWebRequest $request)
{
if ($request->isMethod('Post')) {
$department = new Department();
$department->setTitle($request->getParameter('title'));
//$department->setDescription($request->getParameter('description'));
$department->setStatus(Constant::RECORD_STATUS_ACTIVE);
$department->save();
$this->getUser()->setFlash('SUCCESS_MESSAGE', Constant::RECORD_ADDED_SUCCESSFULLY);
$this->redirect('Department/list');
}
//end if
}
/**
* Store a newly created resource in storage.
* POST /department
*
* @return Response
*/
public function store()
{
Input::merge(array_map('trim', Input::all()));
$input = Input::all();
$validation = Validator::make($input, Department::$rules);
if ($validation->passes()) {
$department = new Department();
$department->department = strtoupper(Input::get('department'));
$department->save();
return Redirect::route('department.index')->with('class', 'success')->with('message', 'Record successfully created.');
} else {
return Redirect::route('department.create')->withInput()->withErrors($validation)->with('class', 'error')->with('message', 'There were validation error.');
}
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if ($model->save()) {
$this->audit->logAudit(Yii::app()->user->id, new DateTime(), Constants::AUDITORIA_OBJETO_DEPARTAMENTO, Constants::AUDITORIA_OPERACION_ALTA, $model->id);
$this->render('/site/successfullOperation', array('header' => 'Departamento creado con éxito', 'message' => 'Haga click en volver para regresar a la gestión de departamentos', 'returnUrl' => Yii::app()->createUrl('department/admin'), 'viewUrl' => Yii::app()->createUrl("department/view", array("id" => $model->id))));
return;
}
}
$this->render('create', array('model' => $model));
}
public function actionCreate()
{
$model = new Department();
$model->company_id = $this->companyId;
if (Yii::app()->request->isPostRequest) {
$model->attributes = Yii::app()->request->getPost('Department');
$model->create_at = date('Y-m-d H:i:s', time());
$model->update_at = date('Y-m-d H:i:s', time());
if ($model->save()) {
Yii::app()->user->setFlash('success', yii::t('app', '添加成功'));
$this->redirect(array('department/index', 'companyId' => $this->companyId));
}
}
$printers = $this->getPrinterList();
$this->render('create', array('model' => $model, 'printers' => $printers));
}
function testFind()
{
//Arrange
$name = "Math";
$id = 1;
$test_department = new Department($name, $id);
$test_department->save();
$name2 = "Business";
$id2 = 2;
$test_department2 = new Department($name2, $id2);
$test_department2->save();
//Act
$id = $test_department->getId();
$result = Department::find($id);
//Assert
$this->assertEquals($test_department, $result);
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if (User::getMyCompany() == $model->company_id || Yii::app()->user->role == 1) {
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
} else {
throw new CHttpException(403, 'У вас закрыт доступ к редактированию этой организации');
}
}
$this->render('create', array('model' => $model));
}
public function store()
{
Auth::isAdminOrDie(App::$instance);
Token::checkToken();
$request = $this->request->request;
$this->validator->validate(['Префикс' => [$request->get('prefix'), 'required|int'], 'Название' => [$request->get('name'), 'required|max(255)']]);
//if no passes
if (!$this->validator->passes()) {
App::$instance->MQ->setMessage($this->validator->errors()->all());
ST::redirect("back");
}
$dep = new Department();
$dep->fill($request->all());
$dep->save();
App::$instance->MQ->setMessage("Успешно создано");
App::$instance->log->logWrite(LOG_CONFIG_CHANGE, 'Добавлено подразделение' . $dep->name);
ST::redirectToRoute('Departments/index');
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
$model->branch = Yii::app()->session->get('branch_id');
$model->created_by = Yii::app()->session->get('user_id');
$model->created_on = date('Y-m-d H:i:s');
$model->modified_by = Yii::app()->session->get('user_id');
$model->modified_on = date('Y-m-d H:i:s');
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
$model->attributes = $_POST['Department'];
if ($model->save()) {
date_default_timezone_set("Asia/Manila");
}
$activity = new Activity();
$activity->act_desc = 'Added Another Department';
$activity->act_datetime = date('Y-m-d G:i:s');
$activity->act_by = User::model()->findByPK(Yii::app()->user->name)->emp_id;
$activity->save();
$this->redirect(array('view', 'id' => $model->dept_id));
}
$this->render('create', array('model' => $model));
}
/**
* Store a newly created resource in storage.
* POST /department
*
* @return Response
*/
public function store()
{
$validator = Validator::make(Input::all(), Department::$rules);
$row = Department::where('id_dept', '=', Input::get('id_dept'));
if ($validator->fails()) {
return Redirect::to('department')->withErrors($validator)->withInput(Input::all());
} else {
if (Department::where('id_dept', '=', Input::get('id_dept'))->exists()) {
$department = Department::find(Input::get('id_dept'));
$department->nm_dept = Input::get('nm_dept');
$department->save();
Session::flash('message', 'Successfully updated Department!');
return Redirect::to('department');
} else {
$department = new Department();
$department->id_dept = Input::get('id_dept');
$department->nm_dept = Input::get('nm_dept');
$department->save();
Session::flash('message', 'Successfully created Department!');
return Redirect::to('department');
}
}
//
}
public function createAction()
{
if (!$this->request->isPost()) {
return $this->forward("companies/index");
}
$companies = new Department();
$companies->name = $this->request->getPost("name", "striptags");
if ($companies->name == '') {
$this->flash->error("名称不能为空");
return $this->forward("companies/new");
} else {
$companies->telephone = $this->request->getPost("telephone", "striptags");
$companies->city = $this->request->getPost("city", "striptags");
$companies->address = $this->request->getPost("address", "striptags");
$companies->contacts = $this->request->getPost("contacts", "striptags");
if (!$companies->save()) {
foreach ($companies->getMessages() as $message) {
$this->flash->error((string) $message);
}
return $this->forward("companies/new");
}
/*
$this->flash->success("部门信息保存成功");
return $this->forward("companies/search"); */
$this->response->redirect("companies/search");
}
}
/**
* Add a department to database with the passed name.
*/
public static function add($name)
{
$name = trim($name);
if ($name == '') {
return NQ::simple('intern', INTERN_WARNING, 'No name given for new major. No major was added.');
}
$db = self::getDb();
$db->addWhere('name', $name);
if ($db->select('count') > 0) {
NQ::simple('intern', INTERN_WARNING, "Department <i>{$name}</i> already exists.");
return;
}
// Create the new Department Obj.
$dept = new Department();
$dept->name = $name;
$dept->hidden = 0;
// Be sure to set a default value for this, otherwise it gets set to null and screws things up
$dept->corequisite = 0;
// Be sure to set a default value for this, otherwise it gets set to null and screws things up
$dept->save();
// Successfully saved department to DB. Alert user and remind them the department they just saved.
NQ::simple('intern', INTERN_SUCCESS, "Department <i>{$name}</i> added.");
}
private function updatesimple($typic, $grtype, $result, &$info)
{
if ($typic == 2) {
$sql = "SELECT a.id AS p_id, a.ckey AS p_key, a.cname AS p_name , a.lid AS p_lid " . " FROM tmp_xml a WHERE a.user="******" AND a.ctype=" . $typic;
} else {
$sql = "SELECT a.id AS p_id, a.ckey AS p_key, a.cname AS p_name , a.lid AS p_lid," . " b.id AS g_id, b.ckey AS g_key, b.cname AS g_name, b.lid as g_lid " . " FROM tmp_xml a LEFT JOIN tmp_xml b ON a.cgr=b.ckey AND b.user="******" AND b.ctype=" . $grtype . " WHERE a.user="******" AND a.ctype=" . $typic;
}
$recs = Yii::app()->db->createCommand($sql)->query();
//we got the records for tmp_xml table
$i = 0;
$j = 0;
$jj = 0;
if (count($recs) > 0) {
foreach ($recs as $value) {
$doprod = 0;
$doprodid = 0;
$edid = 0;
if ($value['p_lid'] === null) {
if ($result[$value['p_id']] === null) {
$doprod = -1;
$doprodid = 1;
} else {
$edid = (int) $result[$value['p_id']];
if ($edid > 0) {
$doprodid = 2;
$doprod = $edid;
} else {
$doprod = -1;
$doprodid = 1;
}
}
} else {
if ($result[$value['p_id']] === null) {
$doprod = $value['p_lid'];
} else {
$edid = $result[$value['p_id']];
if ($edid > 0) {
$doprodid = 3;
$doprod = $edid;
} else {
$doprod = -1;
$doprodid = 4;
}
}
}
$grid = 0;
if ($doprod < 0) {
if ($typic != 2) {
if ($value['g_lid'] === null) {
if ($typic == 0) {
$prodid = ProductgroupId::model()->findByPk(array('ckey' => $value['g_key'], 'db' => 1));
} else {
$prodid = CountryId::model()->findByPk(array('ckey' => $value['g_key'], 'db' => 1));
}
if ($prodid === null) {
if ($typic == 0) {
$group = new ProductGroup();
$group->tnam = $value['g_name'];
$group->save();
$grid = $group->ckey;
$groupid = new ProductgroupId();
} else {
$group = new Country();
$group->name = $value['g_name'];
$group->save();
$grid = $group->id;
$groupid = new CountryId();
}
$groupid->ckey = $value['g_key'];
$groupid->db = 1;
$groupid->id = $grid;
$groupid->save();
$i++;
} else {
$grid = $prodid->id;
}
} else {
$grid = $value['g_lid'];
}
} else {
$grid = 1;
}
if ($grid > 0) {
if ($typic == 0) {
$prod = new Product();
$prod->tnam = $value['p_name'];
$prod->cgr = $grid;
$it = TmpXml::model()->find('ctype=:ctype AND ckey=:ckey AND user=:user', array(':ctype' => 10, ':ckey' => $value['p_key'], ':user' => Yii::app()->user->uid));
if ($it) {
$prod->it = (int) $it->cname;
}
$prod->save();
$grid = $prod->ckey;
} else {
if ($typic == 1) {
$prod = new Client();
$prod->name = $value['p_name'];
$prod->country_id = $grid;
$prod->save();
$grid = $prod->id;
$this->updateprop($value['p_key'], $grid);
$this->updatebank($value['p_key'], $grid);
} else {
$prod = new Department();
$prod->name = $value['p_name'];
$prod->save();
$grid = $prod->id;
$this->updatebank($value['p_key'], $grid, 0);
}
}
$j++;
if ($doprodid == 1) {
if ($typic == 0) {
$prodid = new ProductId();
} else {
if ($typic == 1) {
$prodid = new ClientId();
} else {
$prodid = new DepartmentId();
}
}
$prodid->ckey = $value['p_key'];
$prodid->db = 1;
$prodid->id = $grid;
$prodid->save();
} else {
if ($typic == 0) {
$prodid = ProductId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
if ($typic == 1) {
$prodid = ClientId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
$prodid = DepartmentId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
}
}
if (!($prodid === null)) {
$prodid->id = $grid;
$prodid->save();
}
}
}
}
if ($doprodid == 2) {
if ($typic == 0) {
$prodid = new ProductId();
} else {
if ($typic == 1) {
$prodid = new ClientId();
} else {
$prodid = new DepartmentId();
}
}
$prodid->ckey = $value['p_key'];
$prodid->db = 1;
$prodid->id = $edid;
$prodid->save();
} else {
if ($doprodid == 3) {
if ($typic == 0) {
$prodid = ProductId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
if ($typic == 1) {
$prodid = ClientId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
} else {
$prodid = DepartmentId::model()->findByPk(array('ckey' => $value['p_key'], 'db' => 1));
}
}
if (!($prodid === null)) {
$prodid->id = $edid;
$prodid->save();
}
}
}
if ($doprod > 0) {
if ($typic == 0) {
$prod = Product::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->tnam != $value['p_name']) {
$prod->tnam = $value['p_name'];
$prod->save();
$jj = 0;
}
}
} else {
if ($typic == 1) {
$prod = Client::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->name != $value['p_name']) {
$prod->name = $value['p_name'];
$prod->save();
$jj = 0;
}
$this->updateprop($value['p_key'], $prod->id);
$this->updatebank($value['p_key'], $prod->id);
}
} else {
if (!($prop = DepartmentProp::model()->findByPk(array('id' => $doprod, '_key' => 'stop')))) {
$prod = Department::model()->findByPk($doprod);
if (!($prod === null)) {
if ($prod->name != $value['p_name']) {
$prod->name = $value['p_name'];
$prod->save();
$jj = 0;
}
}
$this->updatebank($value['p_key'], $doprod, 0);
}
}
}
}
}
}
if ($typic == 0) {
$info[] = 'Создано новых групп товаров:' . $i;
$info[] = 'Создано новых товаров:' . $j;
$info[] = 'Обновлено товаров:' . $jj;
} else {
if ($typic == 1) {
$info[] = 'Создано новых групп клиентов:' . $i;
$info[] = 'Создано новых клиентов:' . $j;
$info[] = 'Обновлено клиентов:' . $jj;
} else {
$info[] = 'Создано новых фирм:' . $j;
$info[] = 'Обновлено фирм:' . $jj;
}
}
return;
}
public function actionEditMolUser($table, $action, $id, $value)
{
switch ($table) {
case 'po_name':
switch ($action) {
case 'add':
$po_name = new po_name();
$po_name->po_name = $value;
$po_name->po_type_id = $id;
if ($po_name->save()) {
$result = 'ПО добавлено';
}
break;
case 'delete':
$po_name = po_name::findOne($id);
if ($po_name->active == '1') {
$po_name->active = '0';
} else {
$po_name->active = '1';
}
if ($po_name->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$po_name = po_name::findOne($id);
$po_name->po_name = $value;
if ($po_name->save()) {
$result = 'ПО переименовано';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'po_type':
switch ($action) {
case 'add':
$po_type = new po_type();
$po_type->po_type = $value;
if ($po_type->save()) {
$result = 'Тип ПО добавлен';
}
break;
case 'delete':
$po_type = po_type::findOne($id);
if ($po_type->active == '1') {
$po_type->active = '0';
} else {
$po_type->active = '1';
}
if ($po_type->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$po_type = po_type::findOne($id);
$po_type->po_type = $value;
if ($po_type->save()) {
$result = 'Тип ПО переименован';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'mol':
switch ($action) {
case 'add':
$mol = new mol();
$mol->value = $value;
if ($mol->save()) {
$result = 'МОЛ добавлено';
}
break;
case 'delete':
$mol = mol::findOne($id);
if ($mol->active == '1') {
$mol->active = '0';
} else {
$mol->active = '1';
}
if ($mol->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$mol = mol::findOne($id);
$mol->value = $value;
if ($mol->save()) {
$result = 'МОЛ переименовано';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'cpu':
switch ($action) {
case 'add':
$cpu = new cpu();
$cpu->name = $value;
if ($cpu->save()) {
$result = 'Процессор добавлен';
}
break;
case 'delete':
$cpu = cpu::findOne($id);
if ($cpu->active == '1') {
$cpu->active = '0';
} else {
$cpu->active = '1';
}
if ($cpu->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$cpu = cpu::findOne($id);
$cpu->name = $value;
if ($cpu->save()) {
$result = 'Процессор переименован';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'cartridge_type':
switch ($action) {
case 'add':
$type = new CartridgeType();
$type->type = $value;
if ($type->save()) {
$result = 'Тип картриджа добавлен';
}
break;
case 'delete':
$type = CartridgeType::find()->where(['type' => $id])->One();
if ($type->delete()) {
$result = 'Тип картриджа удален';
}
break;
case 'edit':
if ($value != '') {
$type = CartridgeType::find()->where(['type' => $id])->One();
$type->type = $value;
if ($type->update()) {
$result = 'Картридж переименован';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'consignment':
switch ($action) {
case 'add':
$consignment = new consignment();
$consignment->name = $value;
if ($consignment->save()) {
$result = 'Партия добавлена';
} else {
$result = 'Партия НЕ добавлена';
}
break;
case 'delete':
// $query_str = 'UPDATE consignment SET active = NOT active WHERE id = "'.$id.'"';
//$consignment = consignment::findOne($id);
//if ($consignment -> active == '1') $consignment -> active = '0'; else $consignment -> active = '1';
//$consignment -> save();
//$result = 'Статус изменен';
break;
case 'edit':
if ($value != '') {
$consignment = consignment::findOne($id);
$consignment->name = $value;
if ($consignment->save()) {
$result = 'Партия переименована';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'type':
switch ($action) {
case 'add':
$device_type = new deviceType();
$device_type->value = $value;
if ($device_type->save()) {
$result = 'Тип добавлен';
}
break;
case 'delete':
$device_type = deviceType::findOne($id);
if ($device_type->active == '1') {
$device_type->active = '0';
} else {
$device_type->active = '1';
}
if ($device_type->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$device_type = deviceType::findOne($id);
$device_type->value = $value;
if ($device_type->save()) {
$result = 'Тип переименован';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'mark':
switch ($action) {
case 'add':
$mark = new trademarks();
$mark->value = $value;
if ($mark->save()) {
$result = 'Марка добавлена';
}
break;
case 'delete':
$mark = mark::findOne($id);
if ($mark->active == '1') {
$mark->active = '0';
} else {
$mark->active = '1';
}
if ($mark->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
if ($value != '') {
$mark = mark::findOne($id);
$mark->value = $value;
if ($mark->save()) {
$result = 'Марка переименована';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'user':
switch ($action) {
case 'add':
$user = new user();
$user->name = $value;
$user->password = sha1('1');
if ($user->save()) {
$result = 'Сотрудник добавлен';
}
break;
case 'delete':
if ($value != '') {
$user = user::findOne($id);
if ($user->active == '1') {
$user->active = '0';
} else {
$user->active = '1';
}
if ($user->save()) {
$result = 'Статус изменен';
}
} else {
$result = 'Введите новое наименование!';
}
break;
case 'edit':
$user = user::findOne($id);
$user->name = $value;
if ($user->save()) {
$result = 'Сотрудник переименован';
}
break;
}
break;
case 'room':
switch ($action) {
case 'add':
$room = new room();
$room->value = $value;
$room->building_id = $id;
if ($room->save()) {
$result = 'Кабинет добавлен';
} else {
$result = print_r($room->getErrors());
}
break;
case 'delete':
$room = room::findOne($id);
if ($room->active == '1') {
$room->active = '0';
} else {
$room->active = '1';
}
$room->save();
//$result = 'Статус изменен';
$result = '';
break;
case 'edit':
if ($value != '') {
$room = room::findOne($id);
$room->value = $value;
if ($room->save()) {
$result = 'Кабинет переименован';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'device':
switch ($action) {
case 'add':
switch (substr($id, 0, 3)) {
case 'mrk':
$result = 'Марка не добавлена! Выберите тип устройства для добавления!';
break;
case 'typ':
$type_id = intval(substr($id, 4));
$trademark = new trademark();
$trademark->value = $value;
$TypeLinkMark = new TypeLinkMark();
$TypeLinkMark->type_id = $type_id;
$TypeLinkMark->mark_id = Yii::app()->db->getLastInsertID();
if ($TypeLinkMark->save() && $trademark->save()) {
$result = 'Марка добавлена';
}
break;
}
break;
case 'delete':
$device = new device();
$device->value = $value;
if ($device->save()) {
$result = 'Статус изменен';
}
break;
case 'edit':
$query_str = 'UPDATE user SET value = "' . $value . '" WHERE id = "' . $id . '"';
$result = 'Сотрудник переименован';
break;
}
break;
case 'model':
switch ($action) {
case 'add':
$model = new model();
$model->value = $value;
$model->save();
$result = 'Модель добавлена';
break;
case 'delete':
$model = model::findOne($id);
if ($model->active == '1') {
$model->active = '0';
} else {
$model->active = '1';
}
$model->save();
//$result = 'Статус изменен';
$result = '';
break;
case 'edit':
if ($value != '') {
$model = model::findOne($id);
$model->value = $value;
if ($model->save()) {
$result = 'Модель переименована';
}
} else {
$result = 'Введите новое наименование!';
}
break;
}
break;
case 'department':
switch ($action) {
case 'delete':
//$result = 'Статус изменен';
$department = department::findOne($id);
if ($department->active == '1') {
$department->active = '0';
} else {
$department->active = '1';
}
$department->save();
$result = '';
break;
case 'edit':
if ($value != '') {
$department = department::findOne($id);
$department->value = $value;
if ($department->save()) {
$result = 'Подразделение переименовано';
}
} else {
$result = 'Введите новое наименование!';
}
break;
case 'add':
$department = new Department();
$department->value = $value;
if ($department->save()) {
$result = 'Подразделение добавлено';
}
break;
}
break;
case 'building':
switch ($action) {
case 'delete':
$building = building::findOne($id);
if ($building->active == '1') {
$building->active = '0';
} else {
$building->active = '1';
}
$building->save();
//$result = 'Статус изменен';
$result = '';
break;
case 'edit':
if ($value != '') {
$building = building::findOne($id);
$building->value = $value;
if ($building->save()) {
$result = 'Здание переименовано';
}
} else {
$result = 'Введите новое наименование!';
}
break;
case 'add':
$building = new Building();
$building->value = $value;
$building->department_id = $id;
if ($building->save()) {
$result = 'Здание добавлено';
}
break;
}
break;
}
echo $result;
}
public function excelAction($path)
{
//phalcon向数据库导入的时候有点小问题，有default值的列需要赋值，不然这列的default值不会写入数据库
include '../app/classes/PHPExcel.php';
$this->view->disable();
$obj = new PHPExcel();
$name = '/home/sify/' . $path;
$type = PHPExcel_IOFactory::identify($name);
$reader = PHPExcel_IOFactory::createReader($type);
$obj = $reader->load($name);
//导入hospital子表
$sheet = $obj->getSheetByName('hospital');
for ($j = 2; $j <= $sheet->getHighestRow(); $j++) {
$hospital = new Hospital();
$hospital->id = $sheet->getCell('A' . $j)->getValue();
$hospital->name = (string) $sheet->getCell('B' . $j)->getValue();
$hospital->intro = (string) $sheet->getCell('C' . $j)->getValue();
$hospital->cityid = $sheet->getCell('D' . $j)->getValue();
$hospital->street = (string) $sheet->getCell('E' . $j)->getValue();
$hospital->tele = (string) $sheet->getCell('F' . $j)->getValue();
$hospital->level = (string) $sheet->getCell('G' . $j)->getValue();
$hospital->notice = (string) $sheet->getCell('H' . $j)->getValue();
$hospital->img = '/img/hospital/default.img';
$hospital->save();
}
//导入department子表
$sheet = $obj->getSheetByName('department');
for ($j = 2; $j <= $sheet->getHighestRow(); $j++) {
$department = new Department();
$department->id = $sheet->getCell('A' . $j)->getValue();
$department->h_id = $sheet->getCell('B' . $j)->getValue();
$department->type = (string) $sheet->getCell('C' . $j)->getValue();
$department->intro = (string) $sheet->getCell('D' . $j)->getValue();
$department->name = (string) $sheet->getCell('E' . $j)->getValue();
$department->dcount = 0;
$department->save();
}
//导入doctor子表
$sheet = $obj->getSheetByName('doctor');
for ($j = 2; $j <= $sheet->getHighestRow(); $j++) {
$doctor = new Doctor();
$doctor->id = $sheet->getCell('A' . $j)->getValue();
$doctor->name = (string) $sheet->getCell('B' . $j)->getValue();
$doctor->de_id = $sheet->getCell('C' . $j)->getValue();
$doctor->post = (string) $sheet->getCell('D' . $j)->getValue();
$doctor->intro = (string) $sheet->getCell('E' . $j)->getValue();
$doctor->specialty = (string) $sheet->getCell('F' . $j)->getValue();
$doctor->fee = $sheet->getCell('G' . $j)->getValue();
$doctor->img = '/img/doctor/default.img';
$doctor->save();
}
//导入available子表
$sheet = $obj->getSheetByName('available');
for ($j = 2; $j <= $sheet->getHighestRow(); $j++) {
$available = new Available();
$available->id = $sheet->getCell('A' . $j)->getValue();
$available->do_id = $sheet->getCell('B' . $j)->getValue();
$available->date = $sheet->getCell('C' . $j)->getFormattedValue();
$available->time = $sheet->getCell('D' . $j)->getValue();
$available->save();
}
echo '数据导入成功！';
}
/**
* Create new employee department choice
*
* @return mixed
*/
public function createDept()
{
$rules = ['name' => 'required|alpha_spaces'];
$v = Validator::make(Input::all(), $rules);
if ($v->fails()) {
return Redirect::back()->withErrors($v);
} else {
$dept = new Department();
$name = Input::get('name');
$dept->name = $name;
$dept->save();
return Redirect::route('manageDepartments')->with('flash_message', 'Department created');
}
}
function save()
{
$this->filter_access('Departement', 'roled_add', 'departments/index');
$dept = new Department();
$dept->dept_name = $this->input->post('dept_name');
if ($dept->save()) {
$this->session->set_flashdata('message', 'Departments successfully created!');
redirect('departments/');
} else {
// Failed
$dept->error_message('custom', 'Department Name required');
$msg = $dept->error->custom;
$this->session->set_flashdata('message', $msg);
redirect('departments/add');
}
}
/**
* Start browsing the directory and register files
*
* @return Exception code = 400 if directory non-existent
* An array containing list of non-imported files if successful
*/
public function doImport()
{
if (!file_exists($this->_dir)) {
throw new Exception("directory non-existent", 400);
}
$errArr = array();
$handler = opendir($this->_dir);
// TODO: does not do recrusive listing, do we need that?
while (false !== ($file = readdir($handler))) {
if ($file != '.' && $file != '..') {
$err = false;
$pos = strrpos($file, '.');
$fileName = strtoupper(substr($file, 0, $pos));
$token = strtok($fileName, '_');
$counter = 0;
while (false !== $token) {
switch ($counter) {
case 0:
if (strlen($token) != 7) {
$err = true;
}
$rawCourseCode = $token;
break;
case 1:
if ($token != substr($this->_year, 0, 4)) {
$err = true;
}
break;
case 2:
if ($token != "EXAM") {
if (substr($token, 0, 5) == "EXAM(") {
// name could have the following syntax: AER205S_2009_EXAM(2).pdf
$count = strtok($token, '(');
$count = strtok('(');
$count = strtok($count, ')');
if ($count === false || !is_numeric($count)) {
$err = true;
}
} else {
$err = true;
}
}
break;
}
$token = strtok("_");
$counter++;
}
if ($counter != 3 || $err) {
$err = true;
} else {
// assume course code is 7 chars in length with the last char being either S, F or Y
$part1 = substr($rawCourseCode, 0, 6);
//e.g. AER205
$part2 = substr($rawCourseCode, 6, 1);
//e.g. F
switch ($part2) {
case "F":
case "S":
$courseCode = $part1 . "H1";
$descr = $part1 . " " . $this->_year . " Official Exam" . (isset($count) ? ' (' . $count . ')' : '');
break;
case "Y":
$courseCode = $part1 . "Y1";
$descr = $part1 . " " . $this->_year . " Official Exam" . (isset($count) ? ' (' . $count . ')' : '');
break;
default:
$err = true;
break;
}
if (!$err) {
$conn = Propel::getConnection();
// check if we have exam of this descr already
$examArr = ExamPeer::getExamsForYearAndCourseId($courseCode, $this->_year, $conn);
foreach ($examArr as $ex) {
if ($ex->getType() == EnumItemPeer::EXAM && $ex->getDescr() == $descr) {
$err = true;
break;
}
}
if (!$err) {
// first check if course exists
$course = CoursePeer::retrieveByPK($courseCode, $conn);
if (!isset($course)) {
$course = new Course();
//$course->setDeptId(substr($courseCode, 0, 3));
$course->setDescr($courseCode);
$course->setIsEng(1);
$course->setId($courseCode);
$dept = DepartmentPeer::retrieveByPK(substr($courseCode, 0, 3), $conn);
if (!isset($dept)) {
$dept = new Department();
$dept->setId(substr($courseCode, 0, 3));
$dept->setDescr(substr($courseCode, 0, 3));
$dept->save($conn);
}
$course->setDepartment($dept);
$course->save($conn);
}
// register exam
$exam = new Exam();
$exam->setType(EnumItemPeer::EXAM);
$exam->setDescr($descr);
$exam->setCourseId($courseCode);
$exam->setFilePath($this->_dir . $file);
$exam->setYear($this->_year);
$exam->save();
}
}
}
if ($err) {
$errArr[] = $file;
}
}
}
closedir($handler);
return $errArr;
}
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
return View::make('admin.departmentnew', ['employeeInfo' => $employeeInfo]);
}));
//CREATE: NEW DEPARTMENT
Route::post('/admin/department/new', array('as' => 'adminProcessNewDepartment', 'uses' => function () {
//return 'Save New Department';
$data = Input::all();
$rules = array('department_name' => 'required');
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
$messages = $validator->messages();
return Redirect::to('/admin/department/new')->withErrors($validator);
} else {
$department = new Department();
$department->name = trim(ucwords($data['department_name']));
if ($department->save()) {
$message = 'Created Successfully.';
return Redirect::to('/admin/department/new')->with('message', $message);
}
}
}));
//UPDATE: EXISTING DEPARTMENT
Route::get('/admin/department/edit/{id}', array('as' => 'adminEditDepartment', 'uses' => function ($id) {
$id = (int) $id;
$employeeId = Session::get('userEmployeeId');
$userId = Session::get('userId');
$employee = new Employee();
$employeeInfo = $employee->getEmployeeInfoById($employeeId);
//return 'Update Department';
return View::make('admin.departmentedit', array('id' => $id, 'employeeInfo' => $employeeInfo));
}));
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionImport()
{
$model = new Department();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Department'])) {
if (!empty($_FILES)) {
$tempFile = $_FILES['Department']['tmp_name']['fileImport'];
$fileTypes = array('xls', 'xlsx');
// File extensions
$fileParts = pathinfo($_FILES['Department']['name']['fileImport']);
if (in_array(@$fileParts['extension'], $fileTypes)) {
Yii::import('ext.heart.excel.EHeartExcel', true);
EHeartExcel::init();
$inputFileType = PHPExcel_IOFactory::identify($tempFile);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($tempFile);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
$baseRow = 2;
$inserted = 0;
$read_status = false;
while (!empty($sheetData[$baseRow]['A'])) {
$read_status = true;
//$department_id= $sheetData[$baseRow]['A'];
$name = $sheetData[$baseRow]['B'];
$model2 = new Department();
//$model2->department_id= $department_id;
$model2->name = $name;
try {
if ($model2->save()) {
$inserted++;
}
} catch (Exception $e) {
Yii::app()->user->setFlash('error', "{$e->getMessage()}");
//$this->refresh();
}
$baseRow++;
}
Yii::app()->user->setFlash('success', $inserted . ' row inserted');
} else {
Yii::app()->user->setFlash('warning', 'Wrong file type (xlsx, xls, and ods only)');
}
}
$this->render('admin', array('model' => $model));
} else {
$this->render('admin', array('model' => $model));
}
}
public function save_department()
{
$id = Input::get('id');
$store_id = Input::get('store_id');
$department = Department::find($id);
if (!$department) {
$department = new Department();
}
$department->name = Input::get('name');
$department->store_id = $store_id;
$department->save();
$message = "Successfully updated the department";
$type = "success";
return Redirect::to('/admin/store/' . $store_id . '/departments')->with('type', $type)->with('message', $message);
}
}
$c->save();
echo "Category: {$c->getName()}\n";
}
// Now that we've got People and Categories in the database,
// Link the Departments with their Categories and Default Person
$result = $mongo->departments->find();
foreach ($result as $r) {
$d = new Department($r['name']);
if (!empty($r['defaultPerson']['_id'])) {
$id = getPersonIdFromCrosswalk($r['defaultPerson']['_id']);
$d->setDefaultPerson_id($id);
}
if (!empty($r['categories'])) {
$ids = array();
foreach ($r['categories'] as $c) {
try {
$category = new Category($c['name']);
$ids[] = $category->getId();
} catch (Exception $e) {
// Departments may have old categories we have deleted
// Just ignore them
}
}
$d->setCategories($ids);
}
$d->save();
$p = $d->getDefaultPerson();
$p = $p ? $p->getFullname() : '';
echo "Department: {$d->getName()} Person: {$p}\n";
}
function processvariablesAction()
{
$session = SessionWrapper::getInstance();
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(TRUE);
$formvalues = $this->_getAllParams();
// debugMessage($formvalues); // exit;
if (isArrayKeyAnEmptyString('noreload', $formvalues)) {
$hasnoreload = false;
} else {
$hasnoreload = true;
}
$haserror = false;
if (isArrayKeyAnEmptyString('value', $formvalues) && !$hasnoreload) {
$haserror = true;
$session->setVar(ERROR_MESSAGE, 'Error: No value specified for addition');
$session->setVar(FORM_VALUES, $formvalues);
$this->_helper->redirector->gotoUrl($this->view->baseUrl('config/variables/' . $formvalues['lookupid']));
}
$successurl = $this->view->baseUrl('config/variables/type/' . $formvalues['lookupid']);
$type_ext = '';
$alias = '';
if (!isArrayKeyAnEmptyString('alias', $formvalues)) {
$alias = trim($formvalues['alias']);
if ($alias == 'undefined') {
$alias = '';
}
}
if ($formvalues['lookupid'] == 7) {
$alias = decode($formvalues['alias']);
if (isArrayKeyAnEmptyString('id', $formvalues)) {
$alias = $formvalues['alias'];
}
}
// exit;
// debugMessage()
switch ($formvalues['lookupid']) {
case 9:
$formvalues['defaultamount'] = $formvalues['alias'];
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$formvalues['defaultamount'] = decode($formvalues['alias']);
}
$formvalues['amounttype'] = $formvalues['alias2'];
$formvalues['name'] = decode(trim($formvalues['value']));
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$formvalues['name'] = $formvalues['name'];
}
$formvalues['companyid'] = getCompanyID();
$benefittype = new BenefitType();
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$benefittype->populate($formvalues['id']);
$formvalues['lastupdatedby'] = $session->getVar('userid');
} else {
$formvalues['createdby'] = $session->getVar('userid');
}
$benefittype->processPost($formvalues);
/* debugMessage($benefittype->toArray());
debugMessage('errors are '.$benefittype->getErrorStackAsString()); exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($benefittype->hasError()) {
$session->setVar(ERROR_MESSAGE, $benefittype->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $benefittype->getErrorStackAsString();
} else {
try {
$benefittype->save();
// debugMessage($benefittype->toArray()); exit;
$result = array('id' => $benefittype->getID(), 'name' => $benefittype->getName(), 'alias' => $benefittype->getdefaultamount(), 'alias2' => $benefittype->getamounttype());
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $benefittype->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $benefittype->getErrorStackAsString();
}
}
break;
case 11:
$formvalues['name'] = trim($formvalues['value']);
$department = new Department();
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$department->populate($formvalues['id']);
$formvalues['lastupdatedby'] = $session->getVar('userid');
} else {
$formvalues['createdby'] = $session->getVar('userid');
}
$formvalues['companyid'] = getCompanyID();
$department->processPost($formvalues);
/* debugMessage($department->toArray());
debugMessage('errors are '.$department->getErrorStackAsString()); // exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($department->hasError()) {
$session->setVar(ERROR_MESSAGE, $department->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $department->getErrorStackAsString();
} else {
try {
$department->save();
$result = array('id' => $department->getID(), 'name' => $department->getName(), 'error' => '');
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $department->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $department->getErrorStackAsString();
}
}
break;
default:
$lookupvalue = new LookupTypeValue();
$lookuptype = new LookupType();
$lookuptype->populate($formvalues['lookupid']);
$index = '';
if ($hasnoreload) {
$index = $lookuptype->getNextInsertIndex();
$value = trim($formvalues['value']);
} else {
if (!isArrayKeyAnEmptyString('index', $formvalues)) {
$index = $formvalues['index'];
} else {
$index = $lookuptype->getNextInsertIndex();
}
$value = addslashes(decode(trim($formvalues['value'])));
}
$dataarray = array('id' => $formvalues['id'], 'lookuptypeid' => $formvalues['lookupid'], 'lookuptypevalue' => $index, 'lookupvaluedescription' => $value, 'alias' => $alias, 'createdby' => $session->getVar('userid'), 'companyid' => getCompanyID());
// debugMessage($dataarray);
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$lookupvalue->populate($formvalues['id']);
$beforesave = $lookupvalue->toArray();
// debugMessage($beforesave);
}
// unset($dataarray['id']);
$lookupvalue->processPost($dataarray);
/* debugMessage($lookupvalue->toArray());
debugMessage('errors are '.$lookupvalue->getErrorStackAsString()); exit(); */
$result = array('id' => '', 'name' => '', 'error' => '');
if ($lookupvalue->hasError()) {
$haserror = true;
$session->setVar(ERROR_MESSAGE, $lookupvalue->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
$result['error'] = $lookupvalue->getErrorStackAsString();
} else {
try {
$lookupvalue->save();
if (!$hasnoreload) {
$url = $this->view->serverUrl($this->view->baseUrl("config/variables/lookupid/" . $formvalues['lookupid']));
$module = '0';
if (isArrayKeyAnEmptyString('id', $formvalues)) {
$session->setVar(SUCCESS_MESSAGE, "Successfully saved");
$type = SYSTEM_ADDVARIABLE;
$usecase = '0.1';
$details = 'Variable - <b>' . $lookupvalue->getlookupvaluedescription() . ' </b>(' . $lookupvalue->getLookupType()->getdisplayname() . ') addded';
} else {
$session->setVar(SUCCESS_MESSAGE, "Successfully updated");
$type = SYSTEM_UPDATEVARIABLE;
$usecase = '0.2';
$details = 'Variable - <b>' . $lookupvalue->getlookupvaluedescription() . ' </b>(' . $lookupvalue->getLookupType()->getdisplayname() . ') updated';
$prejson = json_encode($beforesave);
$lookupvalue->clearRelated();
$after = $lookupvalue->toArray();
// debugMessage($after);
$postjson = json_encode($after);
// debugMessage($postjson);
$diff = array_diff($beforesave, $after);
// debugMessage($diff);
$jsondiff = json_encode($diff);
// debugMessage($jsondiff);
}
$browser = new Browser();
$audit_values = $session->getVar('browseraudit');
$audit_values['module'] = $module;
$audit_values['usecase'] = $usecase;
$audit_values['transactiontype'] = $type;
$audit_values['status'] = "Y";
$audit_values['userid'] = $session->getVar('userid');
$audit_values['transactiondetails'] = $details;
$audit_values['url'] = $url;
if (!isArrayKeyAnEmptyString('id', $formvalues)) {
$audit_values['isupdate'] = 1;
$audit_values['prejson'] = $prejson;
$audit_values['postjson'] = $postjson;
$audit_values['jsondiff'] = $jsondiff;
}
// debugMessage($audit_values);
$this->notify(new sfEvent($this, $type, $audit_values));
}
$result = array('id' => $lookupvalue->getlookuptypevalue(), 'name' => $lookupvalue->getlookupvaluedescription(), 'alias' => $lookupvalue->getalias(), 'error' => '');
} catch (Exception $e) {
$session->setVar(ERROR_MESSAGE, $e->getMessage() . "<br />" . $lookupvalue->getErrorStackAsString());
$session->setVar(FORM_VALUES, $formvalues);
}
}
break;
}
// debugMessage($successurl);exit();
if (!$hasnoreload) {
$this->_helper->redirector->gotoUrl($successurl);
} else {
echo json_encode($result);
}
}
function test_getCourses()
{
//Arrange
$test_department = new Department("Biology", "346 Stupid Avenue");
$test_department->save();
$name = "History 0001";
$code = "HS001";
$test_course = new Course($name, $code, $test_department->getId());
$test_course->save();
$name2 = "Dogs 101";
$code2 = "DW101";
$test_course2 = new Course($name2, $code2, $test_department->getId());
$test_course2->save();
//Act
$result = $test_department->getCourses();
//Assert
$this->assertEquals([$test_course, $test_course2], $result);
}
public function actionSavedepartment()
{
$organid = $this->Getorganid();
if (empty($_POST['departid'])) {
$department = new Department();
$department->DepartmentName = $_POST['departmentName'];
$department->ParentID = $_POST['parentID'];
$department->Describe = $_POST['describe'];
$department->OrganID = $organid['OrganID'];
$department->UserID = Yii::app()->user->id;
$department->CreateTime = time();
$result = $department->save();
} else {
$department = Department::model()->findByPk($_POST['departid']);
$department->DepartmentName = $_POST['departmentName'];
$department->ParentID = $_POST['parentID'];
$department->Describe = $_POST['describe'];
$department->UserID = Yii::app()->user->id;
$department->UpdateTime = time();
$result = $department->save();
}
if ($result) {
$message = "保存成功";
} else {
$message = "保存失败";
}
echo json_encode($message);
}
