示例#1
0
		FROM constancia c, provedor p
		WHERE c.exencion IN (' . implode(',', $d) . ')
			AND c.nit = p.nit
		ORDER BY c.exencion';
    $result = $update->query($sql);
    while ($row = odbc_fetch_array($result)) {
        $data[] = $row;
    }
    odbc_free_result($result);
}
$prov = array();
$ce = $cp = $cf = 0;
foreach ($data as $row) {
    $row = $update->trim($row);
    extract($row);
    list(, $year, $month, $day) = $update->preg_match('#([0-9]+)\\-([0-9]+)\\-([0-9]+)#si', $fec_exe);
    $cdate = gmmktime(6, 0, 0, $month, $day, $year);
    $cdate = $cdate > 0 ? $cdate : 0;
    $null = empty($concepto) || strstr(strtolower($concepto), 'nula') || !$nit ? true : false;
    $nit = !$null ? $nit : '0';
    $concepto = !$null ? strtoupper($concepto) : 'ANULADO';
    $insert = array('c_exe' => (int) $exencion, 'c_null' => $null, 'c_date' => (int) $cdate, 'c_nit' => $nit, 'c_text' => $concepto);
    $sql = 'INSERT INTO _constancia' . $db->sql_build_array('INSERT', $insert);
    echo $sql . '<br />';
    //	$db->sql_query($sql);
    $ce++;
    //
    if ($nit) {
        if (!$update->nit_exists($nit, $nombre)) {
            $insert = array('p_nit' => $nit, 'p_name' => $nombre);
            $sql = 'INSERT INTO _prov' . $db->sql_build_array('INSERT', $insert);