function main($conn, $cmd)
{
if ($cmd == 'quit') {
@setcookie(@siduMD5('SIDUCONN'), '', -1);
@setcookie('SIDUSQL', '', -1);
} elseif ($cmd == 'close') {
$goto = @close_sidu_conn($_GET['id']);
if ($goto) {
return @header("Location: ./?id={$goto}");
}
} elseif ($cmd == @lang(1101)) {
if (@substr($_FILES['fconn']['type'], 0, 4) == 'text' && $_FILES['fconn']['size'] && !$_FILES['fconn']['error']) {
$err = @init_conn($conn, @file_get_contents($_FILES['fconn']['tmp_name']), $arrConn, $cmd);
} else {
$err = @lang(1102, 1);
}
} elseif ($cmd == @lang(1103) || $cmd == @lang(1104)) {
$err = @test_conn($conn);
if ($cmd == @lang(1104) && !$err) {
return @main_conn($conn);
} elseif (!$err) {
$err = "OK";
}
}
if ($cmd != "Open" && $conn['txt']) {
$err .= @init_conn($conn, @dec65($conn['txt'], 1), $arrConn, $cmd);
} elseif ((!$cmd || $cmd == 'quit' || $cmd == 'close') && !$conn['txt'] && $_COOKIE[@siduMD5('SIDUconnS')]) {
$err .= @init_conn($conn, @dec65($_COOKIE[@siduMD5('SIDUconnS')], 1), $arrConn, @lang(1101));
}
@uppe();
@main_form($conn, $arrConn, $err, $cmd);
@down();
}
function main($exp, $cmd)
{
global $SIDU;
if ($_GET['sql']) {
$cook = $SIDU['cook'][$SIDU[0]];
@tm_use_db($cook[1], $cook[2]);
$mode = "SQL";
$_GET['sql'] = @stripslashes($_GET['sql']);
} else {
$mode = "DB = {$SIDU['1']}" . ($SIDU[2] ? ".{$SIDU['2']}" : "");
}
@valid_data($SIDU, $exp, $cmd);
if ($cmd) {
@main_cout($SIDU, $exp, $mode);
} else {
@main_form($SIDU, $exp, $mode);
}
}
LEFT JOIN cash ON (c.id = cash.customerid)
LEFT JOIN divisions d ON (d.id = c.divisionid)
WHERE deleted = 0' . ($customer ? ' AND c.id = ' . $customer : '') . ($group ? ' AND ' . ($exclgroup ? 'NOT' : '') . '
EXISTS (SELECT 1 FROM customerassignments a
WHERE a.customergroupid = ' . $group . ' AND a.customerid = c.id)' : '') . ' GROUP BY c.id, c.lastname, c.name, c.address, c.zip, c.city, d.account, d.name, d.address, d.zip, d.city
HAVING COALESCE(SUM(cash.value), 0.00) < ? ORDER BY c.id', array(str_replace(',', '.', $balance)));
if (!$list) {
$SESSION->close();
die;
}
$_TITLE = ConfigHelper::getConfig('finances.pay_title', trans('Not set'));
$_LMARGIN = ConfigHelper::getConfig('finances.leftmargin', 0);
$_BMARGIN = ConfigHelper::getConfig('finances.bottommargin', 0);
require_once LIB_DIR . '/ezpdf.php';
$pdf = init_pdf('A4', 'landscape', trans('Form of Cash Transfer'));
$pdf->setLineStyle(2);
//$id = $pdf->getFirstPageId();
$count = sizeof($list);
$i = 0;
foreach ($list as $row) {
main_form(0, 0, $row);
main_form(0, 310, $row);
main_form(440, 0, $row);
main_form(440, 310, $row);
$i++;
//if($i < $count) $id = $pdf->newPage(1, $id, 'after');
if ($i < $count) {
$pdf->newPage();
}
}
close_pdf($pdf);
exit;
}
if (isset($_POST["SaveConf1"])) {
SaveConf1();
exit;
}
if (isset($_POST["restart-dnsmasq"])) {
restart_service();
exit;
}
if (isset($_GET["interfaces"])) {
interfaces();
exit;
}
if (isset($_GET["ffm1"])) {
main_form();
exit;
}
if (isset($_GET["addressesReload"])) {
echo Loadaddresses();
exit;
}
if (isset($_GET["DnsmasqDeleteInterface"])) {
DnsmasqDeleteInterface();
exit;
}
if (isset($_GET["listen_addresses"])) {
SaveListenAddress();
exit;
}
if (isset($_GET["DnsmasqDeleteListenAddress"])) {
function get_sape_links()
{
$lnk = dbConnect("", "", "");
$cat = 2665;
$top = 300;
$start = 0;
$ar1 = array('Купить ', 'Продажа ', '');
$ar2 = array(' в интернет-магазине', ' на ychebniki.ru', ' в интернет-магазине ychebniki.ru', '');
$query = "SELECT name as pname,translit as trans FROM ln_product_my ORDER BY id limit {$start},{$top}";
$res = exec_query($query);
$str = "";
$file = fopen('links.txt', 'w+');
$schet = 0;
while ($rows = fetch_array($res)) {
$ii = rand(0, 2);
$jj = rand(0, 3);
if ($ii == 2 && $jj == 3) {
$ii = $ii - 1;
}
$len = strlen($ar1[$ii]) + strlen($ar2[$jj]) + strlen($rows['pname']) + 7;
$str = $ar1[$ii] . "<a href=\"http://ychebniki.ru/products/getdetails/item/" . $rows['trans'] . "\">" . $rows['pname'] . "</a>" . $ar2[$jj] . "\r\n";
if ($len <= 100) {
fwrite($file, $str);
$schet++;
}
}
fclose($file);
dbDisconnect($lnk);
return main_form() . "<div>Обработано {$schet} строк</div>";
}
