$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);
