Guest User

Untitled

a guest
Jul 19th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. public function list_minimos_get(){
  2.  
  3. $query = $this->db->query("SELECT F_STO.ARTSTO, F_ART.DESART, F_ART.EQUART, F_STO.MINSTO, F_STO.ACTSTO
  4. FROM (F_STO
  5. LEFT JOIN F_ART ON F_STO.ARTSTO = F_ART.CODART)
  6. WHERE F_STO.ACTSTO<F_STO.MINSTO
  7. AND F_STO.ARTSTO LIKE 'T%';
  8. ");
  9.  
  10. $respuesta = array(
  11.  
  12. 'error' => FALSE,
  13. 'stock' => $query->result_array()
  14. );
  15.  
  16.  
  17. $this->response($respuesta);
  18.  
  19.  
  20. }
Add Comment
Please, Sign In to add comment