Example #1
0
function test_releve_exist($idreleve, $idcompte)
{
    global $db;
    $date_releve = $db->QuerySingleValue0("SELECT MAX(date_releve )FROM tresori_onape where id_compte={$idcompte}");
    $montant = $db->QuerySingleValue0("SELECT montant FROM tresori_onape WHERE date_releve='{$date_releve}'and id_compte={$idcompte}");
    if ($montant != "0") {
        editcompte($idcompte, $montant, $date_releve);
        return true;
    } else {
        editcompte($idcompte, 0, "0000-00-00");
        return false;
    }
}
Example #2
0
<?php

if (tp('verif') == 1) {
    global $db;
    model::load('tresorie', 'addrelve');
    $id = tp('compte');
    $date = tp('date');
    $date1 = date('Y-m-d', strtotime($date));
    //$datetime = new DateTime($date1);
    if ($db->QuerySingleValue0("select id from tresori_onape where date_releve='{$date1}' and id_compte={$id}") != 0) {
        exit("3");
    }
    if (!addrelve(tp('compte'), tp('date'), tp('montant'))) {
        exit("0");
    } else {
        $date_releve = $db->QuerySingleValue0("SELECT MAX(date_releve )FROM tresori_onape where id_compte={$id}");
        $montant = $db->QuerySingleValue0("SELECT montant FROM tresori_onape WHERE date_releve='{$date_releve}'and id_compte={$id}");
        editcompte($id, $montant, $date_releve);
        exit("1");
    }
} else {
    view::load('tresorie', 'addrelvee');
}