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'];
}