Changeset 6535 for trunk/workflow/inc/class.so_orgchart.inc.php
- Timestamp:
- 06/18/12 14:24:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/workflow/inc/class.so_orgchart.inc.php
r6490 r6535 128 128 $this->acl = &$GLOBALS['ajax']->acl; 129 129 $this->db = &Factory::getInstance('WorkflowObjects')->getDBWorkflow()->Link_ID; 130 $this->db = &Factory::getInstance('WorkflowObjects')->getDBWorkflow()->Link_ID;131 130 $this->db->SetFetchMode(ADODB_FETCH_ASSOC); 132 131 } … … 835 834 { 836 835 $this->_checkAccess($organizationID); 837 $this->validateDate($admDate); 836 if ($admDate!='') 837 $this->validateDate($admDate); 838 else 839 $admDate=NULL; 838 840 839 841 $query = 'SELECT area.sigla FROM funcionario, area WHERE (funcionario.area_id = area.area_id) AND (funcionario.funcionario_id = ?)'; … … 876 878 { 877 879 $this->_checkAccess($organizationID); 878 $this->validateDate($admDate); 880 if ($admDate!='') 881 $this->validateDate($admDate); 882 else 883 $admDate=NULL; 879 884 880 $query = "UPDATE funcionario SET area_id = ?, centro_custo_id = ?, localidade_id = ?, funcionario_status_id = ?, cargo_id = ?, nivel = ?, funcionario_categoria_id = ?, titulo = ?, apelido = ?, funcao = ?, data_admissao = ? WHERE (funcionario_id = ?) AND (organizacao_id = ?)"; 881 $result = $this->db->query($query, array($areaID, $costCenterID, $localID, $employeeStatusID, $jobTitleID, $level, $employeeCategoryID, $title,$nickname, $jobDesc, $admDate, $employeeID, $organizationID)); 882 $this->_checkError($result); 883 885 $query = "UPDATE funcionario SET area_id = ?, centro_custo_id = ?, localidade_id = ?, funcionario_status_id = ?, cargo_id = ?, nivel = ?, funcionario_categoria_id = ?, titulo = ?, apelido = ?, funcao = ?, data_admissao =? WHERE (funcionario_id = ?) AND (organizacao_id = ?)"; 886 887 $result = $this->db->query($query, array($areaID, $costCenterID, $localID, $employeeStatusID, $jobTitleID, $level, $employeeCategoryID, $title,$nickname, $jobDesc,$admDate, $employeeID, $organizationID)); 888 889 $this->_checkError($result); 890 884 891 return (($result === false) ? false : true); 885 892 }
Note: See TracChangeset
for help on using the changeset viewer.