db = $db; } public function getFacturas($tipo = 0, $limit = 10){ global $conf; $this->list_facturas = null; $num = 0; $sql = ""; switch ($tipo) { case 1: // Ultimas 10 Facturas Timbradas $sql = "SELECT"; $sql .= " f.rowid as fac_id, c.factura_id as cfdi_id, c.uuid, c.fecha_timbrado, c.selloCFD"; $sql .= " FROM ".MAIN_DB_PREFIX."facture AS f"; $sql .= " INNER JOIN ".MAIN_DB_PREFIX."cfdimx AS c ON c.fk_facture = f.rowid"; $sql .= " WHERE"; $sql .= " f.entity = ".$conf->entity; $sql .= " ORDER BY c.fecha_emision DESC"; if(abs($limit) > 0){ $sql .= " LIMIT ".abs($limit); } break; case 2: // Ultimas 10 Facturas No Timbradas $sql = "SELECT"; $sql .= " f.rowid as fac_id"; $sql .= " FROM ".MAIN_DB_PREFIX."facture AS f"; $sql .= " WHERE"; $sql .= " f.entity = ".$conf->entity; $sql .= " AND f.subtype IS NULL"; $sql .= " ORDER BY f.datef DESC"; if(abs($limit) > 0){ $sql .= " LIMIT ".abs($limit); } break; } if($sql != ""){ $resql = $this->db->query($sql); if($resql){ $num = $this->db->num_rows($resql); $i = 0; while ($i < $num) { $obj = $this->db->fetch_object($resql); $cfdi_id = ""; $uuid = ""; $fecha_timbrado = ""; $selloCFD = ""; if($tipo == 1){ $cfdi_id = $obj->cfdi_id; $uuid = $obj->uuid; $fecha_timbrado = $obj->fecha_timbrado; $selloCFD = $obj->selloCFD; } $this->list_facturas[] = array( "facture" => $obj->fac_id, "cfdi_id" => $cfdi_id, "uuid" => $uuid, "fecha_timbrado" => $fecha_timbrado, "selloCFD" => $selloCFD ); $i++; } }else{ // dol_print_error($db); } $this->db->free($resql); } // print $sql.'
'; return $num; } } ?>