Changeset 7013 for trunk/workflow/inc/class.so_orgchart.inc.php
- Timestamp:
- 08/15/12 09:58:35 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/workflow/inc/class.so_orgchart.inc.php
r6799 r7013 617 617 $this->_checkAccess($organizationID); 618 618 619 $query_fields = 'organizacao_id, localidade_id, centro_custo_id, descricao, empresa, endereco, complemento, cep, bairro, cidade, uf ';619 $query_fields = 'organizacao_id, localidade_id, centro_custo_id, descricao, empresa, endereco, complemento, cep, bairro, cidade, uf, externa'; 620 620 $query = "SELECT {$query_fields} FROM localidade WHERE organizacao_id = ? ORDER BY descricao"; 621 621 $result = $this->db->query($query, array($organizationID)); … … 623 623 624 624 $output = $result->GetArray(-1); 625 for ($i = 0; $i < count($output); $i++) 625 for ($i = 0; $i < count($output); $i++){ 626 626 for ($j = 0; $j < $result->_numOfFields; $j++) 627 627 unset($output[$i][$j]); 628 $output[$i]['centro_custo_id'] = empty($output[$i]['centro_custo_id']) ? 'NULL' : $output[$i]['centro_custo_id']; 629 } 628 630 629 631 return $output; … … 638 640 * @access public 639 641 */ 640 function addLocal($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state )641 { 642 $this->_checkAccess($organizationID); 643 644 $query = "INSERT INTO localidade(organizacao_id, centro_custo_id, descricao, empresa, endereco, complemento, cep, bairro, cidade, uf ) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";645 $result = $this->db->query($query, array($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state ));642 function addLocal($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state, $external ) 643 { 644 $this->_checkAccess($organizationID); 645 646 $query = "INSERT INTO localidade(organizacao_id, centro_custo_id, descricao, empresa, endereco, complemento, cep, bairro, cidade, uf, externa) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; 647 $result = $this->db->query($query, array($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state, $external )); 646 648 $this->_checkError($result); 647 649 … … 658 660 * @access public 659 661 */ 660 function updateLocal($organizationID, $costCenter, $description, $localID, $company, $address, $complement, $zipCode, $neighborhood, $city, $state )661 { 662 $this->_checkAccess($organizationID); 663 664 $query = "UPDATE localidade SET organizacao_id = ?, centro_custo_id = ?, descricao = ?, empresa = ?, endereco = ?, complemento = ?, cep = ?, bairro = ?, cidade = ?, uf = ? WHERE (localidade_id = ?)";665 $result = $this->db->query($query, array($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state, $ localID) );662 function updateLocal($organizationID, $costCenter, $description, $localID, $company, $address, $complement, $zipCode, $neighborhood, $city, $state, $external ) 663 { 664 $this->_checkAccess($organizationID); 665 666 $query = "UPDATE localidade SET organizacao_id = ?, centro_custo_id = ?, descricao = ?, empresa = ?, endereco = ?, complemento = ?, cep = ?, bairro = ?, cidade = ?, uf = ?, externa = ? WHERE (localidade_id = ?)"; 667 $result = $this->db->query($query, array($organizationID, $costCenter, $description, $company, $address, $complement, $zipCode, $neighborhood, $city, $state, $external, $localID) ); 666 668 $this->_checkError($result); 667 669
Note: See TracChangeset
for help on using the changeset viewer.