PHP Facturesim::set_unpaid Examples

Example #1

File: loadhistory.php Project: LionSystemsSolutions/El-Canelo-ERP

    $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);
        $paiement = new Paiement($db);
        $paiement->fetch($objp->rowid);