コード例 #1
0
include_once "../login.php";
error_reporting(E_ERROR);
$db = appUtils::getDB();
$result = array();
$action = isset($_REQUEST["action"]) && $_REQUEST["action"] ? $_REQUEST["action"] : "";
switch ($action) {
    case "nuovi_oneri":
        $data_inizio = $_REQUEST["inizio"];
        $sqlData = "SELECT code,zona,c_1,c_2,c_3,c_4,c_5,c_6,c_7,c_8,c_9,c_10,c_11,c_12,c_13,c_14,c_15,c_16,c_17,c_18,c_19,c_20,'{$data_inizio}'::date as inizio_validita FROM oneri.tabella_b WHERE inizio_validita = (SELECT max(inizio_validita) from oneri.tabella_b)";
        $data = $db->fetchAll($sqlData);
        foreach ($data as $v) {
            $db->insert("oneri.tabella_b", $v);
        }
        break;
    case "checkModelli":
        $value = isset($_REQUEST["id"]) && $_REQUEST["id"] ? $_REQUEST["id"] : "%";
        $sql = "SELECT id,nome FROM stp.e_modelli WHERE id::varchar ilike ?";
        $res = $db->fetchAll($sql, array($value), 0);
        for ($i = 0; $i < count($res); $i++) {
            $nome = $res[$i]["nome"];
            $text = appUtils::unzip(MODELLI, $nome);
            $err = appUtils::getDocxErrors($text);
            $result[$res[$i]["id"]] = $err;
        }
        break;
    default:
        break;
}
print json_encode($result);
return;