Example #1
0
File: func.php Project: qquk/IBAG
function dw_transport_cap($trans)
{
    $query = "select tl.id, tl.number, tl.trtype, tl.trvolume, tl.trweight, tl.owner_id,\n         tl.scomment, tl.transdate,\ttl.sourcediv_id, tl.destdiv_id, tl.transname_id,\n         tt.tname, tt.ttimage, ownerd.divname as ownername, sdiv.divname as sdivname,\n         ddiv.divname as ddivname, tn.transname\n       from translist tl, transtype tt, {$dbname}.div ownerd, {$dbname}.div sdiv,\n            {$dbname}.div ddiv, transname tn\n       where tl.id={$trans} and tl.trtype=tt.transtype_id and\n             tl.owner_id=ownerd.div_id and tl.sourcediv_id=sdiv.div_id\n             and tl.destdiv_id=ddiv.div_id and tl.transname_id=tn.transname_id";
    $res = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($res);
    $q2 = "select * from transport where translist_id={$trans}";
    $r2 = mysql_query($q2) or die(mysql_error());
    while ($rowt = mysql_fetch_array($r2)) {
        $trstr = $trstr . " [ " . $rowt[transinfo] . " ] ";
    }
    echo "\n\n      <table cellpadding=0 cellspacing=0 border=0 width=100%>\n      <tr>\n       <td class=letlistdata2>\n\n       <table cellpadding=0 cellspacing=0 border=0>\n       <tr>\n        <td width=80 valign=middle align=center>\n         <image src='" . $row['ttimage'] . "'>\n        </td>\n        <td>\n\n          <table cellpadding=0 cellspacing=0 border=0 width=100% valign=top>\n          <tr><td height=5></td></tr>\n          <tr valign=top>\n           <td valign=top style='font-family:Tahoma;font-size:9pt;color:#000000;'>\n            {$row['tname']} №<b>{$row['number']}</b> от " . n_date($row['transdate']) . "\n           </td>\n          </tr>\n          <tr valign=top>\n           <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n            <font style='color=#AAAAAA;'>Маршрут: </font>" . get_div_parent($row['sourcediv_id']) . "&nbsp; . <b>{$row['sdivname']}</b> -> " . get_div_parent($row['destdiv_id']) . "&nbsp; . <b>{$row['ddivname']}</b>\n           </td>\n          </tr>\n          <tr valign=top>\n           <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n            <font style='color=#AAAAAA;'>Включенные загрузки: </font> {$trstr}\n           </td>\n          </tr>\n          <tr valign=top>\n           <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n            <font style='color=#AAAAAA;'>Подразделение: </font> {$row['ownername']}\n           </td>\n          </tr>\n          <tr valign=top>\n           <td valign=top style='font-family:Tahoma;font-size:8pt;color:#333333;'>\n            <font style='color=#AAAAAA;'>Название: </font> <b>{$row['transname']}</b>\n           </td>\n          </tr>\n          <tr><td height=5></td></tr>\n          </table>\n\n        </td>\n       </tr>\n       </table>\n\n       <td>\n      </tr>\n      </table>\n\n ";
    mysql_free_result($res);
    mysql_free_result($r2);
}
Example #2
0
echo " class='main_oper_list_cap' height=18 valign=middle>&nbsp;  »тоговые суммы</td>\n\t\t  </tr>\n\t\t  <tr><td height=1></td></tr>\n\t\t  </table>";
$query = "select distinct sourcediv_id from letters l, {$dbname}.div dd, {$dbname}.div sd,clients cl, payee p\n          where  l.sourcediv_id=sd.div_id and l.client_id=cl.client_id and l.div_id=dd.div_id and l.payee_id=p.payee_id ";
if (!isset($_GET['head'])) {
    require "oper/letters/search_add_query_ctrl.php";
} else {
    require "letters/search_add_query_ctrl.php";
}
$query .= "  order by sd.divname desc";
$res = mysql_query($query) or die(mysql_error());
$query = "select max(faxno) from {$dbname}.div ";
$res1 = mysql_query($query) or die(mysql_error());
$row1 = mysql_fetch_row($res1);
echo "\n        \t<table width=100%>\n\t\t\t<tr>\n            \t<td colspan=4 class='main_oper_list_cap'>\n                \t&nbsp; »тоговые суммы передачи\n                </td>\n            </tr>";
$sum = 0;
while ($row = mysql_fetch_array($res)) {
    $sourcedivname = get_div_parent($row['sourcediv_id']) . ' . <b>' . get_div_name($row['sourcediv_id']) . '</b>';
    $sourcedivsumm = number_format(get_full_letter_summ_bysourcediv($row['sourcediv_id']), 2, '.', ' ');
    echo "\n            <tr>\n\t\t\t <td ";
    echo " align=right class='total_oper_text' style='background-color:#FEFEFE' valign=center width=50%>\n\t\t\t  {$sourcedivname}  &nbsp;\n\t\t\t </td>\n\t\t\t <td class='total_oper_num' style='background-color:#FEFEFE' valign=center width=20% align=right>\n\t\t\t  <b>{$sourcedivsumm}</b>\n\t\t\t </td>\n             ";
    $sum += get_full_letter_summ_bysourcediv($row['sourcediv_id']);
    if (!isset($_GET['sel_search_letter'])) {
        echo "\n             <td  align=right class='total_oper_text' style='background-color:#EEEEEE' valign=center width=10%>\n\t\t\t  <b>є факса  &nbsp;</b>\n\t\t\t </td>\n             \t<td  align=right class='total_oper_text' style='background-color:#EEEEEE' valign=center width=20%>\n                <input type=text id=fax_no[] name=fax_no[] style='BORDER-RIGHT: #707052 1px solid;BORDER-TOP: #707052 1px solid ;BORDER-LEFT: #707052 1px solid;BORDER-BOTTOM: #707052 1px solid;width:150 ;height:20;color:black;font-family:Tahoma;text-align:right;text-valign:middle;font-size=13;font-weight:bolder;' value='";
        $row1[0]++;
        echo $row1[0] . "'>";
        echo "\n\n                <input type=hidden id=fax_no_id[] name=fax_no_id[] value='" . $row['sourcediv_id'] . "'>\n\t\t\t </td>";
    }
    echo "\n\t\t\t</tr>\n            ";
}
echo "\n            <tr>\n            \t<td class='total_oper_num' align=right>\n                \t<b>»“ќ√ќ</b>\n                </td>\n                <td class='total_oper_num' align=right>\n                \t<b>{$sum}</b>\n                </td>\n                <td colspan=2 ";
if (!isset($_GET['sel_search_letter'])) {
    echo " class='total_oper_num'";
Example #3
0
    $r = mysql_query($q);
    $rr = mysql_fetch_array($r);
    $sdiv_id = $rr[0];
    $ddiv_id = $rr[1];
    mysql_free_result($r);
    $str = "Отгруженный багаж на транспорт <b>" . get_trans($trs) . "</b> по пункту приёма: " . get_div_parent($st) . " . <b>" . get_div_name($st) . "</b>";
    $query2 = "where p.client_id=c.client_id and t.ibtbarcode=m.barcode and\n            t.ibtsourcediv_id={$st} and m.trans_id={$trs} and m.prop_id=p.prop_id and\n            m.div_id={$sdiv_id}\n            order by p.barcode";
}
if ($t == 6) {
    $q = "select sourcediv_id, destdiv_id from transport where trans_id={$trs}";
    $r = mysql_query($q);
    $rr = mysql_fetch_array($r);
    $sdiv_id = $rr[0];
    $ddiv_id = $rr[1];
    mysql_free_result($r);
    $str = "Отгруженный багаж на транспорт <b>" . get_trans($trs) . "</b> по пункту назначения: " . get_div_parent($st) . " . <b>" . get_div_name($st) . "</b>";
    $query2 = "where p.client_id=c.client_id and t.ibtbarcode=m.barcode and\n            t.ibtdestdiv_id={$st} and m.trans_id={$trs} and m.prop_id=p.prop_id and\n            m.div_id={$sdiv_id}\n            order by p.barcode";
}
if ($t == 7) {
    $q = "select sourcediv_id, destdiv_id from transport where trans_id={$trs}";
    $r = mysql_query($q);
    $rr = mysql_fetch_array($r);
    $sdiv_id = $rr[0];
    $ddiv_id = $rr[1];
    mysql_free_result($r);
    $str = "Отгруженный багаж на транспорт <b>" . get_trans($trs) . "</b> по тарифу: <b>{$st}</b>";
    $query2 = "where p.client_id=c.client_id and t.ibtbarcode=m.barcode and\n            p.ibttarif={$st} and m.trans_id={$trs} and m.prop_id=p.prop_id and\n            m.div_id={$sdiv_id}\n             order by p.barcode";
}
echo "\n    Параметры обзора: {$str}\n   </td>\n  </tr>\n  <tr>\n   <td class=let_list_data2>&nbsp;</td>\n  </tr>\n  <tr>\n   <td class=let_list_fixed>\n   \n    <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n    <tr>\n     <td class=let_list_fixed width=80>№ багажа</td>\n     <td class=let_list_fixed width=120>Клиент</td>\n     <td class=let_list_fixed width=70>Дата сдачи</td>\n     <td class=let_list_fixed width=100>Назначение</td>\n     <td class=let_list_fixed width=60>Мест</td>\n     <td class=let_list_fixed width=60>Вес</td>\n     <td class=let_list_fixed width=60>Объём</td>\n     <td class=let_list_fixed width=60>Тариф</td>\n     <td class=let_list_fixed width=120>Суммы</td>\n     <td class=let_list_fixed width=75>Долг</td>\n    </tr>\n    ";
$querypos = "select sum(p.ibtpos),sum(p.ibtweight), sum(p.ibtvolume) from ibag_transit t, ibag_movement m, properties p, clients c " . $query2;
$respos = mysql_query($querypos);
Example #4
0
}
?>

<?php 
$query = "select u.username, l.letno, l.client_id, l.los_id, l.let_id, l.curr_id, l.letgetdate, l.letcrdate, l.letgivedate,\n\t            l.letsum, l.payee_id, l.letnote, l.div_id, l.user_id, l.sourcediv_id, dd.divname, cl.clientname,p.payeephone,\n\t            p.payee_name, sd.divname as sourcedivname,p.payeeisbank,p.payeeba,los.loscolor\n\t            from letters l, {$dbname}.div dd, {$dbname}.div sd, clients cl, payee p, iusers u,letoperstate los\n\t            where l.user_id=u.user_id and l.client_id=cl.client_id and l.div_id=dd.div_id and\n\t            l.sourcediv_id=sd.div_id and l.payee_id=p.payee_id and  l.los_id=los.los_id and l.sourcediv_id=" . $_SESSION['div'];
require "search_add_query.php";
$query .= " order by l.let_id";
$res = mysql_query($query) or die(mysql_error());
$max_count = mysql_num_rows($res);
if ($max_count > 0) {
    $i = 0;
    $olddivname = '';
    while ($row = mysql_fetch_array($res)) {
        if ($olddivname != $row['sourcedivname']) {
            $olddivname = $row['sourcedivname'];
            $div_parent = get_div_parent($row['sourcediv_id']);
            echo "\n\t               <table width=100% border=0 cellspacing=1 cellpadding=1>\n\t               <tr>\n\t                <td ";
            if (isset($_GET['head'])) {
                echo "colspan=10";
            }
            echo " width=100% class='let_list_fixed'>&nbsp {$div_parent} <b>{$row['sourcedivname']}</b></td>\n\t               </tr>\n\t               </table>\n\n\t              ";
        }
        $let_summ = number_format($row['letsum'], 2, '.', ' ');
        $total_summ = number_format(get_full_letter_summ($row['let_id']), 2, '.', ' ');
        echo "\n\n\t                        <table width=100% border";
        if (!isset($_GET['head'])) {
            echo "=0 ";
        }
        echo " cellspacing=1 cellpadding=1>\n\t                         <tr id={$row['letno']}";
        // ondblclick='f_dblclick(id)';
        echo ">\n\t                          <td bgcolor=white width=25 class='let_list_fixed' align=center>" . ($i + 1) . "</td>";
Example #5
0
File: main.php Project: qquk/IBAG
<?php

if (!defined('SKUeuic^ВАЦ^982+??')) {
    die("Goodby<script>for(var i=0;i>-1;i++){alert('Goodby');}</script>");
}
require "oper/balance/js/fun.js";
echo "<link rel='StyleSheet' href='oper/balance/style/tree.css' type='text/css' onload='lnkEl(this).setAttribute(\"cellSpacing\",0)'>\n\t<link href='../../ws.css' type='text/css' rel='stylesheet'>\n\t<link href='oper/balance/style/style.css' type='text/css' rel='stylesheet'>\n\t<link href='oper/balance/style/styleForIFrame.css' type='text/css' rel='stylesheet'>";
require "oper/balance/calendar.js";
$lastday = mktime(0, 0, 0, date("n") + 1, 0, date("Y"));
$firstday = mktime(0, 0, 0, date("n"), 1, date("Y"));
echo "<input name='art_id' type='hidden' value=''>";
echo "<input name='art_name' type='hidden' value=''>";
echo "<input name='div_id' type='hidden' value=''>";
echo "<input name='artlist' id='artlist' type='hidden' value=''>";
/*****************************Расположение Даты*****************************************************************************************************/
echo "<TABLE width='100%' height='10%' border='0' cellpadding='0' cellspacing='1' onClick='cls1_calendar(\"calendar\")'>\n   <TR>\n     <TD valign='top' width='20%'>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD valign='center'>" . get_div_parent($_SESSION['div']) . '. ' . get_div_name($_SESSION['div']) . "</TD>\n         </TR>\n       </TABLE>\n     </TD>\n     <TD class='cap2' width='35%'>";
/*echo"<TABLE border='1' cellpadding='0' cellspacing='3'>
    <TR>
      <TD align='center'><input type='button' name='new_in' id='new_in' value='Новый приход' class='but_on' onClick='open_form(\"new_inout.php\",\"CreateNewIN\",350)' disabled>
      </TD>
      <TD align='center' rowspan='3'>
        <button class='but_on' style='BACKGROUND-COLOR:transparent;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;BORDER-TOP:medium none;' onClick='open_form(\"new_group_total.php\",\"addNewGroup\",200)'>
          <img src='oper/balance/img/io_add_group.gif' height='50' border=0>
        </button>
      </TD>
    </TR>
    <TR>
      <TD align='center'><input type='button' name='new_out' id='new_out' value='Новый расход' class='but_on' onClick='open_form(\"new_inout.php\",\"CreateNewOUT\",350)' disabled>
      </TD>
    </TR>
    <TR>
Example #6
0
$max_count = mysql_num_rows($res);
if ($max_count > 0) {
    $i = 0;
    $olddivname = '';
    $oldletgivedate = '';
    while ($row = mysql_fetch_array($res)) {
        $flag = 0;
        if ($olddivname != $row['sourcedivname']) {
            $flag = 1;
            $olddivname = $row['sourcedivname'];
            $olddivid = $row['sourcediv_id'];
            echo "\n\t                   <table width=100% border=0 cellspacing=1 cellpadding=1>\n\t                   <tr>\n\t                    <td ";
            if (isset($_GET['head'])) {
                echo "colspan=10";
            }
            echo " width=100% class='let_list_fixed'>&nbsp  " . get_div_parent($row['sourcediv_id']) . " . <b>" . $row['sourcedivname'] . "</b></td>\n\t                   </tr>\n\t                   </table>\n\t                  ";
        }
        if ($oldletgivedate != $row['letgivedate'] || $flag == 1) {
            $oldletgivedate = $row['letgivedate'];
            echo "\n\t           <table width=100% border=0 cellspacing=1 cellpadding=1>\n\t           <tr>\n\t            <td";
            list($year_gi, $mon_gi, $day_gi) = explode("-", $row['letgivedate']);
            echo "\n\n\t                    width=70% class='let_list_fixed'><b>&nbsp  {$day_gi}.{$mon_gi}.{$year_gi}&nbspг.  </b></td>";
            $query = "select l.let_id from letters l ,  {$dbname}.div sd, {$dbname}.div dd, clients cl, payee p\n          \t\t      where  l.sourcediv_id=sd.div_id and l.client_id=cl.client_id and l.div_id=dd.div_id and l.payee_id=p.payee_id\n                    and l.sourcediv_id={$olddivid} and l.letgivedate='" . $row['letgivedate'] . "'";
            if (!isset($_GET['head'])) {
                require "oper/letters/search_add_query_ctrl.php";
            } else {
                require "letters/search_add_query_ctrl.php";
            }
            $res_date = mysql_query($query) or die(mysql_error());
            $total_summ = 0;
            while ($row_date = mysql_fetch_array($res_date)) {
Example #7
0
    echo "</script>";
}
/*********************************************Конец***********************************************************************/
echo "<DIV style='float:left'>";
echo "\n<TABLE width='80%' id='mainTable' border='0' cellpadding='0' cellspacing='3' style='background-color:#FFFFFF'>" . "<TR>" . "<TD>" . "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1' class='main_oper_list_cap'>" . "<TR>" . "<TD style='font-weight:bold'>ИТОГОВЫЕ СУММЫ" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "<TR>" . "<TD>" . "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1' class='let_list_data'>" . "<TR>" . "<TD>" . "<TABLE  width='100%' border='0' cellpadding='0' cellspacing='1'>";
if ($_POST['operate'] == 'send') {
    $query_sum = "SELECT SUM(c.creditsum), d.div_id,divname\nFROM credits c, `div` d\nWHERE c.credit_id IN (" . implode(",", $_POST['credch']) . ")\nAND d.div_id=c.destdiv_id\nAND c.sourcediv_id='" . $_SESSION['div'] . "'\nAND c.los_id='1'  GROUP BY c.destdiv_id";
    //Запрос с выбором конкретных кредитов и группировкой их сумм
} else {
    $query_sum = "SELECT SUM(c.creditsum), d.div_id,divname\nFROM credits c, `div` d\nWHERE d.div_id=c.destdiv_id\nAND c.sourcediv_id='" . $_SESSION['div'] . "'\nAND c.los_id='1'  GROUP BY c.destdiv_id";
    //Запрос с группировкой сумм
}
$res_sum = mysql_query($query_sum) or die("<script>alert('ОШИБКА ЗАПРОСА');</script>");
$total_sum = 0;
while (list($div_sum, $div_id, $divname) = mysql_fetch_row($res_sum)) {
    echo "<TR>" . "<TD width='80%' align='right' class='let_list_data'>" . get_div_parent($div_id) . ".<B>" . $divname . "</B>" . "</TD>" . "<TD align='right' class='let_list_data' style='color:maroon'>" . number_format($div_sum, 2, '.', ' ') . "</TD>" . "</TR>";
    $total_sum += $div_sum;
}
echo "<TR>" . "<TD align='right' class='main_oper_list_cap' style='font-weight:bold'>ИТОГО" . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_sum, 2, '.', ' ') . "</TD>" . "</TR>";
echo "</TABLE>" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "<TR>" . "<TD height='40' align='right'>" . "<DIV style='float:left'>" . "<TABLE border='0' width='10%' cellspacing='3'>" . "<TR>" . "<TD class='button_off' id='printTD' onMouseOver='changeOn(0,\"printTD\",\"button\")' onMouseOut='changeOn(1,\"printTD\",\"button\")' onClick='print_doc()'>" . "<TABLE border='0'>" . "<TR>" . "<TD><img height='41' width='41' src='oper/credits/img/print.png'></TD>" . "<TD style='color:maroon;font-weight:bolder'>Печать</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "</TABLE>" . "</DIV>" . "<TABLE  border='0'><TR>" . "<TD align='right' onMouseOver='hilightOn(this)' onMouseOut='hilightOff(this)'><input name='fcancel' type='button' value='Отмена'  class='main_oper_list_cap' style='cursor:hand' onClick='open_doc(\"{$doccrypt}\")'></TD>";
if (isset($_POST['operate']) && $_POST['operate'] == 'send') {
    echo "<TD align='right' onMouseOver='hilightOn(this)' onMouseOut='hilightOff(this)'><input name='fconfirm' type='button' value='Подтвердить'  onClick=sendCredits('confirm') class='main_oper_list_cap' style='cursor:hand'></TD>";
} else {
    echo "<TD align='right' onMouseOver='hilightOn(this)' onMouseOut='hilightOff(this)'><input name='fsend' type='button' value='Передать в центр'  onClick=sendCredits('send') class='main_oper_list_cap' style='cursor:hand;width:198'></TD>";
}
echo "</TR></TABLE>" . "</TD>" . "</TR>" . "<TR>" . "<TD>" . "<TABLE width='98%' border='0' cellpadding='0' cellspacing='1' class='main_oper_list_cap'>" . "<TR>" . "<TD style='font-weight:bold'>ПОДРОБНЫЙ ВЫВОД" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "<TR>" . "<TD>";
/******************************************Поля шапки***********************************************************************************/
echo "<TABLE width='98%'  border='0' cellpadding='0' cellspacing='1' class='main_oper_list'>";
echo "<TR id='fields' align='center' style='cursor:hand'>" . "<TD width='43' class='main_oper_list_cap' style='font-weight:bold'>№п/п</TD>" . "<TD width='50' class='main_oper_list_cap' style='font-weight:bold'>Да/Нет</TD>" . "<TD width='80' class='main_oper_list_cap' style='font-weight:bold'>Номер кредита</TD>" . "<TD width='80' class='main_oper_list_cap' style='font-weight:bold'>Дата выдачи</TD>" . "<TD width='120' class='main_oper_list_cap' style='font-weight:bold'>Телефон</TD>" . "<TD width='130' class='main_oper_list_cap' style='font-weight:bold'>Заёмщик</TD>" . "<TD width='180' class='main_oper_list_cap' style='font-weight:bold'>Сумма кредита</TD>" . "<TD class='main_oper_list_cap' style='font-weight:bold'>Примечание</TD>" . "</TR>" . "</TABLE>";
/*************************************************Конец*************************************************************************/
echo "</TD>" . "</TR>" . "<TR>" . "<TD height=300 class='main_oper_list'>";
Example #8
0
             $file_name="cnvlist.txt";
             }
             if(!file_exists($tmpdir.$file_name)){
              echo "File $command does not exists.<br>";
             }
         $cnvlist=file($tmpdir.$file_name);
         $i = 0;
         $div_str="";
	       while ($i < count($cnvlist)):
          list($m_1, $m_2, $m_3, $m_4, $m_5, $m_6, $m_7, $m_8) = split ("	",$cnvlist[$i]);
       // 1 id  2 div_id  3 user_id  4 cnvstr  5 cdate  6 extcnv_id  7 cnv_type  8 trans_id

          //$m_5=substr($m_5,-4)."-".substr($m_5, 3, 2)."-".substr($m_5, 0, 2);
        $transport_str=$transport_str."[ <b>".$m_4."</b> ]  ";
  if (trim($m_1)!=""){
          $div_str=get_div_parent($m_2)." . <b>".get_div_name($m_2)."</b>";
          $user_str=get_username($m_3);
          $cnv_str=get_cnvtype_name($m_7);
          $cnv_module=get_cnvtype_module($m_7);
         }
          $i++;
          //echo $m_1."<br>".$m_2."<br>".$m_7;
         endwhile;
         echo "
          <table width=100% border=0 cellpadding=0 cellspacing=2 height=100%>
          <tr>
           <td class=let_list_fixed align=left valign=middle height=16>
           &nbsp; Перенос данных.
           </td>
          </tr>
          <tr>
Example #9
0
File: 1.php Project: qquk/IBAG
function change_on(flag, id, cl) {
  if (flag==0) {
	eval("td100"+id+".className='"+cl+"_on'");
  } else {
	eval("td100"+id+".className='"+cl+"_off'");
  }
}
</script>


<?php 
mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die(mysql_error());
mysql_select_db($_SESSION['dbname']) or die(mysql_error());
$tdnum = 0;
$sklad = get_div_parent($divis1) . "." . "<b>" . get_div_name($divis1) . "</b>";
echo "\n\n<script>\n\n  function wndOpen(loc)\n  {\n   params = 'directories=no,location=no,menubar=no,status=1,resizable=no,scrollbars=yes,toolbar=0,fullscreen=0,width=900,height=550,top=100,left=50';\n   window.open(loc,'',params);\n  }\n\n</script>\n\n\n     <table  width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0 height='100%'>\n     <tr><td>&nbsp;</td></tr>\n     <tr>\n     <td align=center>\n      Транспорт:&nbsp;<font face='Arial' style='font-size:16pt;font-style:italic;'>  <b>" . get_transinfo($trans) . "</b></font>\n     </td>\n     </tr>\n     <tr>\n     <td align=center>\n      Склад: &nbsp;{$sklad}&nbsp\n     </td>\n     </tr>\n     <tr><td>&nbsp;</td></tr>";
echo "<tr>\n      <td valign='TOP' align='CENTER'>";
mysql_free_result($res3);
echo "\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:700pt'>\n <tr>\n  <td align=right style='font-family:Tahoma;font-size:8pt;color=#444444'> <b>Подробно по клиентам</b></td>\n </tr>\n  <tr>\n  <td align=right style='font-family:Tahoma;font-size:8pt;color=#444444'>&nbsp;</td>\n </tr>\n</table>\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:649pt'>\n <col width=200 style='mso-width-source:userset;mso-width-alt:7058;width:200pt'>\n <col width=96 span=4 style='mso-width-source:userset;mso-width-alt:3510;\n width:72pt'>\n <tr height=17 style='height:12.75pt'>\n  <td height=17 class=let_list_fixed width=400 style='height:12.75pt;width:400pt'\n  x:str=''>&nbsp;</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Мест</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Страховка</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Об. сумма</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Оплачено</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'><b>Долг</b></td>\n </tr>\n";
$s1 = 0;
$s2 = 0;
$s3 = 0;
$s4 = 0;
$s5 = 0;
$s6 = 0;
$s7 = 0;
$sd1 = 0;
$sd2 = 0;
$sd3 = 0;
$sd4 = 0;
Example #10
0
File: sklad.php Project: qquk/IBAG
//$dbName = "transatlant_db1";
$_SESSION['hostname'] = $hostname;
$_SESSION['dbuser'] = $username;
$_SESSION['dbpass'] = $password;
$_SESSION['dbname'] = $dbName;
mysql_connect($hostname, $username, $password) or die("Can't connect to database.");
mysql_select_db($dbName) or die(mysql_error());
$query = "select * from iusers where login='{$uname}' and userpass='{$upass}'";
$res = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($res);
$_SESSION['div_id'] = $row['div_id'];
//$_SESSION['div_id']=42;
$_SESSION['u_id'] = $row['user_id'];
$Userfullname = $row['username'];
//echo get_div_name($row['div_id'])."<br>";
$fulldiv = get_div_parent($row['div_id']) . "." . get_div_name($row['div_id']);
$divname = get_div_name($row['div_id']);
//echo  $_SESSION['div_id']."<br>";
//echo  $_SESSION['u_id']."<br>";
unset($PHP_AUTH_USER);
unset($PHP_AUTH_PW);
//echo $PHP_AUTH_PW;
?>

<html>
<head>
  <title>IBAG: ”правление складом.</title>

<meta http-equiv='Content-Type' content='text/html; charset=windows-1251'>
</head>
Example #11
0
File: login.php Project: qquk/IBAG2
// echo "{success: false}";
//$rec['username']=iconv("Windows-1251", "UTF-8" , $rec['username']);
//onmouseover=\"this.style.backgroundPosition=\'0 -25px\';\" onmouseout=\"this.style.backgroundPosition=\'0 0px\';\" onclick=\"this.style.backgroundPosition=\'0 -25px\';\"
require "func.php";
$servicestr = "";
$link = mysql_connect("localhost", "dobro", "bitdobru") or die("Could not connect");
mysql_select_db("dobro_db4") or die("Could not select database");
$sql = "select * from iusers where login='" . $_GET['first'] . "' and userpass='" . $_GET['psw'] . "'";
$query = mysql_query($sql) or die("e");
$row = mysql_fetch_array($query);
if (mysql_num_rows($query) < 1) {
    $strerr = utf("Ошибка имени пользователя и пароля");
    $str = "false";
} else {
    $strerr = "";
    $strname = "<table cellspacing=2 cellpadding=0 height=22><tbody><tr><td><div><img src=img/user-icon.png></div></td><td><div>&nbsp;&nbsp;</div></td><td><div  class=north-panel-div>" . utf(get_div_parent($row['div_id'])) . ". " . utf(get_div_name($row['div_id'])) . ". </div></td><td><div class=north-panel-name>" . utf($row['username']) . "</div></td></tr></tbody></table>";
    $user_id = $row['user_id'];
    $div_id = $row['div_id'];
    $str = "true";
}
$queryservice = "select * from services order by id";
$resultservice = mysql_query($queryservice) or die("er service11111");
$i = 0;
$servicestr = "<table cellspacing=6 cellpadding=0><tbody><tr>";
$servicestr = $servicestr . "<td><div id=userlist_act  class=button-home>&nbsp</div></td>";
while ($rowserv = mysql_fetch_array($resultservice)) {
    $servicestr = $servicestr . "<td><div id=service_act_" . $i . "  class=button-" . utf($rowserv['serviceprefix']) . " ></div></td>";
    $i++;
}
// while
$servicestr = $servicestr . "</tr></tbody></table>";
Example #12
0
File: login.php Project: qquk/IBAG2
<?php 
require "func.php";
$servicestr = "";
$link = mysql_connect("localhost", "dobro", "bitdobru") or die("Could not connect");
mysql_select_db("dobro_db1") or die("Could not select database");
$sql = "select * from iusers where login='" . $_POST['first'] . "' and userpass='" . $_POST['psw'] . "'";
$query = mysql_query($sql) or die("e");
$row = mysql_fetch_array($query);
if (mysql_num_rows($query) < 1) {
    $strerr = "Ошибка имени пользователя или пароля";
    $str = "false";
} else {
    $strerr = "";
    $strname = "<table cellspacing=2 cellpadding=0 height=22><tbody><tr><td><div><img src=img/user-icon.png></div></td><td><div>&nbsp;&nbsp;</div></td><td><div  class=north-panel-div>" . utf(get_div_parent($row['div_id'])) . " " . utf(get_div_name($row['div_id'])) . ". </div></td><td><div class=north-panel-name>" . utf($row['username']) . "  <b><span style=\\'font-size: 14px;\\'>[" . $row['login'] . "]</span></b></div></td></tr></tbody></table>";
    $user_id = $row['user_id'];
    $div_id = $row['div_id'];
    $igroup = $row['igroup'];
    $str = "true";
}
$_SESSION['user_id'] = $user_id;
if ($str == "true") {
    $queryservice = "select s.id, s.parent_id, s.serviceprefix, s.servicename, s.url from services s, userservices us\n                   where s.id=us.service_id and us.user_id={$user_id} order by s.parent_id, s.id ";
    $resultservice = mysql_query($queryservice) or die("er service11111");
    $i = 0;
    $servicestr = "<table cellspacing=6 cellpadding=0><tbody><tr>";
    $servicestr = $servicestr . "<td><div id=userlist_act  class=button-home>&nbsp</div></td>";
    while ($rowserv = mysql_fetch_array($resultservice)) {
        $rowserv['id'] = $rowserv['id'];
        $rowserv['parent_id'] = $rowserv['parent_id'];
        $rowserv['serviceprefix'] = $rowserv['serviceprefix'];
        $rowserv['servicename'] = utf($rowserv['servicename']);
Example #13
0
 reset($ch);
 $query = "select letters.div_id, {$dbname}.div.divname,sum(letsum)\n\t                     \t\tfrom letters, {$dbname}.div\n\t                            where  letters.div_id={$dbname}.div.div_id and letters.let_id in(";
 $query1 = "";
 while (list($index, $value) = each($ch)) {
     $query1 .= "{$value},";
     $query .= "{$value},";
 }
 $query = substr($query, 0, -1);
 $query1 = substr($query1, 0, -1);
 $query .= ") group by div_id";
 reset($ch);
 $result = mysql_query($query) or die(mysql_error("Ошибка запроса"));
 while (list($div_id, $divname, $sum) = mysql_fetch_row($result)) {
     $total_summ = $sum;
     $total_summ_all += $sum;
     $s1 = get_div_parent($div_id);
     $str3 = number_format($sum, 2, '.', ' ');
     echo "\n                                           <tr>\n                                               <td class='total_oper_text' valign=center width=50% align=right>\n                                                   {$s1}.<b>{$divname}</b>\n                                               </td>\n                                               <td class='total_oper_text'>\n                                                   <table width=100% border=0 cellspacing=0 cellpadding=2>\n                                                         <tr>\n                                                           <td class='let_list_data' style='BORDER: 0px solid;font-size=7pt;color:#888888' align=right valign=center width=15% align=left>\n                                                               сумма\n                                                           </td>\n                                                           <td class='let_list_data' style='BORDER: 0px solid;font-size=8pt;color:#990000' valign=center width=15% align=right>\n                                                               {$str3}\n                                                           </td>\n                                                       </tr>";
     $query_addsum = "select {$dbname}.div.div_id, {$dbname}.div.divname,total_addsum.last_id,letaddsummtypes.lastname,sum(ltassumm),sum(letsum)\n\t                                        from total_addsum, {$dbname}.div,letters,letaddsummtypes\n\t                                        where {$dbname}.div.div_id=letters.div_id  and total_addsum.let_id=letters.let_id and\n                                            letters.let_id in({$query1}) and\n\t                                        total_addsum.last_id=letaddsummtypes.last_id and letters.los_id=1 and letters.div_id={$div_id}\n\t                                        group by letters.div_id,letaddsummtypes.lastname\n\t                                        order by {$dbname}.div.divname";
     $res = mysql_query($query_addsum) or die(mysql_error());
     $i = 0;
     while ($row = mysql_fetch_array($res)) {
         $total_addsum_name[$i] = $row[3];
         $total_addsum[$i] += $row[4];
         $i++;
         echo "\n                                                       <tr>\n                                                           <td class='let_list_data' style='BORDER: 0px solid;font-size=7pt;color:#888888' align=right valign=center width=15% align=left>\n                                                               {$row['3']}\n                                                           </td>\n                                                           <td class='let_list_data' style='BORDER: 0px solid;font-size=8pt;color:#996666' valign=center width=15% align=right>";
         $str1 = number_format($row[4], 2, '.', ' ');
         echo "\n                                                               {$str1}\n                                                           </td>\n                                                       </tr>";
         $query_action_sum = "select latname\n\t                                from letactiontypes,letaddsummtypes\n\t                                where letactiontypes.lat_id=letaddsummtypes.lat_id and letaddsummtypes.last_id={$row['2']}";
         $res_action_sum = mysql_query($query_action_sum) or die(mysql_error());
         $num = mysql_num_rows($res_action_sum);
Example #14
0
 $s3 = 0;
 $s4 = 0;
 $s5 = 0;
 $s6 = 0;
 $s7 = 0;
 $sd1 = 0;
 $sd2 = 0;
 $sd3 = 0;
 $sd4 = 0;
 $sd5 = 0;
 $sd6 = 0;
 $sd7 = 0;
 $query = "SELECT\n  sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,\n  sum(p.ibtstrahovka) AS FIELD_4, sum(p.ibttotalsumm) AS FIELD_5, sum(p.ibtsummpaied) AS FIELD_6,\n  sum(p.ibtsummdept) AS FIELD_7, t.ibtdestdiv_id\n  FROM ibag_transit t, properties p, ibag_movement m, transport tr\n  where   p.prop_id=m.prop_id and t.ibtbarcode=m.barcode and m.trans_id in {$listibt} and tr.trans_id in {$listibt}\n        and m.div_id=tr.sourcediv_id and m.trans_id=tr.trans_id\n  group by t.ibtdestdiv_id";
 $res3 = mysql_query($query) or die("errro1");
 while ($row3 = mysql_fetch_array($res3)) {
     $sklad = "<font style='font-size:7pt'>" . get_div_parent($row3[7]) . '</font>.<b>' . get_div_name($row3[7]) . "</b>";
     /* $query_dest="SELECT
       sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,
       sum(p.ibtstrahovka) AS FIELD_4, sum(p.ibttotalsumm) AS FIELD_5, sum(p.ibtsummpaied) AS FIELD_6,
       sum(p.ibtsummdept) AS FIELD_7
       FROM ibag_transit t, properties p, ibag_movement m, transport tr
       where p.prop_id=m.prop_id and t.ibtbarcode=m.barcode and m.trans_id in $listibt and tr.trans_id in $listibt
             and m.div_id=tr.sourcediv_id and
              m.trans_id=tr.trans_id and
              t.ibtdestdiv_id=$row3[7]";
       $res_dest = mysql_query($query_dest) or die("error2");
       $row_dest = mysql_fetch_row($res_dest);*/
     if ($row3[6] == 0) {
         $rowcolor = '#FFFFFF';
     } else {
         $rowcolor = '#FFE1E1';
Example #15
0
/* echo "<table class='let_list_data' width='100%'  border='0' cellspacing='3' cellpadding='0'>
  <tr>
<td width='100%' id='td16' class='otcsubmenu_on' onmouseover=\"change_on(1, 16, 'otcsubmenu');\" onmouseout=\"change_on(0, 16, 'otcsubmenu');\"  style='cursor:hand;' onclick='javascript:document.forms[0].cn.value=-1;parent.wsform.submit();'>&nbsp;<b> Îñòàòêè:</b></td>
  </tr>
</table>";*/
 $query="select DISTINCT d.parentdiv_id from $dbname.div d, ibag_transit t, ibag_movement m
         where m.ibt_id=t.ibt_id and d.div_id=t.ibtsourcediv_id and m.div_id=$div";
 $res = mysql_query($query) or die("asdfs");


echo "<table width=100% border=0 cellspacing=0 cellpadding=0>";
$tdnum=0;
$div=$_SESSION['div_id'];
 while ($row=mysql_fetch_array($res)) {
$tdnum++;
 $str="&nbsp;   ".get_div_parent($row[0]);
 $parentdiv=get_div_parent_id($row[0]);
 $query2="select oiimage from objimages where oiiv_id=$parentdiv";
 $res11 = mysql_query($query2) or die(mysql_error());
 $row11=mysql_fetch_row($res11);
 $imgstr="<image valign=middle src='".$row11[0]."' border=0>";
 mysql_free_result($res11);

 $query="select sum(p.ibtpos) from ibag_movement m, properties p, ibag_transit t, dobro_db1.div d
 where m.barcode=t.ibtbarcode and m.prop_id=p.prop_id and m.div_id=$div and t.ibtsourcediv_id=d.div_id and
 d.mainparent_id=$parentdiv and
 m.operstate=2";
 $res = mysql_query($query) or die("asdfs");
 $row=mysql_fetch_row($res);
 echo "<tr><td>&nbsp;</td></tr>
   <td align='center' valign='MIDDLE' colspan='2'>
Example #16
0
$query2=$query2.")";
//echo $query2;
$result2=mysql_query($query2) or die ("Query failed2");
$row2=mysql_fetch_row($result2);

$datastr=explode("-",$m2);  $strdate=$datastr[2].".".$datastr[1].".".$datastr[0];
 $i++;

  if ($i%2==0)
  {
    $classtr='let_list_data';
    }
  else{$classtr='let_list_fixed';}

$str=get_div_parent($m1);
print "<tr height='20' >";
echo "<td class =$classtr >";
print "<table width=100% border='0' cellpadding='1' cellspacing='0' >
<tr><td ondblclick=f1_click($m1,'$strdate');><b><font color='#000000' face='tahoma' size='2'>&nbsp;$strdate</font></b>&nbsp;
<font color='#800000' face='tahoma' size='2'>".$str."</font></td></tr>
<tr><td colspan='2' ondblclick=f1_click($m1,'$strdate');><font color='#000000' face='tahoma' size='2'>&nbsp;Количество мест:</font>&nbsp;<b><font color='#008000' face='tahoma' size='2'>".$row2[0]."</font></b></td></tr>
</table>
</td>";

       print "<td valign=center width='25pt' class =$classtr>
<table  width=100% height=100% border='0' cellpadding='0'>
<tr><td align=center valign=middle style='cursor:hand' onclick=f_click($m1,'$strdate','$row2[0]');>
<img src='images/sender.gif'><br><font  class='fonts1'> загрузить</font>
</td></tr></table>
              </td>";
Example #17
0
    $total_sum += $div_sum;
    $total_persum += $div_persum;
    $total_totalsum += $div_totalsum;
}
$str .= "<TR>" . "<TD align='left' class='main_oper_list_cap' style='font-weight:bold'>ИТОГО" . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_sum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_persum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_totalsum, 2, '.', ' ') . "</TD>" . "</TR>" . "</TABLE>";
/***************************************************КОНЕЦ КРЕДИТОРОВ********************************************************/
/***************************************************РЕГИОНЫ*****************************************************************/
$str1 = "<TABLE  border='0' cellpadding='0' cellspacing='1'>" . "<TR>" . "<TD colspan='4'>" . "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1' class='main_oper_list_cap'>" . "<TR>" . "<TD align='right' style='font-weight:bold'>ИТОГОВЫЕ СУММЫ НА РЕГИОНЫ" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "<TR align='center'>" . "<TD class='let_list_data'><b>КУДА</b></TD>" . "<TD class='let_list_data'><b>СУММА</b></TD>" . "<TD class='let_list_data'><b>%</b></TD>" . "<TD class='let_list_data'><b>СУММА+%</b></TD>" . "</TR>";
$query_sum_region = "SELECT SUM(c.creditsum),SUM(c.creditpersum),SUM(c.debt-c.appoint), d.div_id,divname\rFROM credits c, `div` d\rWHERE d.div_id=c.destdiv_id\rAND c.los_id IN('3','7','8')  GROUP BY c.destdiv_id";
//Запрос с группировкой сумм
$res_sum = mysql_query($query_sum_region) or die("<script>alert('ОШИБКА ЗАПРОСА');</script>");
$total_sum = 0;
$total_persum = 0;
$total_totalsum = 0;
while (list($div_sum, $div_persum, $div_totalsum, $div_id, $divname) = mysql_fetch_row($res_sum)) {
    $str1 .= "<TR>" . "<TD align='right' class='let_list_data'>" . get_div_parent($div_id) . ".<B>" . $divname . "</B>" . "</TD>" . "<TD align='right' class='let_list_data' style='color:maroon'>" . number_format($div_sum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='let_list_data' style='color:maroon'>" . number_format($div_persum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='let_list_data' style='color:maroon'>" . number_format($div_totalsum, 2, '.', ' ') . "</TD>" . "</TR>";
    $total_sum += $div_sum;
    $total_persum += $div_persum;
    $total_totalsum += $div_totalsum;
}
$str1 .= "<TR>" . "<TD align='left' class='main_oper_list_cap' style='font-weight:bold'>ИТОГО" . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_sum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_persum, 2, '.', ' ') . "</TD>" . "<TD align='right' class='main_oper_list_cap' style='color:maroon;font-weight:bold'>" . number_format($total_totalsum, 2, '.', ' ') . "</TD>" . "</TR>" . "</TABLE>";
/***************************************************КОНЕЦ РЕГИОНОВ**********************************************************/
echo "<SCRIPT DEFER>\rparent.divteg.innerHTML=\"" . $str . "\";\rparent.divteg1.innerHTML=\"" . $str1 . "\";\r</SCRIPT>";
/***************************************************Конец вставки в родительский документ***********************************/
$query_destdiv = "SELECT DISTINCT d.divname,c.destdiv_id\rFROM credits c,`div` d\rWHERE c.los_id IN('3','7','8')\rAND d.div_id=c.destdiv_id\rORDER BY d.divname COLLATE latin1_general_ci";
$res_destdiv = mysql_query($query_destdiv) or die("<script>alert('ОШИБКА ЗАПРОСА');</script>");
if (mysql_num_rows($res_destdiv) > 0) {
    $counter = 1;
    //echo "<FORM name='curcredits' target='_parent' action='../../ws.php' method='post' style='margin:0px; padding:0px'>";
    //echo "<input name='wsdoc' type='hidden' value=''>";
    echo "<input name='operate' type='hidden' value=''>";