PageRenderTime 24ms CodeModel.GetById 12ms app.highlight 7ms RepoModel.GetById 1ms app.codeStats 0ms

/beta/shopfloor/orderDesk.asp

http://github.com/khaneh/Orders
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				%>&nbsp;</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				%>&nbsp;</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				&nbsp;</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> &nbsp; </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" -->