get_div_name PHP Code Examples

Example #1

0

Show file

File: main_total.php Project: qquk/IBAG

echo "<TABLE border='0'><TR><TD>" . "<TABLE style='border-collapse:collapse'><TR>" . "<TD class='doc_off' id='new_inTD' onMouseOver='changeOn(0,\"new_inTD\",\"doc\")' onMouseOut='changeOn(1,\"new_inTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewIN\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/sender.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>приход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_outTD' onMouseOver='changeOn(0,\"new_outTD\",\"doc\")' onMouseOut='changeOn(1,\"new_outTD\",\"doc\")' onClick='open_form(\"new_inout.php\",\"CreateNewOUT\",350)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='images/payee.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Новый</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>расход</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='new_groupTD' onMouseOver='changeOn(0,\"new_groupTD\",\"doc\")' onMouseOut='changeOn(1,\"new_groupTD\",\"doc\")' onClick='open_form(\"new_group_total.php\",\"addNewGroup\",200)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/io_add_group_plus.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Добавить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>группу</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='delartTD' onMouseOver='changeOn(0,\"delartTD\",\"doc\")' onMouseOut='changeOn(1,\"delartTD\",\"doc\")' onClick='delArt(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/del.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Удалить</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>статью</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='printTD' onMouseOver='changeOn(0,\"printTD\",\"doc\")' onMouseOut='changeOn(1,\"printTD\",\"doc\")' onClick='print_doc(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/print.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Печать</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>результата</TD></TR>" . "</TABLE>" . "</TD>" . "<TD width='10'></TD>" . "<TD class='doc_off' id='viewExcel' onMouseOver='changeOn(0,\"viewExcel\",\"doc\")' onMouseOut='changeOn(1,\"viewExcel\",\"doc\")' onClick='exportToExcel(document.wsform.art_id.value)' disabled>" . "<TABLE border='0'>" . "<TR>" . "<TD><img src='oper/balance/img/excel1.gif'></TD>" . "<TD valign=top style='color:#000000;font-family:Tahoma;font-size:8pt;font-weight:normal'>Вывод</TD>" . "</TR>" . "<TR><TD colspan='2' align='right' valign=top style='color:#999999;font-family:Tahoma;font-size:7pt;font-weight:normal'>в Excel</TD></TR>" . "</TABLE>" . "</TD>" . "</TR></TABLE>" . "</TD></TR></TABLE>";
echo "</TD>\n     <TD width='15%'>\n       <TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD>\n             <TABLE border='0'  cellpadding='0' cellspacing='3'>\n               <TR>";
/*echo"  <TD><input type='button' value='Установить Дату' class='but_on'>
  </TD>";*/
echo "<TD>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD width='20'style='font-size:10pt;color:maroon'>С:\n                       </TD>\n                       <TD><input name='date_first' id='date_first' type='text' class='date_give' value='" . date("d.m.Y", $firstday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),1)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                   <TABLE border='0'  cellpadding='0' cellspacing='3'>\n                     <TR>\n                       <TD style='font-size:10pt;color:maroon'>По:\n                       </TD>\n                       <TD><input name='date_last' id='date_last' type='text' class='date_give' value='" . date("d.m.Y", $lastday) . "' onKeyPress='return false'>\n                       </TD>\n                       <TD><button onClick=\"show_calendar('calendar',getX(this),getY(this),2)\" class='calend'><img src='images/calendar.gif' border=0></button>\n                       </TD>\n                     </TR>\n                   </TABLE>\n                 </TD>\n               </TR>\n             </TABLE>\n           </TD>\n         </TR>\n       </TABLE>\n      </TD>\n      <TD valign='top'>\n      \t<TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='cap2'>\n         <TR>\n           <TD valign='top'>";
echo "<TABLE valign='top' border='1'  cellpadding='0' cellspacing='0'>" . "<TR>" . "<TD style='background-color: #CECCBF'>" . "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1'>" . "<TR>" . "<TD style='font-weight:bold' class='main_oper_list_cap'>Поиск по полю От кого/Кому" . "</TD>" . "</TR>" . "<TR>" . "<TD style='font-weight:bold'>" . "<input name='fromto' type='text' size='30' maxlength='30' class='textfield_search_art'>" . "<button class='search_btn' onClick='searchAndLocateInToFrame(this.previousSibling.value)' onmouseover=show('text2',getX(this),getY(this)) onmouseout=cls('text2');><img src='images/search.gif'></button><br>" . "</TD>" . "</TR>" . "</TABLE>" . "</TD>" . "</TR>" . "</TABLE>";
echo " </TD>\n         </TR>\n         <TR>\n         \t<TD><input name='ifdate' type='checkbox' value='ON' checked>Использовать дату при поиске\n         \t</TD>\n         </TR>\n       </TABLE>\n      </TD>\n   </TR>\n</TABLE>";
/***************************************************************************************************************************************************/
/*****************************Основная Таблица*****************************************************************************************************/
echo "<TABLE width='100%' height='100%' 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='let_list_data'>\n         <TR>\n           <TD valign='top'>";
require "oper/balance/js/tree_total.js";
echo "<div class=\"tree\">\n<script type=\"text/javascript\">\n<!--\n";
echo "var Tree = new Array;\n";
require "oper/balance/basefun_total.php";
echo generateListTree($rec = '', $aux = 0, 0);
echo "createTree(Tree,null,null,'" . get_div_name($_SESSION['div']) . "');";
echo "\n//-->\n</script>\n</div>";
echo "\n          </TD>\n         </TR>\n       </TABLE>\n\t</TD>\n\t<TD valign='top'>";
/*	    echo"<TABLE border='0' width='100%' height='10%' cellpadding='0' cellspacing='0' class='cap2'>
        <TR>
          <TD valign='top'>123
          </TD>
        </TR>
       </TABLE>"; */
echo "<TABLE border='0' width='100%' height='100%' cellpadding='0' cellspacing='0' class='let_list_data'>\n         <TR>\n           <TD valign='top'>";
echo "<table width='99%' border='0' cellpadding='1' cellspacing='1' style='margin-left:5;margin-right:5'>" . "<tr>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:maroon;font-family:Arial;font-size:10pt;cursor:hand' onClick=\"prevRemain('" . $_SESSION['div'] . "')\" class='prevremain_off' onMouseOver=\"this.className='prevremain_on'\" onMouseOut=\"this.className='prevremain_off'\">Предыдущий остаток</td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='prev_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='prev_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Приход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='in_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='in_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Расход за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='out_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='out_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='20%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Итого за период</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='total_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='total_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "<td align='center' width='19%'>" . "<table  border='0' cellpadding='1' cellspacing='1' width=100%>" . "<tr><td colspan='2' align='left' style='color:#555555;font-family:Arial;font-size:10pt;cursor:hand'><b><u>Касса</u></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left width='10%'><b>USD:</b></td><td align=left>  <b><div id='cash_usd'>&nbsp;</div></b></td></tr>" . "<tr style='font-family:Arial;font-size:10pt'><td align=left><b>Грн:</b></td><td align=left>  <b><div id='cash_grn'>&nbsp;</div></b></td></tr>" . "</table>" . "</td>" . "</tr>" . "</table>";
echo "<table id='ttab' border='0' cellpadding='0' cellspacing='1' style='margin-left:5'>" . "<tr id='ttRows' height='22' align='center' style='color:white;font-family:Tahoma;font-size:14px'>" . "<td>Дата</td>" . "<td>От кого/Кому</td>" . "<td>Сумма, \$</td>" . "<td>Сумма, грн</td>" . "<td>Примечание</td>" . "<td>Удаление</td>" . "</tr></table>";
echo "<IFRAME width='100%' height='69%' name='outputData' id='outputData' scrolling='yes' frameborder='0' marginheight='0' marginwidth='0'>\n             </IFRAME>\n           </TD>\n         </TR>\n        </TABLE>\n\t</TD>\n   </TR>\n</TABLE>";
echo "   <DIV id=text2\n        style='position:absolute;LEFT: 370px; WIDTH: 130px; TOP: 180px; HEIGHT: 45px;z-index:1900;visibility:hidden'\n        align=center>\n        <TABLE cellSpacing=1 cellPadding=2 width='100%'  border=0>\n        <TR>\n        <TD align=middle bgColor='#556B2F' class='promt_layer'>\n        <P align=left>\n        <FONT face='MS Sans Serif' size=2>&nbsp;\n        Введите <u>не менее 3 букв или цифр</u> для выбора статей по полю <FONT color=Yellow>От кого/Кому</FONT>\n        <BR>\n        </FONT>\n        </P>\n        </TD>\n        </TR>\n        </TABLE>\n        </DIV>";
/***************************************************************************************************************************************************/
?>

Example #2

0

Show file

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 #3

0

Show file

File: sklad.php Project: qquk/IBAG

$_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='******' and userpass='******'";
$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>

<link href='otc.css' type='text/css' rel='stylesheet'>

Example #4

0

Show file

File: query_RecepDeliv_letters.php Project: qquk/IBAG

    $query_detail .= " AND l." . $giveORdelivDate . "date >= '" . $date_format . "'";
}
if ($_GET['dl'] != '') {
    list($get_day, $get_mon, $get_year) = explode(".", $_GET['dl']);
    $date_format = $get_year . "-" . $get_mon . "-" . $get_day;
    $query_sum .= " AND l." . $giveORdelivDate . "date <= '" . $date_format . "'";
    //$query_destdiv.=" AND l.".$giveORdelivDate."date <= '".$date_format."'";
    $query_detail .= " AND l." . $giveORdelivDate . "date <= '" . $date_format . "'";
}
//$query_destdiv.=" ORDER BY d.divname COLLATE latin1_general_ci";
//$res_destdiv=mysql_query($query_destdiv) OR DIE("<script>alert('ОШИБКА ЗАПРОСА1');</script>");
$query_sum .= " GROUP BY l." . $destORsourse . "div_id";
$res_sum = mysql_query($query_sum) or die("<script>alert('ОШИБКА ЗАПРОСА2');</script>");
if (mysql_num_rows($res_sum) > 0) {
    //echo "<script>alert(123);</script>";
    $counter = 1;
    while (list($sum, $persum, $totalsum, $div_id, $divname) = mysql_fetch_row($res_sum)) {
        //echo "<script>alert('".$destdiv_id_distinct."');</script>";
        echo "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1'>" . "<TR>" . "<TD  width='262' align='left'  style='font-weight:bold;font-size:12pt' class='main_oper_list_cap'>" . get_div_name($div_id) . "</TD>" . "<TD width='253' align='left'  style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>Сумма:</span><span style='position:relative;left:20px'>" . number_format($sum, 2, '.', ' ') . "</span></TD>" . "<TD width='180' align='left'  style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>%:</span><span style='position:relative;left:20px'>" . number_format($persum, 2, '.', ' ') . "</span></TD>" . "<TD align='left'  style='font-weight:bold;font-size:12pt' class='main_oper_list_cap' style='color:maroon'><span style='color:black'>Сумма+%:</span><span style='position:relative;left:20px'>" . number_format($totalsum, 2, '.', ' ') . "</span></TD>" . "</TR>" . "</TABLE>";
        echo "<TABLE width='100%' border='0' cellpadding='0' cellspacing='1' id=creditTable style='table-layout:fixed;'>";
        $query_detail1 = " AND l." . $destORsourse . "div_id='" . $div_id . "'";
        $query_detail2 = " ORDER BY l." . $giveORdelivDate . "date";
        $res_query_detail = $query_detail . $query_detail1 . $query_detail2;
        $res_detail = mysql_query($res_query_detail) or die("<script>alert('ОШИБКА ЗАПРОСА3');</script>");
        while (list($let_id, $letno, $clientname, $letsum, $ltassumm, $totalsum, $loscolor, $payee_name, $payeephone, $data, $letnote) = mysql_fetch_row($res_detail)) {
            echo "<TR  id={$credit_id} style='cursor:hand' onMouseOver='document_onmouseover(this)' onMouseOut='document_onmouseout(this)'>" . "<TD width='45' align='center' class='main_oper_list_cap' style='font-weight:bold'>{$counter}</TD>" . "<TD width='52' align='center' bgColor='" . $loscolor . "'>&nbsp</TD>" . "<TD width='82' class='let_list_data' style='font-weight:bold'>&nbsp{$letno}</TD>";
            list($get_year, $get_mon, $get_day) = explode("-", $data);
            $date_format = $get_day . "." . $get_mon . "." . $get_year;
            echo "<TD width='82' class='let_list_data'>&nbsp{$date_format}</TD>" . "<TD width='122' class='let_list_data'>&nbsp{$clientname}</TD>" . "<TD width='132' class='let_list_data'>&nbsp{$payee_name}</TD>" . "<TD width='182' class='let_list_data' style='color:maroon'>" . "<span align='right' style='color:black'>Сумма</span><span style='position:relative;left:27px'>" . number_format($letsum, 2, '.', ' ') . "</span><br>" . "<span align='right' style='color:black'>%</span><span style='position:relative;left:47px'>" . number_format($ltassumm, 2, '.', ' ') . "</span><br>" . "<span align='right' style='color:black;font-weight:bold'>Возврат</span><span style='font-weight:bold;position:relative;left:10px'>" . number_format($totalsum, 2, '.', ' ') . "</span><br>" . "</TD>" . "<TD class='let_list_data'>&nbsp{$letnote}</TD>" . "</TR>";
            $counter++;
        }

Example #5

0

Show file

File: ctrl_print_total.php Project: qquk/IBAG

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 #6

0

Show file

File: upload.php Project: qquk/IBAG2

             $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 #7

0

Show file

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='******'first'] . "' and userpass='******'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 #8

0

Show file

File: login.php Project: qquk/IBAG2

//$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 = "";
database_conn();
//mysql_query("SET CHARACTER SET 'utf8'");
//mysql_query("SET SESSION collation_connection = 'utf8_general_ci'");
$sql = "select * from iusers where login='******'first'] . "' and userpass='******'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>" . get_div_name($row['div_id']) . ". </div></td><td><div class=north-panel-name>" . $row['username'] . "</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'];

Example #9

0

Show file

File: bag_out.php Project: qquk/IBAG

mysql_select_db($_SESSION['dbname']) or die(mysql_error());
if (!isset($divis)) {
    $divis = -1;
}
echo "<input type='hidden' name='divis' id='divis' value='" . $divis . "'>";
if ($divis != -1) {
    require 'form_bagget_rep2.php';
} else {
    echo " <form onsubmit=''>\n      <table  width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n      <tr>\n        <td>&nbsp;</td>\n      </tr>\n      <tr>\n\n       <td>\n\n          <table onClick=cls1_calendar('calendar');  border=0 cellspacing=5 cellpadding=0 style='CURSOR:default;' >\n       \t\t<tr>\n           \t<td align=left  width=390>\n            <div id=b1_a>\n           \t <table   height=100 width=100% class='let_list_fixed'>\n             <tr>\n             \t<td>\n               \t<table width=100% height=100%>\n               \t<tr>\n               \t <td width=50 style='text-align:center;font-size=10;color:black;'>\n                  c\n                 </td>\n                 <td height=10 width=260 class='let_list_data' style='text-align:center;'>\n                  <input id=date_first name=date_first class='let_list_data' style='font-family:Atial;font-size:14pt;border:0;height:20; width:250;text-align:center;'>\n                 </td>\n                 <td width=70 align=center>\n                  <button onClick=show_calendar('calendar','390px','135px',1); style='BACKGROUND-COLOR:transparent;\n                   BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;\n                   BORDER-TOP:medium none;'><img src='images/calendar.gif' border=0>\n                  </button>\n                 </td>\n                </tr>\n                <tr>\n                 <td  style='text-align:center;font-size=10;color:black;'>\n                  по\n                 </td>\n                 <td height=10 width=260 class='let_list_data' style='text-align:center;'>\n                  <input id=date_last name=date_last class='let_list_data' style='font-family:Atial;font-size:14pt;border:0;height:20; width:250;text-align:center;'>\n                 </td>\n                 <td width=70 align=center>\n                  <button onClick=show_calendar('calendar','390px','170px',2); style='BACKGROUND-COLOR:transparent;\n                   BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;BORDER-RIGHT:medium none;\n                   BORDER-TOP:medium none;'><img src='images/calendar.gif' border=0>\n                  </button>\n                 </td>\n                </tr>\n                </table>\n               </td>\n              </tr>\n              </table>\n              </div>\n             </td>\n            </tr>\n          </table>\n\n       </td>\n      </tr>\n      <tr>\n        <td>&nbsp;</td>\n      </tr>\n      <tr>\n        <td><font face='Tahoma' style='font-size:8pt' color=#454532>Выберите подразделение или направление для получения отчёта</font>\n      </td>\n      </tr>\n";
    $query2 = "select oiimage from objimages where oiiv_id=9";
    $res11 = mysql_query($query2) or die(mysql_error());
    $row11 = mysql_fetch_row($res11);
    $imgstr = "<image valign=middle src='" . $row11[0] . "' border=0>";
    echo "<tr>\n       <TD>\n        <table width=100% border=0 cellspacing=0 cellpadding=0 bgcolor=#FFFFFF>\n         <tr>\n             <td  class='otcmenu_off' id='td0' onmouseover=\"change_on(0, 0 , 'otcmenu');\" onmouseout=\"change_on(1, 0, 'otcmenu');\" style='cursor:hand;'>&nbsp; УКРАИНА </td>\n         </tr>\n     <tr>\n       <td>\n         <table bgcolor=#FFFFFF width=100% border=0 cellspacing=0 cellpadding=0>\n            <tr>\n           <td width=250 valign=middle align=middle>{$imgstr}</td>\n        <td>\n     <table width=100% border=0 cellspacing=2 cellpadding=0>";
    $query_1 = "select div_id, divname  from {$dbname}.div d, divlevels dl   where d.dl_id=dl.dl_id and  d.mainparent_id='9' order by d.dl_id";
    $res_2 = mysql_query($query_1) or die(mysql_error());
    echo "\n <tr>\n  <td width='450'>\n   <b>Выдача</b>\n   </td>\n   <td width='20'>\n    &nbsp;\n  </td>\n</tr>\n\n          ";
    while ($row_2 = mysql_fetch_array($res_2)) {
        $str_1 = "&nbsp;   " . get_div_name($row_2[0]) . " . <b>" . $row_2[1] . "</b>";
        if ($row_2[0] == 57) {
            echo "\n<tr>\n <td width='450'>\n  <b>Транзит</b>\n </td>\n <td width='20'>\n&nbsp;\n</td>\n\n</tr>\n      ";
        }
        echo "\n        <tr>\n         <td width=250 id='td" . $row_2[0] . "' class='otcsubmenu_off' onmouseover=\"change_on(0, {$row_2['0']}, 'otcsubmenu');\" onmouseout=\"change_on(1, {$row_2['0']}, 'otcsubmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row_2['0']};parent.wsform.submit();'>" . $str_1 . "</td>\n         <td width=250>&nbsp;</td>\n        </tr>\n      ";
    }
    echo " </table></td>";
    echo "</tr>\n </table></td></tr></td></tr>\n </table>\n </form>";
}
?>
</body>
</html>

Example #10

0

Show file

File: get_trans_info.php Project: qquk/IBAG

$row=mysql_fetch_row($subresult);

$datastr=explode("-",$m3);  
$year=substr($m3,0,4);
$mon=substr($m3,5,2);
$day=substr($m3,8,2);
$strdate=$day.".".$mon.".".$year;
 $i++;

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

$str=get_div_name($m5)."&nbsp;<b>".$m2."</b>";
print "<tr height='20' >";
echo "<td class =$classtr >";
print "<table width=100% border='0' cellpadding='1' cellspacing='0' >
<tr>
<td><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);><font color='#000000' face='tahoma' size='2'>&nbsp; оличество мест:</font>&nbsp;<b><font color='#008000' face='tahoma' size='2'>".$row[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,$m5);>
<img src='images/sender.gif'><br><font  class='fonts1'> загрузить</font>

Example #11

0

Show file

File: get_rest_region.php Project: qquk/IBAG

<?php 
$tdnum = 0;
session_start();
mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die(mysql_error());
mysql_select_db($_SESSION['dbname']) or die(mysql_error());
if (!isset($divis1)) {
    $divis1 = -1;
}
echo "<input type='hidden' name='divis1' id='divis1' value='" . $divis1 . "'>";
echo "<input type='hidden' name='date_1' id='date_1' value='" . $_POST['date_first'] . "'>";
echo "<input type='hidden' name='date_2' id='date_2' value='" . $_POST['date_last'] . "'>";
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\n     <table  width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n     <tr><td>&nbsp;</td></tr>\n     <tr>\n     <td align=center>\n      <font face='Arial' style='font-sie:18pt'><b>Остатки по регионам</b></font>\n     </td>\n     </tr>\n     <tr><td>&nbsp;</td></tr>\n     <tr>\n      <td align=center>\n\n<table x:str border=0 cellpadding=0 cellspacing=0 width=865 style='border-collapse:\n collapse;table-layout:fixed;width:649pt'>\n \n <tr height=17 style='height:12.75pt'>\n  <td height=17 class=let_list_fixed width=100 style='height:12.75pt;width:100pt'\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\n </tr>\n";
$query = "SELECT\n  sum(p.ibtpos), sum(p.ibtweight), sum(p.ibtvolume), d.divname, d.div_id\n    FROM  properties p, ibag_movement m, dobro_db1.div d, ibag_transit t\n  where t.ibtbarcode=m.barcode and p.prop_id=m.prop_id and d.div_id=m.div_id and d.dl_id=3 and m.operstate=2\n  group by m.div_id";
$res3 = mysql_query($query) or die(mysql_error());
while ($row3 = mysql_fetch_array($res3)) {
    echo "\n   <tr height=17>\n   <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" style='cursor:hand;' onclick='show_rest({$row3['4']});' class=let_list_fixed_off style='height:27pt;border-top:none'>" . get_div_name($row3[4]) . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[0], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[1], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[2], 2, '.', ' ') . "</td>\n\n   </tr>";
    $s1 = $s1 + $row3[0];
    $s2 = $s2 + $row3[1];
    $s3 = $s3 + $row3[2];
    $tdnum++;
}
echo "\n       <tr height=17 style='height:15pt'>\n       <td height=17 class=let_list_fixed style='height:12.75pt;border-top:none'>Итого</td>\n       <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n       x:num>" . number_format($s1, 0, '.', ' ') . "</td>\n       <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n       x:num>" . number_format($s2, 0, '.', ' ') . "</td>\n       <td class=let_list_fixed align=right style='border-top:none;border-left:none'\n       x:num>" . number_format($s3, 2, '.', ' ') . "</td>\n              </tr>\n      </table>\n      </td>\n     </tr>\n     <tr><td>&nbsp;</td></tr>\n     <tr><td>&nbsp;</td></tr>";
mysql_free_result($res);
mysql_free_result($res2);
mysql_free_result($res3);
echo "    </table>";
?>
</body>
</html>

Example #12

0

Show file

File: letters_get_list.php Project: qquk/IBAG2

$sql_sum1 = $sql_sum1 . " GROUP BY l.div_id";
$sql_sum2 = $sql_sum2 . " GROUP BY c.clientname";
$sql_cnt = $sql;
//$sql = $sql . " LIMIT ".$_GET['start'].",".$_GET['limit'];
$sql = $sql . " LIMIT " . $_GET['start'] . ",50";
$rs_count = mysql_query($sql_cnt);
$rows = mysql_num_rows($rs_count);
$rs = mysql_query($sql);
$rs_group1 = mysql_query($sql_sum1);
$rs_group2 = mysql_query($sql_sum2);
$rs_totalsum = mysql_query($sql_total_sum);
$totalsumrs = mysql_fetch_array($rs_totalsum);
$totalsum = $totalsumrs[0] + $totalsumrs[1];
$totalsum_percent = $totalsumrs[1];
while ($rec1 = mysql_fetch_array($rs_group1)) {
    $r1[$rec1['id']][0] = iconv("Windows-1251", "UTF-8", get_div_name($rec1['id']));
    $r1[$rec1['id']][1] = $rec1['summ'];
    $r1[$rec1['id']][2] = $rec1['percent_summ'];
}
while ($rec2 = mysql_fetch_array($rs_group2)) {
    $r2[$rec2['id']][0] = iconv("Windows-1251", "UTF-8", $rec2['groupname']);
    $r2[$rec2['id']][1] = $rec2['summ'];
    $r2[$rec2['id']][2] = $rec2['percent_summ'];
}
if ($rows > 0) {
    $i = 0;
    while ($rec = mysql_fetch_array($rs)) {
        $rec['letnum'] = $i++;
        $rec['let_id'] = $rec[0];
        $rec['los_id'] = $rec['los_id'];
        $rec['letno'] = $rec['letno'];

Example #13

0

Show file

File: get_bag_res.php Project: qquk/IBAG

$psw = "bitdobru";
require 'func.php';
mysql_connect($h, $u, $psw) or die("Can't connect to database.");
mysql_select_db("dobro_db1") or die("Could not select database");
$query = "select * from cnvlist where id={$m1}";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$subquery = "select sum(ibttotalsumm), count(*) from ibag_transit t, `div` d where t.ibtdestdiv_id=d.div_id\n            and t.ibtdestdiv_id={$m4} and addsumm_id={$m1}";
$subresult = mysql_query($subquery) or die(mysql_error());
$row1 = mysql_fetch_array($subresult);
$datastr = explode("-", $row['cdate']);
$year = substr($row['cdate'], 0, 4);
$mon = substr($row['cdate'], 5, 2);
$day = substr($row['cdate'], 8, 2);
$strdate = $day . "." . $mon . "." . $year;
$str = get_div_name($m4) . "&nbsp;<b>" . $row['cnvstr'] . "</b>";
echo "<table width='100%'  border='0' cellspacing='0' cellpadding='0'>\n  <tr>\n     <td colspan=9>\n        <table width=100% border='0' cellpadding='1' cellspacing='0' >\n         <tr>\n            <td><b><font color='#000000' face='tahoma' size='2'>&nbsp;{$strdate}</font></b>&nbsp;\n           <font color='#800000' face='tahoma' size='2'>" . $str . "</font></td>\n         </tr>\n         <tr>\n <td colspan='2' ondblclick=f1_click({$m1},{$m4});>\n    <font color='#000000' face='tahoma' size='2'>&nbsp;Количество мест:</font>\n     &nbsp;<b><font color='#008000' face='tahoma' size='2'>" . $row1[1] . "</font></b>\n     &nbsp;<font  face='tahoma' size='2'>Сумма:</font>\n     &nbsp;<font color='#008000'  face='tahoma' size='2'><b>" . number_format($row1[0], 0, '.', ' ') . "</b></font>\n  </td>\n </tr>\n</table>\n     </td>\n  </tr>\n\n  <tr>\n    <td width='9%' align='center' valign='middle' class='cap1'>&nbsp</td>\n    <td width='20%'   height='18px' align='center' valign='middle' class='cap1'>Номер места</td>\n    <td width='9%' align='center' valign='middle' class='cap1'>Вес</td>\n    <td width='9%' align='center' valign='middle' class='cap1'>Объём</td>\n    <td align='center' valign='middle' class='cap1'>Доставка</td>\n    <td align='center' valign='middle' class='cap1'>Таможня</td>\n    <td align='center' valign='middle' class='cap1'>Страховка</td>\n    <td align='center' valign='middle' class='cap1'>Дополнительно</td>\n    <td align='center' valign='middle' class='cap1'>Сумма</td>\n  </tr>";
$datastr = explode(".", $m2);
$strdate = $datastr[2] . "-" . $datastr[1] . "-" . $datastr[0];
$query = "select sum(p.ibttotalsumm), sum(p.ibtpos), c.client_id, c.clientname, c.xcode\nfrom ibag_transit t, properties p, clients c\nwhere t.ibtdestdiv_id={$m4} and t.client_id=c.client_id\nand p.barcode=t.ibtbarcode and t.addsumm_id={$m1}  group by c.client_id order by c.xcode";
$result = mysql_query($query) or die(mysql_error());
while ($row0 = mysql_fetch_array($result)) {
    $subquery = "select c.xcode, p.ibtzagnum, c.clientname, p.ibtweight, p.ibtvolume, p.ibtdostav, t.ibtcustsumm, p.ibtstrahovka, p.ibtsummadd, p.ibttotalsumm, p.ibtshortzagnum\nfrom ibag_transit t, properties p, clients c\nwhere t.ibtdestdiv_id={$m4} and t.client_id=c.client_id\nand p.barcode=t.ibtbarcode and t.addsumm_id={$m1} and c.client_id={$row0['2']} order by p.ibtshortzagnum";
    $subresult = mysql_query($subquery) or die(mysql_error());
    echo "<tr>\n          <td colspan='10' class='let_list_data' height=20 valign='middle'>\n            &nbsp;\n            <b><font color='#800000' size='2'>{$row0['xcode']}</font><b>\n            &nbsp;\n               {$row0['clientname']}\n            &nbsp;Мест:\n            &nbsp; <font color='#000080'><b>{$row0['1']}</b></font>\n            &nbsp; Сумма:\n            &nbsp;  <font color='#008000'><b>{$row0['0']}</b></font>\n\n          </td>\n      </tr>";
    while ($row = mysql_fetch_array($subresult)) {
        echo "<tr>\n     <td width='9%' align='center' valign='middle' class='let_list_data'><b>" . $row['ibtshortzagnum'] . "</b></td>\n    <td width='20%'   height='18px' align='center' valign='middle' class='cap2'>" . $row[1] . "</td>\n    <td width='9%' align='center' valign='middle' class='cap2'>" . $row[3] . "</td>\n    <td width='9%' align='center' valign='middle' class='cap2'>" . $row[4] . "</td>\n    <td align='center' valign='middle' class='cap2'>" . $row[5] . "</td>\n    <td align='center' valign='middle' class='cap2'>" . $row[6] . "</td>\n    <td align='center' valign='middle' class='cap2'>" . $row[7] . "</td>\n    <td align='center' valign='middle' class='cap2'>" . $row[8] . "</td>\n    <td align='center' valign='middle' class='cap2'><b>" . $row[9] . "</b></td>\n    </tr>\n    ";
    }
}
print "</table>";
?>

Example #14

0

Show file

File: form_bagget_rep1.php Project: qquk/IBAG

<script>

function change_on(flag, id, cl) {
  if (flag==0) {
	eval("td100"+id+".className='"+cl+"_on'");
  } else {
	eval("td100"+id+".className='"+cl+"_off'");
  }
}
</script>

<?php 
$tdnum = 0;
mysql_connect($_SESSION['hostname'], $_SESSION['dbuser'], $_SESSION['dbpass']) or die("errror");
mysql_select_db($_SESSION['dbname']) or die("error");
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\n     <table  width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n     <tr><td>&nbsp;</td></tr>\n\n     <tr>\n     <td align=center>\n      <font face='Arial' style='font-sie:18pt'>Принятый багаж за период с <b>" . $date_1 . "</b> по <b>" . $date_2 . "</b></font>\n     </td>\n     </tr>\n\n     <tr>\n     <td align=center>\n      <font face='Arial' style='font-sie:18pt'><b>" . get_div_name($divis1) . "</b></font>\n     </td>\n     </tr>\n\n     <tr><td>&nbsp;</td></tr>\n\n     <tr>\n      <td align=center>\n\n<table x:str border=0 cellpadding=0 cellspacing=0  width='100%' style='border-collapse:\n collapse;table-layout:fixed;' bgcolor=#FFFFFF>\n <tr><td>&nbsp;</td></tr>\n <tr>\n  <td align=center style='font-family:Tahoma;font-size:8pt;color=#444444'>Таблица 1.1  <b>Сводная таблица.</b></td>\n </tr>\n <tr><td>&nbsp;</td></tr>\n</table>\n\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=7 style='mso-width-source:userset;mso-width-alt:3510;\n width:72pt'>\n\n<tr height=17 style='height:12.75pt'>\n  <td height=17  width=400 style='height:12.75pt;width:400pt'\n  x:str=''>&nbsp;</td>\n  <td colspan=3 class=let_list_fixed align=center width=96 style='width:72pt'><b>Принято</b></td>\n  <td colspan=3 class=let_list_fixed align=center width=96 style='border-left:none;width:72pt'><b>Отгружено</b></td>\n\n  <td align=right width=96 style='border-left:none;width:72pt'>&nbsp;</td>\n </tr>\n\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'>Вес</td>\n  <td class=let_list_fixed align=right width=96 style='border-left:none;width:72pt'>Обьём</td>\n </tr>\n";
$str = $divis1;
list($first_day, $first_mon, $first_year) = explode(".", $date_1);
list($last_day, $last_mon, $last_year) = explode(".", $date_2);
$query = "SELECT\n  sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3,\n  t.ibtgetdate\n  FROM ibag_transit t, properties p, ibag_movement m\n  where t.ibtbarcode=m.barcode and p.prop_id=m.prop_id and t.ibtgetdate>='{$first_year}-{$first_mon}-{$first_day}' and\n  t.ibtgetdate<='{$last_year}-{$last_mon}-{$last_day}' and t.ibtsourcediv_id='{$divis1}'\n   and m.trans_id=0\n  group by t.ibtgetdate";
$res3 = mysql_query($query) or die("errorrrrr");
$datecnt = 0;
while ($row3 = mysql_fetch_array($res3)) {
    $datearr[$datecnt] = $row3[3];
    $datecnt++;
    $ibagtransitcnt = $row3[0];
    $query1 = "SELECT\n   sum(p.ibtpos) AS FIELD_1, sum(p.ibtweight) AS FIELD_2, sum(p.ibtvolume) AS FIELD_3\n   FROM properties p, ibag_movement m, ibag_transit t\n  where m.barcode=t.ibtbarcode and p.prop_id=m.prop_id and m.trans_id<>0 and m.div_id='{$divis1}'\n   and m.ibmdate='{$row3['3']}'";
    $res31 = mysql_query($query1) or die("errorrrrr1");
    $row31 = mysql_fetch_array($res31);
    $sklad = "&nbsp;<font style='font-size:7pt'>день.&nbsp;</font><b>" . $row3[3] . "</b>";
    echo "\n   <tr height=17>\n   <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" onclick='javascript:document.forms[0].divis1.value={$row3['7']};parent.wsform.submit();' style='cursor:hand;' class=let_list_fixed_off style='height:27pt;border-top:none'>" . $sklad . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[0], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[1], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row3[2], 2, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[0], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[1], 0, '.', ' ') . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none' x:num>" . number_format($row31[2], 2, '.', ' ') . "</td>";

Example #15

0

Show file

File: form_bagget.php Project: qquk/IBAG

    //
    $query = "select DISTINCT d.parentdiv_id from {$dbname}.div d, ibag_transit t\n         where d.div_id=t.ibtsourcediv_id";
    $res = mysql_query($query) or die(mysql_error());
    while ($row = mysql_fetch_array($res)) {
        $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);
        echo "\n      <tr>\n       \n       <TD>\n         <table width=100% border=0 cellspacing=0 cellpadding=0>\n         <tr>\n          <td id='td" . $row[0] . "' class='otcmenu_off' onmouseover=\"change_on(0, {$row['0']}, 'otcmenu');\" onmouseout=\"change_on(1, {$row['0']}, 'otcmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row['0']};parent.wsform.submit();'>" . $str . "\n          </td>\n         </tr>\n\n         <tr>\n          <td>\n            <table width=100% border=0 cellspacing=0 cellpadding=0>\n            <tr>\n             <td width=250 valign=middle align=middle>{$imgstr}</td>\n             <td>\n              <table width=100% border=0 cellspacing=2 cellpadding=0>";
        $query = "select distinct t.ibtsourcediv_id, d.parentdiv_id, d.divname from\n             {$dbname}.div d, ibag_transit t\n             where t.ibtsourcediv_id=d.div_id and\n             d.parentdiv_id=" . $row[0] . " order by d.divname";
        $res2 = mysql_query($query) or die(mysql_error());
        while ($row2 = mysql_fetch_array($res2)) {
            $str = "&nbsp;   " . get_div_name($row2[1]) . " . <b>" . get_div_name($row2[0]) . "</b>";
            echo "\n        <tr>\n         <td width=20>&nbsp;</td>\n         <td width=250 id='td" . $row2[0] . "' class='otcsubmenu_off' onmouseover=\"change_on(0, {$row2['0']}, 'otcsubmenu');\" onmouseout=\"change_on(1, {$row2['0']}, 'otcsubmenu');\" style='cursor:hand;' onclick='javascript:document.forms[0].divis.value={$row2['0']};parent.wsform.submit();'>" . $str . "</td>\n         <td width=250>&nbsp;</td>\n        </tr>\n      ";
        }
        echo "         </table>\n              \n             </td>\n            </tr>\n            </table>\n          </td>\n         </tr>\n         </table>\n       </td>\n\n      </tr>\n      <tr>\n       <td width=20>&nbsp;</td>\n       <td>\n         <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>\n    ";
        /*
              <tr>
               <td width=20>&nbsp;</td>
               <td>
                 <table width=100% bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0>*/
        echo "</table>\n\n           </td>\n       </tr>";
    }
    echo "\n      <tr>\n        <td>&nbsp;</td>\n      </tr>\n      </table>\n      \n      \n  </form>\n      ";
}
?>
</body>
</html>

Example #16

0

Show file

File: showbag.php Project: qquk/IBAG

$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);
$rowpos = mysql_fetch_array($respos);
echo "Выбрано мест: <b>{$rowpos['0']}</b>&nbsp;Общий вес: <b>{$rowpos['1']}</b>&nbsp;Общий объём: <b>{$rowpos['2']}</b><br>";
$query = "select t.ibtbarcode, t.ibtgetdate, t.ibtbagnum, t.ibtocenka, p.ibttarif,\n         m.barcode, p.ibtzagnum, p.ibtpos, p.ibtweight, p.ibtvolume,  p.ibtsummpaied,\n         p.ibtfactura, p.ibtdostav, p.ibtstrahovka, p.ibtsummdept, p.ibtsummadd," . " p.ibtsummskidka, p.ibttotalsumm, c.clientname, c.xcode,\n        t.ibtsourcediv_id, t.ibtdestdiv_id, t.client_id\n        from ibag_transit t, ibag_movement m, properties p, clients c " . $query2;
$res = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($res);
$tdnum = 0;
while ($row = mysql_fetch_array($res)) {
    $tdnum++;
    if ($row['ibttotalsumm'] != $row['ibtsummdept'] + $row['ibtsummpaied']) {
        $rowcolor = '#FFE1E1';
    } else {
        $rowcolor = '#FFFFFF';
    }
    echo "\n    <tr style='background-color:{$rowcolor};'>\n     <td class=let_list_data2 valign='TOP'>\n      <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n       <tr>\n       <td class=let_list_fixed_off align=left valign=top style='cursor:hand;' width=80  id='td" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\" onclick=f22_click({$row['0']},0,0)>&nbsp;Опись</td>\n      </tr>\n      <tr>\n       <td class=let_list_data2 align=center style='border:0pt;font-size=8pt;color=#000000'><b>" . $row['ibtzagnum'] . "</b></td>\n      </tr>\n      <tr>\n       <td class=let_list_data2 align=center style='font-size=7pt;color=#777777'>{$row['0']}</td>\n      </tr>\n      <tr>\n       <td class=let_list_data2 align=center style='font-size=7pt;color=#777777'>{$row['2']}</td>\n      </tr>\n      </table>\n     </td>\n\n     <td class=let_list_data2 valign='TOP'>\n      <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n      <tr>\n       <td class=let_list_fixed_off align=left valign=top style='cursor:hand;' width=80  id='cd" . $tdnum . "' onMouseOut=\"change_on1(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on1(0, {$tdnum}, 'let_list_fixed');\" onclick=f22_click({$row['0']},{$t},{$row['22']},{$st},{$trs})>&nbsp;<b>Опись </b></td>\n      </tr>\n      <tr>\n       <td class=let_list_data2 align=center style='border:0pt;font-size=8pt;color=maroon'><b>" . $row['clientname'] . "</b></td>\n      </tr>\n      <tr>\n       <td align=center class=let_list_data2 style='font-size=8pt;color=#444444'>" . $row['xcode'] . "</td>\n      </tr>\n      </table>\n     </td>\n\n     <td class=let_list_data2 align=center style='font-family:tahoma;font-size:8pt;'><b>" . strftime("%d.%m.%Y", strtotime($row['ibtgetdate'])) . "</b>\n     </td>\n     <td class=let_list_data2 align=center><font style='font-size:7pt;color:#777777'>" . get_div_name($row['ibtsourcediv_id']) . "\n      </font><font style='font-size:8pt;color:#000000'> -> " . get_div_name($row['ibtdestdiv_id']) . "\n     </td>\n     <td class=let_list_data2 align=center style='font-size:10pt;'><b>" . $row['ibtpos'] . "</b>\n     </td>\n     <td class=let_list_data2 align=center style='font-size:10pt;color:navy'><b>" . number_format($row['ibtweight'], 0, '.', ' ') . "</b>\n     </td>\n     <td class=let_list_data2 align=center style='font-size:9pt;color:navy'>" . number_format($row['ibtvolume'], 3, '.', ' ') . "\n     </td>\n     <td class=let_list_data2 align=center style='font-size:10pt;color:maroon'>" . number_format($row['ibttarif'], 1, '.', ' ') . "\n     </td>\n     <td class=let_list_data2>\n\n      <table width=100% align=center valign=top border=0 cellpadding=0 cellspacing=1>\n      <tr>\n       <td width=50 class=let_list_data2 style='font-size=8pt;color=#444444'>К оплате</td>\n      </tr>\n      <tr>\n       <td width=120 class=let_list_data2 align=center style='font-family:Arial;font-size=12pt;color=#008040'><b>" . number_format($row['ibttotalsumm'], 1, '.', ' ') . "</b></td>\n      </tr>\n      <tr>\n       <td width=50 class=let_list_data2 style='font-size=8pt;color=#444444'>Оплачено</td>\n      </tr>\n      <tr>\n       <td width=120 class=let_list_data2 align=center style='font-family:Arial;font-size=12pt;color=#000080'><b>" . number_format($row['ibtsummpaied'], 1, '.', ' ') . "</b></td>\n      </tr>\n      </table>\n\n     </td>\n     <td class=let_list_data2 align=center style='font-family:Arial;font-size:12pt;color:maroon'><b>" . number_format($row['ibtsummdept'], 1, '.', ' ') . "</b>\n     </td>\n    </tr>\n      ";
}
echo "\n    </table>\n    \n    \n    \n   </td>\n  </tr>\n  </table>\n ";
mysql_free_result($res);
?>
<script>
function change_on(flag, id, cl) {
  if (flag==0) {
	eval("td"+id+".className='"+cl+"_on'");
  } else {
	eval("td"+id+".className='"+cl+"_off'");
  }
}
function change_on1(flag, id, cl) {
  if (flag==0) {
	eval("cd"+id+".className='"+cl+"_on'");

Example #17

0

Show file

File: form_bagpaied_rep1.php Project: qquk/IBAG

$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, tr.trans_id, tr.transinfo, tr.sourcediv_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 {$translist} and tr.trans_id in {$translist}\n        and m.div_id=tr.sourcediv_id and m.trans_id=tr.trans_id and t.ibtdestdiv_id={$divis1}\n  group by tr.trans_id";
$res3 = mysql_query($query) or die($query);
while ($row3 = mysql_fetch_array($res3)) {
    $sklad = "<font style='font-size:7pt'>" . get_div_name($row3['sourcediv_id']) . "</font><b>-" . $row3['transinfo'] . "</b>";
    if ($row3[6] == 0) {
        $rowcolor = '#FFFFFF';
    } else {
        $rowcolor = '#FFE1E1';
    }
    echo "\n   <tr height=17>\n   <td height=17 id='td100" . $tdnum . "' onMouseOut=\"change_on(1, {$tdnum}, 'let_list_fixed');\" onMouseOver=\"change_on(0, {$tdnum}, 'let_list_fixed');\"\n     onclick=\"javascript:wndOpen('oper/otcet/showbag_1.php?t=6&st={$divis1}&trs={$row3['trans_id']}');\" class=let_list_fixed style='cursor:hand;height:27pt;border-top:none'>&nbsp;" . $sklad . "</td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n     <table border=0 cellpadding=0 cellspacing=0>\n     <tr>\n      <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[0], 0, '.', ' ') . "</b>\n      </td>\n     </tr>\n     <tr>\n\n     </tr>\n     </table>\n   </td>\n\n\n   <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n     <table border=0 cellpadding=0 cellspacing=0>\n     <tr>\n      <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[3], 1, '.', ' ') . "</b>\n      </td>\n     </tr>\n     <tr>\n\n     </tr>\n     </table>\n   </td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n     <table border=0 cellpadding=0 cellspacing=0>\n     <tr>\n      <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[4], 1, '.', ' ') . "</b>\n      </td>\n     </tr>\n     <tr>\n\n     </tr>\n     </table>\n   </td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}' x:num>\n     <table border=0 cellpadding=0 cellspacing=0>\n     <tr>\n      <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[5], 1, '.', ' ') . "</b>\n      </td>\n     </tr>\n     <tr>\n\n     </tr>\n     </table>\n   </td>\n   <td class=let_list_data align=right style='border-top:none;border-left:none;background-color:{$rowcolor}'\n   x:num>\n     <table border=0 cellpadding=0 cellspacing=0>\n     <tr>\n      <td class=let_list_data2 align=right style='border:0pt' x:num><b>" . number_format($row3[6], 1, '.', ' ') . "</b>\n      </td>\n     </tr>\n     <tr>\n\n     </tr>\n     </table>\n   </td>\n   </tr>\n   ";
    $s1 = $s1 + $row3[0];
    $s2 = $s2 + $row3[1];
    $s3 = $s3 + $row3[2];
    $s4 = $s4 + $row3[3];
    $s5 = $s5 + $row3[4];
    $s6 = $s6 + $row3[5];
    $s7 = $s7 + $row3[6];
    $sd1 = $sd1 + $row_dest[0];
    $sd2 = $sd2 + $row_dest[1];

Example #18

0

Show file

File: excel.php Project: BrutalAndSick/scrap

function supervisores($f_division)
{
    ?>

<table align="center" border="1">
<thead>
	<tr>
		<td align="center" bgcolor="#FFCC00"><b>División</b></td>
        <td align="center" bgcolor="#FFCC00"><b>User ID</b></td>
        <td align="center" bgcolor="#FFCC00"><b>Empleado</b></td>
	</tr>
</thead>
<tbody>
<?php 
    $s_1 = "select empleados.usuario, empleados.nombre, empleados.apellidos, supervisores.* from supervisores, empleados ";
    $s_1 .= "where empleados.id = supervisores.id_emp and supervisores.id_division like '{$f_division}%' and ";
    $s_1 .= "empleados.autorizador='prod' order by apellidos, nombre";
    $r_1 = mysql_query($s_1);
    while ($d_1 = mysql_fetch_array($r_1)) {
        ?>
<tr>
    <td align="left"><?php 
        echo get_div_name($d_1['id_division']);
        ?>
</td>
    <td align="left"><?php 
        echo $d_1['usuario'];
        ?>
</td>
    <td align="left"><?php 
        echo $d_1['apellidos'] . " " . $d_['nombre'];
        ?>
</td>
</tr>
<?php 
    }
    ?>
</tbody>   
<?php 
}

Example #19

0

Show file

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 #20

0

Show file

File: form_bagpaied_rep0.php Project: qquk/IBAG

 $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 #21

0

Show file

File: capturistas.php Project: BrutalAndSick/scrap

function listado($f_division, $division, $pagina)
{
    //Revisar si es administrador o super administrador del sistema
    $s_ = "select super_admin, administrador from empleados where id='{$_SESSION['IDEMP']}'";
    $r_ = mysql_query($s_);
    $d_ = mysql_fetch_array($r_);
    if ($d_['super_admin'] == '1') {
        $admin = 2;
    }
    if ($d_['administrador'] == '1') {
        $admin = 1;
    }
    if (!$pagina) {
        $pagina = '1';
    }
    ?>
<div align="center" class="aviso">Los filtros son únicamente con fines de restricción, no de permisos. Si no agrega al capturista en esta lista, podrá ver todas las divisiones.</div><br>

<?php 
    if ($admin == '2') {
        ?>
<form action="?op=listado" method="post" name="form1">
<input type="hidden" name="f_division" value="<?php 
        echo $f_division;
        ?>
">
<table align="center" class="tabla" cellpadding="0" cellspacing="5">
<tr>	
	<td valign="top">División:</td>
	<td>
	<select name="division" style="width:350px;" class="texto">
      <option value=""></option>
	  <?php 
        $s_ = "select * from divisiones where activo='1' order by nombre";
        $r_ = mysql_query($s_);
        while ($d_ = mysql_fetch_array($r_)) {
            ?>
	  <option value="<?php 
            echo $d_['id'];
            ?>
" <?php 
            if ($division == $d_['id']) {
                ?>
 selected="selected"<?php 
            }
            ?>
><?php 
            echo $d_['nombre'];
            ?>
</option>
	  <?php 
        }
        ?>
	</select></td>
</tr>
<tr>		
	<td valign="top">Usuario:</td>
	<td>
	<select name="usuario" style="width:350px;" class="texto">
      <option value=""></option>
	  <?php 
        $s_ = "select * from empleados where capturista='1' and activo='1' order by apellidos, usuario";
        $r_ = mysql_query($s_);
        while ($d_ = mysql_fetch_array($r_)) {
            ?>
	  <option value="<?php 
            echo $d_['id'];
            ?>
" <?php 
            if ($usuario == $d_['id']) {
                ?>
 selected="selected"<?php 
            }
            ?>
>
	  	<?php 
            if (trim($d_['apellidos']) != '') {
                echo $d_['apellidos'] . " " . $d_['nombre'];
            } else {
                echo $d_['usuario'];
            }
            ?>
</option>
	  <?php 
        }
        ?>
	</select></td>
</tr>
</table>
</div>
<br><div align="center">
	<input type="button" value="Agregar" onclick="validar();" class="submit">
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<input type="button" class="submit" value="Exportar" onclick="exportar();">
</div>
</form>

<?php 
    }
    $s_ = "select empleados.usuario, empleados.nombre, empleados.apellidos, capturistas.* from capturistas, empleados ";
    $s_ .= "where empleados.id = capturistas.id_emp and capturistas.id_division like '{$f_division}%' and empleados.capturista='1' ";
    $s_ .= "order by apellidos, nombre";
    $r_ = mysql_query($s_);
    $n_ = mysql_num_rows($r_);
    $pags = ceil($n_ / 50);
    $ini_ = ($pagina - 1) * 50;
    $fin_ = 50;
    $i = 1;
    if ($pags > 0) {
        echo "<table align='center' border='0' cellpadding='0' cellspacing='0' class='texto'>";
        echo "<tr height='25'>";
        echo "<td width='120' align='center' bgcolor='#D8D8D8' style='border:#CCCCCB solid 1px;'>{$n_}&nbsp;Registros</td>";
        echo "<td width='3'></td>";
        while ($i <= $pags) {
            if ($pagina == $i) {
                $bg_img = '../imagenes/pag_on.jpg';
            } else {
                $bg_img = '../imagenes/pag_off.jpg';
            }
            echo "<td width='25' align='center' background='{$bg_img}' style='border:#CCCCCB solid 1px;'>";
            echo "<a href='?op=listado&f_division={$f_division}&pagina={$i}' class='link_paginas'>{$i}</a></td>";
            echo "<td width='3'></td>";
            $i++;
            $j++;
        }
        echo "</tr>";
        echo "</table><br>";
    }
    ?>

<form action="?op=por_division" method="post" name="form2">
<table align="center" border="0" cellpadding="0" cellspacing="0" class="texto">
<tr>
	<td><b><?php 
    echo $div[$i]['nom'];
    ?>
</b></td>
</tr>
<tr>
	<td>
	<table align="center" class="tabla">
	<thead>
	<tr bgcolor="#E6E6E6" height="20">
		<td width="40" align="center">No.</td>
		<td width="120" align="center">
		<select name="f_division" class="texto" style="width:120px;" onchange="submit();">
		<option value="">División</option>
		<?php 
    $s_1 = "select * from divisiones where activo='1' order by nombre";
    $r_1 = mysql_query($s_1);
    while ($d_1 = mysql_fetch_array($r_1)) {
        ?>
		   <option value="<?php 
        echo $d_1['id'];
        ?>
" <?php 
        if ($f_division == $d_1['id']) {
            ?>
 selected="selected"<?php 
        }
        ?>
><?php 
        echo $d_1['nombre'];
        ?>
</option>
		   <?php 
    }
    ?>
		</select>		
		</td>
		<td width="150" align="center">User ID</td>
		<td width="400" align="center">Empleado</td>
		<td width="40" align="center">Borrar</td>
	</tr>	
	</thead>
	<tbody>
	<?php 
    $s_ .= " limit {$ini_},{$fin_}";
    $i = $ini_ + 1;
    $r_ = mysql_query($s_);
    while ($d_ = mysql_fetch_array($r_)) {
        ?>
	<tr onMouseOut="this.style.background='#F7F7F7'" onMouseOver="this.style.background='#FFDD99'" bgcolor="#F7F7F7" height="20">
		<td align="center"><?php 
        echo $i;
        ?>
</td>
        <td align="left">&nbsp;&nbsp;<?php 
        echo get_div_name($d_['id_division']);
        ?>
</td>
		<td align="left">&nbsp;&nbsp;<?php 
        echo $d_['usuario'];
        ?>
</td>
		<td align="left">&nbsp;&nbsp;<?php 
        echo $d_['apellidos'] . " " . $d_['nombre'];
        ?>
</td>
		<td align="center">
			<?php 
        if ($admin == '2') {
            ?>
            <a href="?op=eliminar&id_=<?php 
            echo $d_['id'];
            ?>
"><img src="../imagenes/delete.gif" border="0"></a><?php 
        } else {
            ?>
            <img src="../imagenes/delete_gris.gif" border="0"><?php 
        }
        ?>
</td>
	</tr><?php 
        $i++;
    }
    ?>
	
	</tbody>	
	</table>
	</td>
</tr>		
</table><br>
<?php 
    echo "<br><br><br>";
}

PHP get_div_name Examples