Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function CriarVenda($listaProdutos, $Total){
- // criando venda
- $sql = "INSERT INTO CADPEDIDO(PED_DATA, VALORTOTAL)VALUES(?,?)";
- $params = array(date('Y-m-d'), $Total);
- $query = sqlsrv_query($this->con->Conecta(), $sql, $params);
- //resgatar última venda
- $sql = "SELECT MAX(CODIGO) FROM CADPEDIDO";
- $query = sqlsrv_query($this->con->Conecta(), $sql) or die( print_r( sqlsrv_errors(), true));
- $ultimavenda = 0;
- if($reg = sqlsrv_fetch_array($query)){
- $ultimavenda = $reg[0];
- }
- foreach($listaProdutos as $p){
- $sql = "INSERT INTO CADITENSPEDIDO(ITEM_PEDIDO, ITEM_COD_PEDIDO,ITEM_QTD ITEM_PRECO)VALUES(?,?,?,?)";
- $params = array($ultimavenda, $p->Codigo, $p->Qtd_comprado, $p->SubTotal);
- $query = sqlsrv_query($this->con->Conecta(), $sql, $params);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement