public static function all($fields = '') { $fields = $fields ? $fields : implode(", ", array_keys(Empleado::$fields)); $sql = 'SELECT ' . $fields . ' FROM ' . Empleado::$table . " WHERE IND_EMPL = 1 AND CODIGO <> ' '"; $result = OracleEntityManager::runQuery($sql); $entities = []; $data = $result->fetchAll(); for ($i = 0; $i < count($data); $i++) { $empleado = new Empleado($data[$i]); $entities[] = $empleado; } //array_push($entities, new Empleado($data)); return $entities; }
public function salarioPromedio() { $sql = 'select * from( SELECT LAPSO_DOC, SUM(NMMOV_VALOR) as valor FROM NMRESUMEN_PAGOS_NOMINA WHERE ID_TERC=' . $this->data['cedula_empleado'] . ' AND ID_IND_DEV_DED = 1 AND ID_TIPO_DOC = \'NQ\' AND ID_CPTO != 673 GROUP BY LAPSO_DOC ORDER BY LAPSO_DOC DESC )where rownum <= 3'; $result = OracleEntityManager::runQuery($sql)->fetchAll(); $sum = 0; for ($i = 0; $i < count($result); $i++) { $sum += $result[$i]['VALOR']; } return $i > 0 ? $sum / $i : 0; }
public function estadoC() { $sql = 'SELECT ESTADO FROM (SELECT C.ESTADO FROM CONTRATOS C WHERE ID_TERC = \'' . $this->data['cedula'] . '\'' . 'ORDER BY FECHA_INGRESO DESC)where ROWNUM <= 1'; $result = OracleEntityManager::runQuery($sql)->fetch(); return $result['ESTADO']; }