$payment->paiementid = 4; } $payment->num_paiement = ''; $payment_id = $payment->create($userpos, 1); $id = $payment->addPaymentToBank($userpos, 'payment', 'Dolipos', $fk_bank, '', ''); $facture->set_paid($userpos); $sql = "SELECT * FROM " . MAIN_DB_PREFIX . "facture order by rowid DESC limit 0,1"; $resql = $db->query($sql); $row = $db->fetch_array($resql); $sql = "INSERT INTO " . MAIN_DB_PREFIX . "pos_facture values ('',{$terminal},NULL,{$row['0']},NULL,NULL)"; $db->query($sql); } if ($action == "delete") { require_once DOL_DOCUMENT_ROOT . '/compta/paiement/class/paiement.class.php'; require_once DOL_DOCUMENT_ROOT . '/compta/bank/class/account.class.php'; $object = new Facturesim($db); $object->fetch($id); $object->set_unpaid('admin'); $sql = 'SELECT p.datep as dp, p.num_paiement, p.rowid, p.fk_bank,'; $sql .= ' c.code as payment_code, c.libelle as payment_label,'; $sql .= ' pf.amount,'; $sql .= ' ba.rowid as baid, ba.ref, ba.label'; $sql .= ' FROM ' . MAIN_DB_PREFIX . 'c_paiement as c, ' . MAIN_DB_PREFIX . 'paiement_facture as pf, ' . MAIN_DB_PREFIX . 'paiement as p'; $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'bank as b ON p.fk_bank = b.rowid'; $sql .= ' LEFT JOIN ' . MAIN_DB_PREFIX . 'bank_account as ba ON b.fk_account = ba.rowid'; $sql .= ' WHERE pf.fk_facture = ' . $id . ' AND p.fk_paiement = c.id AND pf.fk_paiement = p.rowid'; $sql .= ' ORDER BY p.datep, p.tms'; $result = $db->query($sql); if ($result) { $num = $db->num_rows($result); $objp = $db->fetch_object($result);
$resql = $db->query($sql); $rowterminal = $db->fetch_array($resql); if ($placenoid != "") { $sql = "SELECT rowid FROM " . MAIN_DB_PREFIX . "commande where ref='Place-{$placenoid}' and entity={$entity}"; $resql = $db->query($sql); $row = $db->fetch_array($resql); $place = $row[0]; } $object = new Commande($db); $res = $object->fetch($place); $user = new User($db); $user->fetch($userid); if (is_object($mc)) { $facture = new Facture($db); } else { $facture = new Facturesim($db); } if ($pay == "cash") { $object->mode_reglement_id = $rowterminal[2]; } else { $object->mode_reglement_id = $rowterminal[4]; } $facture->createFromOrder($object); $user->getrights(); if ($conf->stock->enabled) { $result = $facture->validate($user, '', $rowterminal[5]); } else { $result = $facture->validate($user, '', ''); } $object->delete($user); $payment = new Paiement($db);