282 lines
15 KiB
PHP
282 lines
15 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site810']))
|
|
{
|
|
?>
|
|
|
|
<script>
|
|
$(function() {$("#data_01").datepicker({changeMonth: true,changeYear: true});});
|
|
$(function() {$("#data_02").datepicker({changeMonth: true,changeYear: true});});
|
|
</script>
|
|
<!--<div id='loader-wrapper'><div id='loader'></div></div>-->
|
|
|
|
<?php
|
|
//usuwanie zlecenia
|
|
if (!empty($_SESSION['site810_edit']) && $_GET['acc']=='del' && $_GET['ord']>0)
|
|
{
|
|
mysql_query("DELETE FROM seg_orders WHERE ORD_ID=".$_GET['ord']);
|
|
mysql_query("DELETE FROM seg_order_obj_params WHERE OWP_ORD_ID=".$_GET['ord']);
|
|
mysql_query("DELETE FROM seg_order_new_agg_params WHERE ONA_ORD_ID=".$_GET['ord']);
|
|
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
|
|
|
|
}
|
|
|
|
?>
|
|
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn'])
|
|
{
|
|
$_GET['pgn']=1;
|
|
delSearchSessionData();
|
|
}
|
|
|
|
|
|
|
|
|
|
//zapamiętywanie pól formularza
|
|
if ($_POST['sub_search']=='Szukaj') $_SESSION['site810_input'] = $_POST['sr_order'];
|
|
|
|
if (empty($_SESSION['site810_sr_status'])) $_SESSION['site810_sr_status']=100000;
|
|
if (!empty($_POST['sr_status'])) $_SESSION['site810_sr_status']=$_POST['sr_status'];
|
|
|
|
if (empty($_SESSION['site810_sr_filtr'])) $_SESSION['site810_sr_filtr']=1;
|
|
if (!empty($_POST['sr_filtr'])) $_SESSION['site810_sr_filtr']=$_POST['sr_filtr'];
|
|
|
|
if (!empty($_POST['sr_all'])) $_SESSION['site810_sr_all'] = $_POST['sr_all'];
|
|
if ($_POST['sub_search']=='Szukaj' && empty($_POST['sr_all'])) unset($_SESSION['site810_sr_all']);
|
|
|
|
if (empty($_SESSION['site810_inDatefrom'])) $_SESSION['site810_inDatefrom']=date('Y-m')."-01";
|
|
if (!empty($_POST['inDate01'])) $_SESSION['site810_inDatefrom']=$_POST['inDate01'];
|
|
|
|
if (empty($_SESSION['site810_inDateto'])) $_SESSION['site810_inDateto']=date('Y-m-d');
|
|
if (!empty($_POST['inDate02'])) $_SESSION['site810_inDateto']=$_POST['inDate02'];
|
|
|
|
|
|
?>
|
|
|
|
|
|
<form action="./?pg=site810&pgn=1" method="post">
|
|
<div class="tag100">
|
|
<table>
|
|
<tr>
|
|
<td>
|
|
<select name="sr_filtr">
|
|
<option value="1" <?php if($_SESSION['site810_sr_filtr']==1) echo "selected"; ?> >Nr zlecenia</option>
|
|
<option value="2" <?php if($_SESSION['site810_sr_filtr']==2) echo "selected"; ?> >Obiekt</option>
|
|
<option value="3" <?php if($_SESSION['site810_sr_filtr']==3) echo "selected"; ?> >Bariera</option>
|
|
</select>
|
|
</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="text" name="sr_order" value="<?php echo $_SESSION['site810_input'];?>"></td>
|
|
|
|
<td style="width: 10px;"></td>
|
|
<td>data od:</td>
|
|
<td><INPUT STYLE='text-align: right' TYPE='TEXT' id='data_01' NAME='inDate01' value='<?php echo $_SESSION['site810_inDatefrom']; ?>' SIZE='10'></TD>
|
|
<td style="width: 10px;"></td>
|
|
<td>do:</td>
|
|
<td><INPUT STYLE='text-align: right' TYPE='TEXT' id='data_02' NAME='inDate02' value='<?php echo $_SESSION['site810_inDateto']; ?>' SIZE='10'></TD>
|
|
|
|
|
|
|
|
<td style="width: 10px;"></td>
|
|
<td>status:</td>
|
|
<td style="width: 5px;"></td>
|
|
<td>
|
|
<select name="sr_status">
|
|
<?php
|
|
$wynik = mysql_query("select DIC_ID,DIC_POL_LANG from sys_dictionaries where DIC_TYPE='ORDER_STATUS'");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$resID=$r["DIC_ID"];
|
|
$resDESC=$r["DIC_POL_LANG"];
|
|
|
|
if ($_SESSION['site810_sr_status']==$resID)
|
|
echo"<option value='$resID' selected>$resDESC</option>";
|
|
else
|
|
echo"<option value='$resID'>$resDESC</option>";
|
|
}
|
|
if ($_SESSION['site810_sr_status']==999999)
|
|
echo"<option value='999999' selected>Niezakończone</option>";
|
|
else
|
|
echo"<option value='999999'>Niezakończone</option>";
|
|
|
|
|
|
if ($_SESSION['site810_sr_status']==100000)
|
|
echo"<option value='100000' selected>Wszystkie</option>";
|
|
else
|
|
echo"<option value='100000'>Wszystkie</option>";
|
|
?>
|
|
</select>
|
|
</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="submit" name="sub_search" value="Szukaj" class="btn btn-default btn-sm"></td>
|
|
<td></td>
|
|
</tr>
|
|
<tr><td> </td></tr>
|
|
<tr>
|
|
<td colspan="3">
|
|
<?php
|
|
if (!empty($_SESSION['site810_sr_all'])) echo"<input type='checkbox' name='sr_all' value='1' checked>";
|
|
else echo"<input type='checkbox' name='sr_all' value='1'>";
|
|
?>
|
|
Pokaż wszystkie</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</form>
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site810_001 ;?></div>
|
|
<div class="tag">
|
|
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Lp.</TD>
|
|
<TD class="label"><?php echo $lab_Field_site810_001 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f0=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f0=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
<TD class="label"><?php echo $lab_Field_site810_002 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f1=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f1=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
<TD class="label"><?php echo $lab_Field_site810_003 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f2=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f2=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
<TD class="label"><?php echo $lab_Field_site810_004 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f3=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f3=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
<TD class="label"><?php echo $lab_Field_site810_005 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f4=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f4=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
<TD class="label"><?php echo $lab_Field_site810_006 ;?> <a style="text-decoration: none;" href="./?pg=site810&pgn=1&f5=a"><?php echo $lab_Icon_SortUp ;?></a><a style="text-decoration: none;" href="./?pg=site810&pgn=1&f5=z"><?php echo $lab_Icon_SortDown ;?></a></td>
|
|
</TR>
|
|
|
|
<?php
|
|
|
|
if (empty($_SESSION['site810_array']) || $_POST['sub_search']=='Szukaj')
|
|
{
|
|
//$query="select ORD_ID,ORD_NO,ORD_DRS_ID,ORD_OBJ_NAME,ORD_OBJ_TYPE,ORD_SCOPE_DIC_ID,ORD_STATUS_DIC_ID,ORD_AUDIT_DATE,SOD_UJ,SOD_PLC from seg_orders left join seg_object_def on SOD_NAME=ORD_OBJ_NAME";
|
|
$query="select ORD_ID,ORD_NO,ORD_DRS_ID,ORD_OBJ_NAME,ORD_OBJ_TYPE,ORD_SCOPE_DIC_ID,ORD_STATUS_DIC_ID,ORD_AUDIT_DATE,OHC_UJ,DRS_DEPARTMENT from seg_orders,seg_dev_resources left join seg_object_hole_cards on DRS_ID=OHC_DRS_ID where DRS_ID=ORD_DRS_ID and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."'";
|
|
if ($_SESSION['site810_sr_filtr']==1)
|
|
$query .=" and ORD_NO like '%".$_SESSION['site810_input']."%'";
|
|
if ($_SESSION['site810_sr_filtr']==2)
|
|
$query .=" and ORD_OBJ_NAME like '%".$_SESSION['site810_input']."%'";
|
|
if ($_SESSION['site810_sr_filtr']==3)
|
|
$query .=" and OHC_UJ like '%".$_SESSION['site810_input']."%'";
|
|
if ($_SESSION['site810_sr_status']==851) $query .= " and ORD_STATUS_DIC_ID = 851";
|
|
if ($_SESSION['site810_sr_status']==852) $query .= " and ORD_STATUS_DIC_ID = 852";
|
|
if ($_SESSION['site810_sr_status']==853) $query .= " and ORD_STATUS_DIC_ID = 853";
|
|
if ($_SESSION['site810_sr_status']==999999) $query .= " and ORD_STATUS_DIC_ID in (851,852)";
|
|
$query .= " and ORD_AUDIT_DATE>='".$_SESSION['site810_inDatefrom']."' and ORD_AUDIT_DATE<='".$_SESSION['site810_inDateto']."'";
|
|
$query .=" order by ORD_AUDIT_DATE desc";
|
|
if (empty($_SESSION['site810_sr_all'])) $query .=" limit 100";
|
|
|
|
|
|
$res=null;
|
|
$wynik = mysql_query($query);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$res[]=array(
|
|
'orderID' => $r["ORD_ID"],
|
|
'orderNo' => $r["ORD_NO"],
|
|
'devID' => $r["ORD_DRS_ID"],
|
|
'devName' => $r["ORD_OBJ_NAME"],
|
|
'devType' => $r["ORD_OBJ_TYPE"],
|
|
'bariera' => $r["SOD_UJ"],
|
|
'plc' => $r["SOD_PLC"],
|
|
'orderScopeID'=> $r["ORD_SCOPE_DIC_ID"],
|
|
'orderScope' => setDicName($r["ORD_SCOPE_DIC_ID"]),
|
|
'orderStatus' => setDicName($r["ORD_STATUS_DIC_ID"]),
|
|
'orderDate' => substr($r["ORD_AUDIT_DATE"],0,10)
|
|
);
|
|
}
|
|
unset($_SESSION['site810_array']);
|
|
$_SESSION['site810_array']=$res;
|
|
}
|
|
|
|
|
|
|
|
// sortowanie wyników
|
|
// =========================================================================================== //
|
|
if ($_GET['f0']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderNo', 'ASC','str');
|
|
else if ($_GET['f0']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderNo', 'DESC','str');
|
|
else if ($_GET['f1']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'devName', 'ASC','str');
|
|
else if ($_GET['f1']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'devName', 'DESC','str');
|
|
else if ($_GET['f2']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'bariera', 'ASC','str');
|
|
else if ($_GET['f2']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'bariera', 'DESC','str');
|
|
else if ($_GET['f3']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderScope', 'ASC','str');
|
|
else if ($_GET['f3']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderScope', 'DESC','str');
|
|
else if ($_GET['f4']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderDate', 'ASC','str');
|
|
else if ($_GET['f4']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderDate', 'DESC','str');
|
|
else if ($_GET['f5']=='a')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderStatus', 'ASC','str');
|
|
else if ($_GET['f5']=='z')
|
|
$_SESSION['site810_array'] = sortmddata($_SESSION['site810_array'], 'orderStatus', 'DESC','str');
|
|
// =========================================================================================== //
|
|
|
|
|
|
$start=($_GET['pgn']-1)*20;
|
|
$stop = $_GET['pgn']*20;
|
|
if ($stop>count($_SESSION['site810_array'])) $stop=count($_SESSION['site810_array']);
|
|
|
|
for($i=$start;$i<$stop;$i++)
|
|
{
|
|
$bgcol=null;
|
|
if ($_SESSION['site810_array'][$i]['orderStatus']=='Zakończone')
|
|
$bgcol = "background-color: rgba(0, 255, 0, 0.1);";
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer; ".$bgcol."' onclick=".chr(34)."document.location.href='?pg=site810inf&id=".$_SESSION['site810_array'][$i]['orderID']."'".chr(34).">
|
|
<TD class='field_right'>".($i+1).".</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['orderNo']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['devName']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['bariera']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['orderScope']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['orderDate']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site810_array'][$i]['orderStatus']."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
|
|
<table style="width:100%; background-color: #f5f5f5">
|
|
<tr>
|
|
<td style="width: 25%; text-align: left;"><span class="resume">Wyników: <?php echo count($_SESSION['site810_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site810_array'])>20)
|
|
echo pagination_grid('./?pg=site810', $_GET['pgn'], count($_SESSION['site810_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
<a href="./export/site810_xls.php" target="_blank" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site810_pdf.php" target="_blank" title="Export do PDF"><img src="./images/pdf_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site810_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site810_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site810A_1'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|