/beta/shopfloor/orderDesk.asp
ASP | 575 lines | 498 code | 47 blank | 30 comment | 52 complexity | c345353b7794eed840a867e3484fa607 MD5 | raw file
1<%@LANGUAGE="VBSCRIPT" CODEPAGE="1256"%><% 2'shopfloor (3) 3PageTitle="���� �����" 4SubmenuItem=6 5if not Auth(3 , 6) then NotAllowdToViewThisPage() 6 7'OutService Page Request 8'By Alix - Last changed: 81/01/13 9%> 10<!--#include file="top.asp" --> 11<!--#include File="../include_farsiDateHandling.asp"--> 12<!--#include File="../include_UtilFunctions.asp"--> 13<STYLE> 14 .GetCustTbl {font-family:tahoma; background-color: #DDDDDD; width:630; direction: RTL; } 15 .GetCustTbl td {padding:2; font-size: 9pt; height:25;} 16 .GetCustInp { font-family:tahoma; font-size: 9pt;} 17 .CusTableHeader {background-color: #33AACC; text-align: center; font-weight:bold;} 18 .CustContactTable {font-family:tahoma; width:100%; border:1 solid black; direction: RTL; background-color:#CCCCCC;} 19 .CustContactTable td {padding:5;} 20 .CustTable {font-family:tahoma; width:80%; border:1 solid black; direction: RTL; background-color:black;} 21 .CustTable td {padding:5;} 22 .CustTable a {text-decoration:none;color:#000088} 23 .CustTable a:hover {text-decoration:underline;} 24 .CusTD1 {background-color: #CCCC66; text-align: left; font-weight:bold;} 25 .CusTD2 {background-color: #DDDDDD; direction: LTR; text-align: right; font-size:9pt;} 26 .CusTD3 {background-color: #DDDDDD; direction: LTR; text-align: center; font-size:9pt;} 27 .CusTD4 {background-color: #CCCC66; direction: LTR; text-align: center; font-size:9pt;} 28 .CustTable4 {font-family:tahoma; direction: RTL; width:100%; height:100%; background-color:#C3DBEB;} 29 .repHeader td{text-align: center; font-size:7pt;} 30</STYLE> 31<% 32'----------------------------------------------------------------------------------------------------- 33'------------------------------------------------------------------------ Edit Order Desk Items Action 34'----------------------------------------------------------------------------------------------------- 35if request("act")="doEdit" then 36 37 'response.write "<br>" & replace(request.form,"&","<br>") 38 'response.end 39 40 for i = 1 to request.form("id").count 41 radif_sefareshat = request.form("radif_sefareshat")(i) 42 size = request.form("size")(i) 43 forms = request.form("forms")(i) 44 tirag = request.form("tirag")(i) 45 zinc = request.form("zinc")(i) 46 is2roo = request.form("is2roo")(i) 47 colorStatus = request.form("colorStatus")(i) 48 lastEditedBy = session("id") 49 lastEditedDate = shamsiToday() 50 orderDeskItemID = request.form("id")(i) 51 52 mySQL2="UPDATE orderDesk SET [size] = '" & size & "', forms =" & forms & ", Tirag ='" & Tirag & "', Zinc ='" & Zinc & "', is2roo ='" & is2roo & "', colorStatus ='" & colorStatus & "', lastEditedBy =" & lastEditedBy & ", lastEditedDate ='" & lastEditedDate & "' where id=" & orderDeskItemID 53 54 conn.execute(mySQL2) 55 next 56 response.redirect "orderDesk.asp" 57 58end if 59 60'----------------------------------------------------------------------------------------------------- 61'----------------------------------------------------------------------------- Add to Order Desk Table 62'----------------------------------------------------------------------------------------------------- 63if request("submit")="������" then 64 'response.write "==" & replace(request.form, "&", "<br>") 65 radif_sefareshat = request.form("radif_sefareshat") 66 size = request.form("size") 67 forms = request.form("forms") 68 tirag = request.form("tirag") 69 zinc = request.form("zinc") 70 is2roo = request.form("is2roo") 71 colorStatus = request.form("colorStatus") 72 createdBy = session("id") 73 createdDate = shamsiToday() 74 75 mySQL="INSERT INTO orderDesk (order_ID, [size], forms, Tirag, Zinc, is2roo, colorStatus, createdBy, createdDate) VALUES (" & radif_sefareshat & ", '" & size & "', '" & forms & "', '" & tirag & "', '" & zinc & "', '" & is2roo & "', '" & colorStatus & "'," & createdBy & ", '" & createdDate & "')" 76 conn.execute(mySQL) 77 response.redirect "orderDesk.asp" 78end if 79 80'----------------------------------------------------------------------------------------------------- 81'------------------------------------------------------------------------------ Print Order Desk Items 82'----------------------------------------------------------------------------------------------------- 83if request("submit")="������ ����� ������" then 84%> 85 <BR> <BR> 86 <CENTER> 87 <% ReportLogRow = PrepareReport ("orderDesk.rpt", "alak", ".", "/beta/dialog_printManager.asp?act=Fin") %> 88 <INPUT TYPE="button" value=" �ǁ " Class="GenButton" style="border:1 solid blue;" onclick="printThisReport(this,<%=ReportLogRow%>);"> 89 90 </CENTER> 91 92 <BR> 93 <iframe name=f1 id=f1 src="/CRReports/?Id=<%=ReportLogRow%>" align=center style="width:750; height:410; border-style: none" border=0 FRAMEBORDER=0 scrollbars=no></iframe> 94<% 95 response.end 96 97'----------------------------------------------------------------------------------------------------- 98'------------------------------------------------------------------------------ Print Order Desk Items 99'----------------------------------------------------------------------------------------------------- 100elseif request("submit")="�ǁ ������ ������" then 101 102 mySQL2="UPDATE orderDesk SET selected4print = 0 WHERE (selected4print = 1)" 103 conn.execute(mySQL2) 104 105 for i = 1 to request.form("id").count 106 orderDeskItemID = request.form("id")(i) 107 108 mySQL2="UPDATE orderDesk SET selected4print = 1 WHERE id=" & orderDeskItemID 109 conn.execute(mySQL2) 110 next 111 'response.redirect "orderDesk.asp" 112%> 113 <BR> <BR> 114 <CENTER> 115 <% ReportLogRow = PrepareReport ("orderDesk.rpt", "alak", ".", "/beta/dialog_printManager.asp?act=Fin") %> 116 <INPUT TYPE="button" value=" �ǁ " Class="GenButton" style="border:1 solid blue;" onclick="printThisReport(this,<%=ReportLogRow%>);"> 117 118 </CENTER> 119 120 <BR> 121 <iframe name=f1 id=f1 src="/CRReports/?Id=<%=ReportLogRow%>" align=center style="width:750; height:410; border-style: none" border=0 FRAMEBORDER=0 scrollbars=no></iframe> 122<% 123 response.end 124'----------------------------------------------------------------------------------------------------- 125'------------------------------------------------------------------------------- Edit Order Desk Items 126'----------------------------------------------------------------------------------------------------- 127elseif request("submit")="������" then 128%> 129 <FORM METHOD=POST ACTION="?act=doEdit"><BR><BR> 130 <table class="CustTable" cellspacing='1' style='width:95%;' align=center> 131 <tr> 132 <td colspan="10" class="CusTableHeader" style="text-align:right;">������ ���� ������ ���� �����</td> 133 </tr> 134 <tr> 135 <td class="CusTD3"><small>����� �����</small></td> 136 <td class="CusTD3"><small>����� ����� \<font color="aaaaaa"> ����� ���</small></font></td> 137 <td class="CusTD3"><small> �����</small></td> 138 <td class="CusTD3"><small>����</small></td> 139 <td class="CusTD3"><small>����� ���</small></td> 140 <td class="CusTD3"><small>���ǎ �� ���</small></td> 141 <td class="CusTD3"><small>����</small></td> 142 <td class="CusTD3"><small>��</small></td> 143 <td class="CusTD3"><small>���</small></td> 144 </tr> 145<% 146for i = 1 to request.form("id").count 147 orderDeskItemID = request.form("id")(i) 148 149 if not isNumeric(orderDeskItemID) then 150 call showAlert("���! ����� ����� ���� ��� ����.",CONST_MSG_ERROR) 151 response.end 152 end if 153 154 mySQL="SELECT orderDesk.*, orders_trace.return_date, orders_trace.company_name, orders_trace.customer_name, orders_trace.order_title FROM orderDesk INNER JOIN orders_trace ON orderDesk.order_ID = orders_trace.radif_sefareshat where id=" & orderDeskItemID 155 156 Set RS1 = conn.execute(mySQL) 157 if RS1.eof then 158 call showAlert("���! ��� ����� ����� ���� �����.",CONST_MSG_ERROR) 159 response.end 160 end if 161%> 162 163 <TR bgcolor="#FFFFFF"><INPUT TYPE="hidden" name="id" value="<%=RS1("id")%>"> 164 <TD dir="LTR" align='right'><%=RS1("return_date")%></TD> 165 <TD><A HREF="../shopfloor/manageOrder.asp?radif=<%=RS1("order_id")%>" target="_blank"><%=RS1("customer_name")%> - <%=RS1("company_name")%><BR><BR><font color="aaaaaa"><%=RS1("order_title")%></font></A></TD> 166 <TD dir="LTR" align='center'><INPUT TYPE="hidden" NAME="radif_sefareshat" value="<%=RS1("order_id")%>" size=3><%=RS1("order_id")%></TD> 167 <TD dir="LTR" align='center'><INPUT TYPE="text" NAME="size" size=5 value="<%=trim(RS1("size"))%>"></TD> 168 <TD dir="LTR" align='center'><INPUT TYPE="text" NAME="forms" size=3 value="<%=trim(RS1("forms"))%>"></TD> 169 <TD dir="LTR" align='center'><INPUT TYPE="text" NAME="tirag" size=3 value="<%=trim(RS1("tirag"))%>"></TD> 170 <TD dir="LTR" align='center'><INPUT TYPE="text" NAME="zinc" size=3 value="<%=trim(RS1("zinc"))%>"></TD> 171 <TD dir="RTL" align='center'> 172 <SELECT NAME="is2roo" style="font-family:tahoma; font-size:8pt"> 173 <option value="0" <% if RS1("is2roo")="0" then %>selected<% end if %>>�� ��</option> 174 <option value="1" <% if RS1("is2roo")="1" then %>selected<% end if %>>���</option> 175 <option value="2" <% if RS1("is2roo")="2" then %>selected<% end if %>>����</option> 176 <option value="3" <% if RS1("is2roo")="3" then %>selected<% end if %>>�����</option> 177 </SELECT> 178 </TD> 179 <TD dir="RTL" align='center'> 180 <SELECT NAME="colorStatus" style="font-family:tahoma; font-size:8pt"> 181 <option value="0" <% if RS1("colorStatus")="0" then %>selected<% end if %>>���������</option> 182 <option value="1" <% if RS1("colorStatus")="1" then %>selected<% end if %>>�����</option> 183 <option value="2" <% if RS1("colorStatus")="2" then %>selected<% end if %>>�����</option> 184 </SELECT> 185 </TD> 186 </TR> 187 <% 188next 189%> 190 </table> 191 <CENTER><BR> 192 <INPUT TYPE="submit" value="�����"> <INPUT TYPE="button" value="������" onclick="javascript:history.go(-1)"> 193 </CENTER> 194 </FORM> 195<% 196 197response.end 198 199end if 200 201'----------------------------------------------------------------------------------------------------- 202'------------------------------------------------------------------------------- Show Order Desk Table 203'----------------------------------------------------------------------------------------------------- 204%> 205<TABLE class="RepTable" width='100%' align='center' > 206<TR> 207 <td align=left>�����:</td> 208 <td align=right> 209 <INPUT NAME="SearchBox" TYPE="Text" style="border:1 solid black;width:150px;" Value="" onKeyPress="return handleSearch();"></td> 210 211 <td align=left><A HREF="#openOrders"> ���� ����� ��� ��� <FONT face="Wingdings" size=8>H</FONT></A></td> 212</TR> 213</TABLE> 214 215<TaBlE class="CustTable4" cellspacing="2" cellspacing="2"> 216<Tr> 217<Td colspan="2" valign="top" align="center"> 218<FORM METHOD=POST ACTION=""> 219<table class="CustTable" cellspacing='1' style='width:98%;'> 220 <tr> 221 <td colspan="13" class="CusTableHeader" style="text-align:left;"> 222 <TABLE width=100% cellspacing=0 cellpadding=0> 223 <TR> 224 <TD><B>���� ������ ���� �����</B></TD> 225 <TD align=left> 226 <INPUT TYPE="submit" name="submit" value="������ ����� ������"> 227 <INPUT TYPE="submit" name="submit" value="�ǁ ������ ������"> 228 <INPUT TYPE="submit" name="submit" value="������"></TD> 229 </TR> 230 </TABLE> 231 </td> 232 </tr> 233 <% 234 Ord=request("Ord") 235 236 select case Ord 237 case "1": 238 order= " ORDER BY orders_trace.return_date" 239 case "-1": 240 order= " ORDER BY orders_trace.return_date DESC" 241 case "2": 242 order= " ORDER BY orders_trace.customer_name" 243 case "-2": 244 order= " ORDER BY orders_trace.customer_name DESC" 245 case "3": 246 order= " ORDER BY orders_trace.radif_sefareshat" 247 case "-3": 248 order= " ORDER BY orders_trace.radif_sefareshat DESC" 249 case "4": 250 order= " ORDER BY orderDesk.[size]" 251 case "-4": 252 order= " ORDER BY orderDesk.[size] DESC" 253 case "5": 254 order= " ORDER BY convert(int,orderDesk.forms)* convert(int,orderDesk.Tirag), orders_trace.return_date" 255 case "-5": 256 order= " ORDER BY convert(int,orderDesk.forms)* convert(int,orderDesk.Tirag) DESC, orders_trace.return_date" 257 case "6": 258 order= " ORDER BY convert(int,orderDesk.Zinc), orders_trace.return_date" 259 case "-6": 260 order= " ORDER BY convert(int,orderDesk.Zinc) DESC , orders_trace.return_date" 261 case "7": 262 order= " ORDER BY orderDesk.is2roo" 263 case "-7": 264 order= " ORDER BY orderDesk.is2roo DESC" 265 case "8": 266 order= " ORDER BY orderDesk.colorStatus" 267 case "-8": 268 order= " ORDER BY orderDesk.colorStatus DESC" 269 case "9": 270 order= " ORDER BY orders_trace.marhale" 271 case "-9": 272 order= " ORDER BY orders_trace.marhale DESC" 273 case else: 274 order= " ORDER BY orders_trace.return_date" 275 Ord=1 276 end select 277 278 279 mySQL="SELECT orders_trace.return_date, orders_trace.marhale, orders_trace.customer_name, orders_trace.company_name, orders_trace.radif_sefareshat, orders_trace.order_title, orderDesk.id, orderDesk.[size], orderDesk.Tirag, orderDesk.forms, orderDesk.Zinc, orderDesk.is2roo, orderDesk.colorStatus FROM orderDesk INNER JOIN orders_trace ON orderDesk.order_ID = orders_trace.radif_sefareshat INNER JOIN Orders ON orders_trace.radif_sefareshat = Orders.ID where (orders_trace.Type = 2) AND (orders_trace.status = 1) AND (orders_trace.step NOT IN (11, 13, 10)) AND (Orders.Closed = 0)" & order 280 Set RS1 = conn.execute(mySQL) 281 if RS1.eof then 282%> 283 <tr> 284 <td colspan="13" class="CusTD3">����</td> 285 </tr> 286<% 287 else 288 289 if ord<0 then 290 style="background-color: #33CC99;" 291 arrow="<br><span style='font-family:webdings'>6</span>" 292 else 293 style="background-color: #33CC99;" 294 arrow="<br><span style='font-family:webdings'>5</span>" 295 end if 296%> 297 298 <tr class="repHeader" bgcolor="eeeeee" style="cursor:hand;" title="����� �����"> 299 <td>#</td> 300 <td onclick='go2Page(1,1);' style="<%if abs(ord)=1 then response.write style%>">����� ����� <%if abs(ord)=1 then response.write arrow%></TD> 301 <td onclick='go2Page(1,2);' style="<%if abs(ord)=2 then response.write style%>">����� ����� \ ����� ���<%if abs(ord)=2 then response.write arrow%></TD> 302 <td onclick='go2Page(1,9);' style="<%if abs(ord)=9 then response.write style%>">�����<%if abs(ord)=9 then response.write arrow%></TD> 303 <td onclick='go2Page(1,3);' style="<%if abs(ord)=3 then response.write style%>"> ����� <%if abs(ord)=3 then response.write arrow%></TD> 304 <td onclick='go2Page(1,4);' style="<%if abs(ord)=4 then response.write style%>">���� <%if abs(ord)=4 then response.write arrow%></TD> 305 <td onclick='go2Page(1,5);' style="<%if abs(ord)=5 then response.write style%>">����� <%if abs(ord)=5 then response.write arrow%></TD> 306 <td onclick='go2Page(1,6);' style="<%if abs(ord)=6 then response.write style%>">���� <%if abs(ord)=6 then response.write arrow%></TD> 307 <td onclick='go2Page(1,7);' style="<%if abs(ord)=7 then response.write style%>">�� <%if abs(ord)=7 then response.write arrow%></TD> 308 <td onclick='go2Page(1,8);' style="<%if abs(ord)=8 then response.write style%>">��� <%if abs(ord)=8 then response.write arrow%></TD> 309 <td title=''>���� � ��� �����</TD> 310 </tr> 311 <TR bgcolor="black" height="1"> 312 <TD colspan="10" style="padding:0;"></TD> 313 </TR> 314 315<% 316 tmpCounter=0 317 Do while not RS1.eof 318 tmpCounter = tmpCounter + 1 319 if tmpCounter mod 2 = 1 then 320 tmpColor="#FFFFFF" 321 tmpColor2="#FFFFBB" 322 Else 323 tmpColor="#DDDDDD" 324 tmpColor2="#EEEEBB" 325 End if 326 'alert(this.getElementByTagName('td').items(0).data); 327%> 328 <TR bgcolor="<%=tmpColor%>" onMouseOver="this.style.backgroundColor='<%=tmpColor2%>';this.nextSibling.style.backgroundColor='<%=tmpColor2%>'" onMouseOut="this.style.backgroundColor='<%=tmpColor%>';this.nextSibling.style.backgroundColor='<%=tmpColor%>'"> 329 <TD rowspan=2 style="height:30px;" align=center><%=tmpCounter%><BR><INPUT TYPE="checkbox" NAME="id" value="<%=RS1("id")%>"></TD> 330 <TD rowspan=2 dir="LTR" align='center'><%=RS1("return_date")%> 331 </TD> 332 <TD rowspan=2 colspan=2><A target="_blank" HREF="../shopfloor/manageOrder.asp?radif=<%=RS1("radif_sefareshat")%>"><%=RS1("customer_name")%> - <%=RS1("company_name")%><BR><BR><font color="aaaaaa"><%=RS1("order_title")%></A></font> 333 334 </TD> 335 <TD dir="LTR" align='center'><%=RS1("radif_sefareshat")%></TD> 336 <TD dir="LTR" align='center'><%=RS1("size")%></TD> 337 <TD dir="LTR" align='center'><%=RS1("forms")%>*<%=RS1("Tirag")%></TD> 338 <TD dir="LTR" align='center'> <%=RS1("Zinc")%></TD> 339 <TD><% 340 is2roo = "" 341 342 if RS1("is2roo")="0" then 343 is2roo="�� ��" 344 elseif RS1("is2roo")="1" then 345 is2roo="���" 346 elseif RS1("is2roo")="2" then 347 is2roo="����" 348 elseif RS1("is2roo")="3" then 349 is2roo="�����" 350 end if 351 response.write is2roo 352 353 %> </TD> 354 <TD><% 355 colorStatus = "" 356 357 if RS1("colorStatus")="0" then 358 colorStatus="���������" 359 elseif RS1("colorStatus")="1" then 360 colorStatus="�����" 361 elseif RS1("colorStatus")="2" then 362 colorStatus="�����" 363 end if 364 response.write colorStatus 365 366 %> </TD> 367 <TD rowspan=2 > 368 <% 369 mySQL="SELECT PurchaseOrders.ID, PurchaseRequests.TypeName, PurchaseOrders.Status FROM PurchaseRequests INNER JOIN PurchaseRequestOrderRelations ON PurchaseRequests.ID = PurchaseRequestOrderRelations.Req_ID INNER JOIN PurchaseOrders ON PurchaseRequestOrderRelations.Ord_ID = PurchaseOrders.ID WHERE PurchaseRequests.Order_ID = " & RS1("radif_sefareshat") 370 Set RS2 = conn.execute(mySQL) 371 Do while not RS2.eof 372 if RS2("status")="OK" then 373 response.write "<IMG SRC='../images/yes.gif' BORDER=0> " 374 elseif RS2("status")="CANCEL" then 375 response.write "<IMG SRC='../images/no.gif' BORDER=0> " 376 else 377 response.write "<IMG SRC='../images/hum.gif' BORDER=0> " 378 end if 379 response.write "<A TARGET='_blank' HREF='../purchase/outServiceTrace.asp?od=" & RS2("ID") & "'>" & RS2("TypeName") & "</A><BR>" 380 RS2.moveNext 381 Loop 382 RS2.close 383 set RS2=nothing 384 %><BR> 385 <% 386 mySQL="SELECT ItemName FROM InventoryItemRequests where Status <> 'del' and Order_ID=" & RS1("radif_sefareshat") 387 Set RS3 = conn.execute(mySQL) 388 Do while not RS3.eof 389 response.write "<li>" & RS3("ItemName") & "<BR>" 390 RS3.moveNext 391 Loop 392 RS3.close 393 set RS3=nothing 394 %> 395 </TD> 396 </TR> 397 <TR bgcolor="<%=tmpColor%>" onMouseOver="this.style.backgroundColor='<%=tmpColor2%>';this.previousSibling.style.backgroundColor='<%=tmpColor2%>'" onMouseOut="this.style.backgroundColor='<%=tmpColor%>';this.previousSibling.style.backgroundColor='<%=tmpColor%>'"> 398 <TD colspan=6 align=center><%=RS1("marhale")%> 399 </TD> 400 </TR> 401<% RS1.moveNext 402 Loop 403 end if 404 %> 405 <tr> 406 <td colspan="12" class="CusTableHeader" style="text-align:left;"> 407 <INPUT TYPE="submit" name="submit" value="������ ����� ������"> 408 <INPUT TYPE="submit" name="submit" value="�ǁ ������ ������"> <INPUT TYPE="submit" name="submit" value="������"></td> 409 </tr> 410</table><BR><BR><BR><BR> 411</FORM> 412<SCRIPT LANGUAGE="JavaScript"> 413<!-- 414function go2Page(p,ord) { 415 if(ord==0){ 416 ord=<%=Ord%>; 417 } 418 else if(ord==<%=Ord%>){ 419 ord= 0-ord; 420 } 421 str='?Ord='+escape(ord)+'&p='+escape(p) 422 window.location=str; 423} 424//--> 425</SCRIPT> 426 427<SCRIPT LANGUAGE="JavaScript"> 428function documentKeyDown() { 429 var theKey = window.event.keyCode; 430 var obj = window.event.srcElement; 431 if (theKey == 114) { 432 if (obj.name=="SearchBox"){document.all.SearchBox.value="";}; 433 window.event.keyCode=0; 434 document.all.SearchBox.focus(); 435 return false; 436 } 437} 438 439document.onkeydown = documentKeyDown; 440 441var lastFund = 0; 442var lastSrch = ""; 443function handleSearch(){ 444 var theKey=event.keyCode; 445 if (theKey==13){ 446 event.keyCode=0; 447 srch=document.all.SearchBox.value; 448 if (srch == '') { 449 return; 450 } 451 if (srch!=lastSrch){ 452 lastFund = 0; 453 lastSrch=srch; 454 } 455 var found = false; 456 var text = document.body.createTextRange(); 457 found=text.findText(srch) 458 for (var i=0; i<=lastFund && found ; i++) { 459 found=text.findText(srch) 460 text.moveStart("character", 1); 461 text.moveEnd("textedit"); 462 } 463 if (found) { 464 text.moveStart("character", -1); 465 text.findText(srch); 466 text.select(); 467 lastFund++; 468 theRow=text.parentElement(); 469 while(theRow.nodeName!='TR'){ 470 theRow=theRow.parentNode; 471 } 472 theRow.scrollIntoView(); 473 474 } 475 else{ 476 if (lastFund == '0'){ 477 alert('����� "' + srch +'" �� ��� ���� ���� ���.'); 478 } 479 else{ 480 alert('��� ��� ����� ����� "' + srch +'" ���� ���.'); 481 } 482 lastFund=0; 483 lastSrch=""; 484 } 485 } 486} 487</script> 488 489 490<% 491'----------------------------------------------------------------------------------------------------- 492'------------------------------------------------------------------------------- Show Order Desk Table 493'----------------------------------------------------------------------------------------------------- 494%> 495<A name="openOrders"></A> 496<TaBlE class="CustTable4" cellspacing="2" cellspacing="2"> 497<Tr> 498<Td colspan="2" valign="top" align="center"> 499 <table class="CustTable" cellspacing='1' style='width:95%;'> 500 <tr> 501 <td colspan="12" class="CusTableHeader" style="text-align:right;">����� ������ ��� ����</td> 502 </tr> 503<% 504 mySQL="SELECT *, orders_trace.radif_sefareshat FROM orders_trace INNER JOIN Orders ON orders_trace.radif_sefareshat = Orders.ID LEFT OUTER JOIN orderDesk ON Orders.ID = orderDesk.order_ID WHERE (orders_trace.Type = 2) AND (orders_trace.status = 1) AND (orders_trace.step NOT IN (11, 13, 10)) AND (Orders.Closed = 0) AND (orderDesk.id IS NULL) ORDER BY orders_trace.radif_sefareshat" 505 Set RS1 = conn.execute(mySQL) 506 if RS1.eof then 507%> 508 <tr> 509 <td colspan="12" class="CusTD3">���</td> 510 </tr> 511<% 512 else 513%> 514 <tr> 515 <td class="CusTD3"><small>����� �����</small></td> 516 <td class="CusTD3"><small>����� ����� \<font color="aaaaaa"> ����� ���</small></font></td> 517 <td class="CusTD3"><small> �����</small></td> 518 <td class="CusTD3"><small>����</small></td> 519 <td class="CusTD3"><small>����� ���</small></td> 520 <td class="CusTD3"><small>���ǎ �� ���</small></td> 521 <td class="CusTD3"><small>����</small></td> 522 <td class="CusTD3"><small>��</small></td> 523 <td class="CusTD3"><small>���</small></td> 524 <td class="CusTD3"><small> </small></td> 525 </tr> 526<% tmpCounter=0 527 Do while not RS1.eof 528 529 tmpCounter = tmpCounter + 1 530 if tmpCounter mod 2 = 1 then 531 tmpColor="#FFFFFF" 532 tmpColor2="#FFFFBB" 533 Else 534 tmpColor="#DDDDDD" 535 tmpColor2="#EEEEBB" 536 End if 537 'alert(this.getElementByTagName('td').items(0).data); 538%> <FORM METHOD=POST ACTION="" onsubmit="document.getElementById('addForm').disabled=true;"> 539 <TR bgcolor="<%=tmpColor%>" onMouseOver="this.style.backgroundColor='<%=tmpColor2%>'" onMouseOut="this.style.backgroundColor='<%=tmpColor%>'"> 540 <TD dir="LTR" align='right'><%=RS1("return_date")%></TD> 541 <TD><A HREF="../shopfloor/manageOrder.asp?radif=<%=RS1("radif_sefareshat")%>" target="_blank"><%=RS1("customer_name")%> - <%=RS1("company_name")%><BR><BR><font color="aaaaaa"><%=RS1("order_title")%></font></A></TD> 542 <TD dir="LTR" align='center'><INPUT TYPE="hidden" NAME="radif_sefareshat" value="<%=RS1("radif_sefareshat")%>" size=3><%=RS1("radif_sefareshat")%></TD> 543 <TD dir="LTR" align='center'><SMALL>����</SMALL><BR><INPUT TYPE="text" NAME="size" size=5></TD> 544 <TD dir="LTR" align='center'><SMALL>���</SMALL><BR><INPUT TYPE="text" NAME="forms" size=3></TD> 545 <TD dir="LTR" align='center'><SMALL>���ǎ</SMALL><BR><INPUT TYPE="text" NAME="tirag" size=3></TD> 546 <TD dir="LTR" align='center'><SMALL>����</SMALL><BR><INPUT TYPE="text" NAME="zinc" size=3></TD> 547 <TD dir="RTL" align='center'><BR> 548 <SELECT NAME="is2roo" style="font-family:tahoma; font-size:8pt"> 549 <option value="0">�� ��</option> 550 <option value="1">���</option> 551 <option value="2">����</option> 552 <option value="3">�����</option> 553 </SELECT> 554 </TD> 555 <TD dir="RTL" align='center'><BR> 556 <SELECT NAME="colorStatus" style="font-family:tahoma; font-size:8pt"> 557 <option value="0">���������</option> 558 <option value="1">�����</option> 559 <option value="2">�����</option> 560 </SELECT> 561 </TD> 562 <TD dir="LTR" align='center'> 563 564 <!INPUT TYPE="image" src="../images/add.gif" NAME="submit" value="add" size=3> 565 <input type="submit" id="addForm" NAME="submit" value="������"> 566 </TD> 567 </TR></FORM> 568<% RS1.moveNext 569 Loop 570 end if 571 %> 572 </table> 573 574 575<!--#include file="tah.asp" -->