/beta/order/Inquiry.asp

http://github.com/khaneh/Orders · ASP · 2088 lines · 1850 code · 144 blank · 94 comment · 208 complexity · c083b6c85a1802c3070a0020ba546cc2 MD5 · raw file

Large files are truncated click here to view the full file

    

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1256"%><%
    2. 

  2. 'Order (2)
    3. 

  3. PageTitle=""
    4. 

  4. SubmenuItem=9
    5. 

  5. if not Auth(2 , 9) then NotAllowdToViewThisPage() ' 
    6. 

  6. %>
    7. 

  7. <!--#include file="top.asp" -->
    8. 

  8. <!--#include File="../include_farsiDateHandling.asp"-->
    9. 

  9. <!--#include File="../include_UtilFunctions.asp"-->
    10. 

  10. <!--#include File="../include_JS_InputMasks.asp"-->
    11. 

  11. <%
    12. 

  12. 'Server.ScriptTimeout = 3600
    13. 

  13. %>
    14. 

  14. <STYLE>
    15. 

  15. 	.CustTable {font-family:tahoma; width:80%; border:1 solid black; direction: RTL; background-color:black;}
    16. 

  16. 	.CustTable td {padding:5;}
    17. 

  17. 	.CustTable a {text-decoration:none;color:#000088}
    18. 

  18. 	.CustTable a:hover {text-decoration:underline;}
    19. 

  19. 	.CusTableHeader {background-color: #33AACC; text-align: center; font-weight:bold;}
    20. 

  20. 	.CusTD1 {background-color: #CCCC66; text-align: left; font-weight:bold;}
    21. 

  21. 	.CusTD2 {background-color: #DDDDDD; direction: LTR; text-align: right; font-size:9pt;}
    22. 

  22. 	.CusTD3 {background-color: #DDDDDD; direction: LTR; text-align: center; font-size:9pt;}
    23. 

  23. 	.CusTD4 {background-color: #CCCC66; direction: LTR; text-align: center; font-size:9pt;}
    24. 

  24. </STYLE>
    25. 

  25. 

  26. <%
    27. 

  27. '-----------------------------
    28. 

  28. ' Trace Quote
    29. 

  29. '-----------------------------
    30. 

  30. if Request.QueryString("act")="" then
    31. 

  31. %>
    32. 

  32. <SCRIPT LANGUAGE='JavaScript'>
    33. 

  33. <!--
    34. 

  34. function checkValidation(){
    35. 

  35. 	if (document.all.search_box.value != ''){
    36. 

  36. 		return true;
    37. 

  37. 	}
    38. 

  38. 	else{
    39. 

  39. 		document.all.search_box.focus();
    40. 

  40. 		return false;
    41. 

  41. 	}
    42. 

  42. }
    43. 

  43. //-->
    44. 

  44. </SCRIPT>
    45. 

  45. 	<hr>
    46. 

  46. 	<TABLE border="4" cellspacing="0" cellpadding="0" width="600" align="center" bordercolor="#555599">
    47. 

  47. 	<TR><TD>
    48. 

  48. 		<TABLE border="0" cellspacing="0" cellpadding="5" dir="RTL" width="100%">
    49. 

  49. 	<!-- Trace Quote -->
    50. 

  50. 		<FORM METHOD=POST ACTION="?act=search" onSubmit="return checkValidation();">
    51. 

  51. 		<TR bgcolor="#AAAAEE"><TD colspan="4">
    52. 

  52. 			<FONT SIZE="" COLOR="#555599" ><B> :</B></FONT>
    53. 

  53. 		</TD></TR>
    54. 

  54. 		<TR bgcolor="#AAAAEE">
    55. 

  55. 			<TD>      :</TD>
    56. 

  56. 			<TD><INPUT TYPE="text" NAME="search_box" value="<%=request.form("search_box")%>"></TD>
    57. 

  57. 			<TD><INPUT TYPE="submit" NAME="SubmitB" Value="" style="font-family:tahoma,arial; font-size:10pt;width:100px;"></TD>
    58. 

  58. 			<TD align="left"><% if Auth(2 , 5) then %><A HREF="?act=advancedSearch"> </A><% End If %></TD>
    59. 

  59. 		</TR>
    60. 

  60. 		</FORM>
    61. 

  61. 		</TABLE>
    62. 

  62. 	</TD></TR>
    63. 

  63. 	<TR><TD>
    64. 

  64. 		<TABLE border="0" cellspacing="0" cellpadding="5" dir="RTL" width="100%">
    65. 

  65. 	<!-- Input Quote -->
    66. 

  66. 		<FORM METHOD=POST ACTION="?act=quoteInpCustSearch" onsubmit="if (document.all.CustomerNameSearchBox.value=='') return false;">
    67. 

  67. 			<TR bgcolor="#AAAAEE">
    68. 

  68. 				<TD>
    69. 

  69. 					<FONT SIZE="" COLOR="#555599" ><B>  :</B></FONT>
    70. 

  70. 				</TD>
    71. 

  71. 			</TR>
    72. 

  72. 			<TR bgcolor="#AAAAEE">
    73. 

  73. 				<TD>  :     &nbsp;
    74. 

  74. 					<INPUT TYPE="text" NAME="CustomerNameSearchBox">&nbsp;
    75. 

  75. 					<INPUT TYPE="submit" value=""><br>
    76. 

  76. 

  77. 			<SCRIPT LANGUAGE="JavaScript">
    78. 

  78. 				document.all.CustomerNameSearchBox.focus();
    79. 

  79. 			</SCRIPT>
    80. 

  80. 				</TD>
    81. 

  81. 			</TR>
    82. 

  82. 		</FORM>
    83. 

  83. 		</TABLE>
    84. 

  84. 	</TD></TR>
    85. 

  85. 	</TABLE>
    86. 

  86. 	<script language="JavaScript">
    87. 

  87. 		document.all.search_box.focus();
    88. 

  88. 	</script>
    89. 

  89. 	<hr>
    90. 

  90. <%
    91. 

  91. 	'
    92. 

  92. elseif Request.QueryString("act")="search" then
    93. 

  93. %>
    94. 

  94. 	<hr>
    95. 

  95. 	<TABLE border="4" cellspacing="0" cellpadding="0" width="600" align="center" bordercolor="#555599">
    96. 

  96. 	<FORM METHOD=POST ACTION="?act=search" onSubmit="return checkValidation();">
    97. 

  97. 	<TR><TD>
    98. 

  98. 		<TABLE border="0" cellspacing="0" cellpadding="5" dir="RTL" width="100%">
    99. 

  99. 		<TR bgcolor="#AAAAEE">
    100. 

  100. 			<TD>      :</TD>
    101. 

  101. 			<TD><INPUT TYPE="text" NAME="search_box" value="<%=request.form("search_box")%>"></TD>
    102. 

  102. 			<TD><INPUT TYPE="submit" NAME="SubmitB" Value="" style="font-family:tahoma,arial; font-size:10pt;width:100px;"></TD>
    103. 

  103. 			<TD align="left"><A HREF="?act=advancedSearch"> </A></TD>
    104. 

  104. 		</TR>
    105. 

  105. 		</TABLE>
    106. 

  106. 	</TD></TR>
    107. 

  107. 	</FORM>
    108. 

  108. 	</TABLE> 
    109. 

  109. 	<script language="JavaScript">
    110. 

  110. 	<!--
    111. 

  111. 		document.all.search_box.focus();
    112. 

  112. 	//-->
    113. 

  113. 	</script>
    114. 

  114. 	<hr>
    115. 

  115. <%
    116. 

  116. 	
    117. 

  117. 	search=request("search_box")
    118. 

  118. 	if search="" then
    119. 

  119. 		'By Default show Open Quotes of Current User
    120. 

  120. 		myCriteria= "Quotes.CreatedBy = " & session("ID")
    121. 

  121. 	elseif isNumeric(search) then
    122. 

  122. 		search=clng(search)
    123. 

  123. 		myCriteria= "Quotes.ID = '"& search & "'"
    124. 

  124. 	else
    125. 

  125. 		search=sqlSafe(search)
    126. 

  126. 		myCriteria= "REPLACE([company_name], ' ', '') LIKE REPLACE(N'%"& search & "%', ' ', '') OR REPLACE([customer_name], ' ', '') LIKE REPLACE(N'%"& search & "%', ' ', '')"
    127. 

  127. 	End If
    128. 

  128. 

  129. 	mySQL=	"SELECT Quotes.*, OrderTraceStatus.Name AS StatusName, OrderTraceStatus.Icon , Invoices.ID AS InvoiceID, Invoices.Approved, Invoices.Voided, Invoices.Issued "&_ 
    130. 

  130. 			" FROM Quotes INNER JOIN "&_ 
    131. 

  131. 			" OrderTraceStatus ON OrderTraceStatus.ID = Quotes.status LEFT OUTER JOIN "&_ 
    132. 

  132. 			" Invoices INNER JOIN "&_ 
    133. 

  133. 			" InvoiceQuoteRelations ON Invoices.ID = InvoiceQuoteRelations.Invoice ON Quotes.ID = InvoiceQuoteRelations.Quote "&_ 
    134. 

  134. 			" WHERE ("& myCriteria & ")  "&_ 
    135. 

  135. 			" ORDER BY Quotes.order_date DESC, Quotes.ID DESC "
    136. 

  136. 

  137. 	set RS1=Conn.Execute (mySQL)
    138. 

  138. 	if not RS1.eof then
    139. 

  139. 		tmpCounter=0
    140. 

  140. %>
    141. 

  141. 	<div align="center" dir="LTR" >
    142. 

  142. 	<table border="1" cellspacing="0" cellpadding="2" dir="RTL"  borderColor="#555588" >
    143. 

  143. 		<TR valign=top bgcolor="#CCCCFF">
    144. 

  144. 			<TD width="41"># </TD>
    145. 

  145. 			<TD width="65"> <br> </TD>
    146. 

  146. 			<TD width="130">  - </TD>
    147. 

  147. 			<TD width="110"> </TD>
    148. 

  148. 			<TD width="36"></TD>
    149. 

  149. 			<TD width="76"></TD>
    150. 

  150. 			<TD width="56"> </TD>
    151. 

  151. 			<TD width="40"></TD>
    152. 

  152. 		</TR>
    153. 

  153. <%		Do while not RS1.eof
    154. 

  154. 

  155. 		if isnull(RS1("InvoiceID")) then
    156. 

  156. 			InvoiceStatus="<span style='color:red;'><b></b></span>"
    157. 

  157. 		else
    158. 

  158. 			if RS1("Voided") then
    159. 

  159. 				style="style='color:Red' Title=' '"
    160. 

  160. 			elseif RS1("Issued") then
    161. 

  161. 				style="style='color:Red' Title=' '"
    162. 

  162. 			elseif RS1("Approved") then
    163. 

  163. 				style="style='color:Green' Title=' '"
    164. 

  164. 			else
    165. 

  165. 				style="style='color:#3399FF' Title=' '"
    166. 

  166. 			end if
    167. 

  167. 			InvoiceStatus="<A " & style & " HREF='../AR/AccountReport.asp?act=showInvoice&invoice=" & RS1("InvoiceID")& "' Target='_blank'>" & RS1("InvoiceID") & "</A>"
    168. 

  168. 		end if
    169. 

  169. 			
    170. 

  170. 		tmpCounter = tmpCounter + 1
    171. 

  171. 		if tmpCounter mod 2 = 1 then
    172. 

  172. 			tmpColor="#FFFFFF"
    173. 

  173. 		Else
    174. 

  174. 			tmpColor="#EEEEEE"
    175. 

  175. 		End If 
    176. 

  176. %>
    177. 

  177. 		<TR valign=top bgcolor="<%=tmpColor%>">
    178. 

  178. 			<TD width="40" DIR="LTR"><A HREF="?act=show&quote=<%=RS1("ID")%>" target="_blank"><%=RS1("ID")%></A></TD>
    179. 

  179. 			<TD width="65" DIR="LTR"><%=RS1("order_date")%><br><%=RS1("return_date") & " ("& RS1("return_time") & ")"%></TD>
    180. 

  180. 			<TD width="130"><%=RS1("company_name")%><br><span style='color:gray'><%=RS1("customer_name")%></span><br>:(<%=RS1("telephone")%>)&nbsp;</TD>
    181. 

  181. 			<TD width="80"><%=RS1("order_title")%>&nbsp;</TD>
    182. 

  182. 			<TD width="40"><%=RS1("order_kind")%></TD>
    183. 

  183. 			<TD width="85"><%=RS1("marhale")%></TD>
    184. 

  184. 			<TD width="50"><%=RS1("salesperson")%>&nbsp;</TD>
    185. 

  185. 			<TD width="30"><%=InvoiceStatus%>&nbsp;</TD>
    186. 

  186. 		</TR>
    187. 

  187. 		<TR bgcolor="#FFFFFF">
    188. 

  188. 			<TD colspan="10" style="height:10px"></TD>
    189. 

  189. 		</TR>
    190. 

  190. <%			RS1.moveNext
    191. 

  191. 		Loop
    192. 

  192. %>		<TR bgcolor="#ccccFF">
    193. 

  193. 			<TD colspan="10">  : <%=tmpCounter%></TD>
    194. 

  194. 		</TR>
    195. 

  195. 	</TABLE>
    196. 

  196. 	</div>
    197. 

  197. 	<HR>
    198. 

  198. <%	
    199. 

  199. 	elseif request("search_box")<>"" Then
    200. 

  200. 	
    201. 

  201. %>	<TABLE border="1" cellspacing="0" cellpadding="0" dir="RTL" align="center" width="600">
    202. 

  202. 		<TR bgcolor="#FFFFDD">
    203. 

  203. 			<TD align="center" style="height:40px;font-size:12pt;font-weight:bold;color:red;padding:5px;">    <br>
    204. 

  204. 			(           )<br><br>
    205. 

  205. 			   <A HREF="?act=show&quote=<%=request("search_box")%>" style="color:blue;">  </A>  .</TD>
    206. 

  206. 		</TR>
    207. 

  207. 	</TABLE>
    208. 

  208. <%	
    209. 

  209. 	End If
    210. 

  210. '----------------------------------------------------------------------------------------------------------
    211. 

  211. elseif Request.QueryString("act")="approve" then 
    212. 

  212. 	 if isnumeric(request("quote")) then
    213. 

  213. 		quote=request("quote")
    214. 

  214. 		set rs = Conn.Execute("select * form Quotes where id=" & quote)
    215. 

  215. 		If RS1.EOF then
    216. 

  216. 			response.write "<BR><BR><BR><BR><CENTER>   </CENTER>"
    217. 

  217. 			response.end
    218. 

  218. 		End If
    219. 

  219. 		msg=""
    220. 

  220. 		if IsNull(rs("qtty")) then msg="ǎ   <br>"
    221. 

  221. 		if IsNull(rs("paperZise") or rs("paperZise")="") then msg=msg &"   <br>"
    222. 

  222. 		if IsNull(rs("property") or rs("property")="") then msg=msg & "   <br>"
    223. 

  223. 		set typeProp = server.createobject("MSXML2.DomDocument")
    224. 

  224. 		set orderProp = server.createobject("MSXML2.DomDocument")
    225. 

  225. 		orderProp.loadXML(rs("property"))
    226. 

  226. 		orderType= rs("type")
    227. 

  227. 		set rs=Conn.Execute("select * from OrderTraceTypes where id="&orderType)
    228. 

  228. 		typeProp.loadXML(rs("property"))
    229. 

  229. 		set rs=nothing
    230. 

  230. 		oldTmp="---first---"
    231. 

  231. 		for each tmp in orderProp.selectNodes("//key")
    232. 

  232. 			if oldTmp <> tmp.parentNode.nodeName then 
    233. 

  233. 				oldTmp = tmp.parentNode.nodeName
    234. 

  234. 				key = "/keys/" & oldTmp & "/key"
    235. 

  235. 				oldGroup="---first---"
    236. 

  236. 				oldLabel="---first---"
    237. 

  237. 				maxID=-1
    238. 

  238. 				oldID=-1
    239. 

  239. 				rowEmpty=false
    240. 

  240. 				for each mykey in orderProp.SelectNodes(key)
    241. 

  241. 					id=myKey.GetAttribute("id")
    242. 

  242. 					if maxID<id then maxID=id
    243. 

  243. 				next
    244. 

  244. 				for id = 0 to maxID
    245. 

  245. 					For Each myKey In orderProp.SelectNodes(key & "[@id='" & id & "']")
    246. 

  246. 						thisName = myKey.GetAttribute("name")
    247. 

  247. 						set typeKey = typeProp.selectNodes(key & "[@name='" & thisName & "']")(0)
    248. 

  248. 						thisType = typeKey.GetAttribute("type") 
    249. 

  249. 						thisLabel= typeKey.GetAttribute("label")
    250. 

  250. 						thisGroup= typeKey.GetAttribute("group")
    251. 

  251. 						thisItem = typeKey.GetAttribute("item")
    252. 

  252. 						if thisName="description" then thisDesc = myKey.text
    253. 

  253. 						
    254. 

  254. 						isRow =false
    255. 

  255. 						if thisName<>"" then
    256. 

  256. 							isRow=true
    257. 

  257. 							'if ((oldGroup<>thisGroup or oldID<>id) and oldGroup <> "---first---") then
    258. 

  258. 							if oldGroup<>thisGroup or oldID<>id then 
    259. 

  259. 								'if typeKey.GetAttribute("grouplabel")<>"" 
    260. 

  260. 								a=2
    261. 

  261. 							end if
    262. 

  262. 							'if oldLabel<>thisLabel and thisType<>"radio" then
    263. 

  263. 							
    264. 

  264. 						end if
    265. 

  265. 						'desc= 
    266. 

  266. 						
    267. 

  267. 						oldGroup=thisGroup
    268. 

  268. 						oldLabel=thisLabel
    269. 

  269. 						oldID=id
    270. 

  270. 					next
    271. 

  271. 				next
    272. 

  272. 			end if
    273. 

  273. 		next
    274. 

  274. 		'Conn.Execute("update Quotes set qApproved=1 where id=" & quote)
    275. 

  275. 	end if
    276. 

  276. 	'response.redirect "?act=show&quote=" & quote
    277. 

  277. elseif Request.QueryString("act")="show" then
    278. 

  278.   if isnumeric(request("quote")) then
    279. 

  279. 	quote=request("quote")
    280. 

  280. 	'mySQL="SELECT Accounts.ID AS AccID, Accounts.AccountTitle, Quotes.* FROM Accounts INNER JOIN Quotes ON Accounts.ID = Quotes.Customer WHERE (Quotes.ID='"& quote & "')"
    281. 

    282. 

  282. 	mySQL=	"SELECT Quotes.*, Accounts.ID AS AccID, Accounts.AccountTitle, "&_ 
    283. 

  283. 			"Invoices.ID AS InvoiceID, Invoices.Approved, Invoices.Voided, Invoices.Issued "&_ 
    284. 

  284. 			"FROM Quotes INNER JOIN "&_ 
    285. 

  285. 			"Accounts ON Accounts.ID = Quotes.Customer LEFT OUTER JOIN "&_ 
    286. 

  286. 			"InvoiceQuoteRelations INNER JOIN "&_ 
    287. 

  287. 			"Invoices ON InvoiceQuoteRelations.Invoice = Invoices.ID ON InvoiceQuoteRelations.Quote = Quotes.ID "&_ 
    288. 

  288. 			"WHERE (Quotes.ID='"& quote & "')"
    289. 

  289. 'response.write mySQL
    290. 

  290. 	set RS1=conn.execute (mySQL)
    291. 

  291. 	If RS1.EOF then
    292. 

  292. 		response.write "<BR><BR><BR><BR><CENTER>   </CENTER>"
    293. 

  293. 		response.end
    294. 

  294. 	End If
    295. 

  295. 

  296. 	If RS1("Step")=4 then
    297. 

  297. 		stamp="<div style='border:2 dashed red;width:150px; text-align:center; padding: 10px;color:red;font-size:15pt;font-weight:bold;'> </div>"
    298. 

  298. 	End If
    299. 

  299. 

  300. %>
    301. 

  301. 	<table border="0" cellpadding="0" cellspacing="0" align="center">
    302. 

  302. 		<tr height="10">
    303. 

  303. 			<td colspan=2></td>
    304. 

  304. 		</tr>
    305. 

  305. 		<tr height="10">
    306. 

  306. 			<td width="150"></td>
    307. 

  307. 			<td valign="top"><div style='position:absolute;'><%=stamp%></div></td>
    308. 

  308. 		</tr>
    309. 

  309. 		<tr height="20">
    310. 

  310. 			<td colspan=2></td>
    311. 

  311. 		</tr>
    312. 

  312. 	</table>
    313. 

  313. 

  314. 	<CENTER>
    315. 

  315. 	<%if not CBool(rs1("qApproved")) then%> 
    316. 

  316. 		<input type="button" value="" Class="GenButton" onclick="window.location='?act=editQuote&quote=<%=quote%>';">&nbsp;
    317. 

  317. 		<input title="  ϡ ԝ      ." type="button" value="" Class="GenButton" onclick="window.location='?act=approve&quote=<%=quote%>';">&nbsp;
    318. 

  318. 	<%else%>
    319. 

  319. 		<% If RS1("Step")<>5 Then %>
    320. 

  320. 			<input type="button" value="  " Class="GenButton" onclick="window.location='?act=convertToOrder&quote=<%=quote%>';">
    321. 

  321. 		<% Else %>
    322. 

  322. 			<font color="red">&nbsp; (<b>   </b>)</font>
    323. 

  323. 		<% End If %>
    324. 

  324. 	<%end if%>
    325. 

  325. 	<input type="button" value="߁ " Class="GenButton" onclick="window.location='?act=copy&quote=<%=quote%>';">
    326. 

  326. 		<%' 	ReportLogRow = PrepareReport ("OrderForm.rpt", "Order_ID", quote, "/beta/dialog_printManager.asp?act=Fin") %>
    327. 

  327. 		<!--INPUT TYPE="button" value=" ǁ " Class="GenButton" style="border:1 solid blue;" onclick="printThisReport(this,<% 'ReportLogRow%>);"-->
    328. 

  328. 	<% If isnull(RS1("InvoiceID")) Then %>
    329. 

  329. 		<input type="button" value="  " Class="GenButton" onclick="window.location='../AR/InvoiceInput.asp?act=getInvoice&selectedCustomer=<%=RS1("AccID")%>&selectedQuotes=<%=quote%>';">
    330. 

  330. 	<% Else %>
    331. 

  331. 		<input type="button" value="   (<%=RS1("InvoiceID")%>)" Class="GenButton" style="color:#3399FF;" onclick="window.location='../AR/AccountReport.asp?act=showInvoice&invoice=<%=RS1("InvoiceID")%>';">
    332. 

  332. 	<% End If %>
    333. 

  333. 

  334. 	
    335. 

  335. 	</CENTER>
    336. 

  336. 	
    337. 

  337. 	<BR>
    338. 

  338. 	<TABLE class="" cellspacing="0" cellpadding="2" align="center" style="background-color:#CCCCCC; color:black; direction:RTL; width:700; border: 2 solid #555599;">
    339. 

  339. 		<TR bgcolor="#555599">
    340. 

  340. 			<TD align="left"><FONT COLOR="YELLOW">:</FONT></TD>
    341. 

  341. 			<TD align="right" colspan=5 height="25px">
    342. 

  342. 				<span id="customer" style="color:yellow;"><%' after any changes in this span "./Customers.asp" must be revised%>
    343. 

  343. 					<span><%=RS1("AccID") & " - "& RS1("AccountTitle")%></span>.
    344. 

  344. 				</span>
    345. 

  345. 			</TD>
    346. 

  346. 		</TR>
    347. 

  347. 		
    348. 

  348. 		<TR bgcolor="#555599" height=30 style="color:yellow;">
    349. 

  349. 			<TD align="left"> :</TD>
    350. 

  350. 			<TD align="right"><%=RS1("ID")%></TD>
    351. 

  351. 			<TD align="left">:</TD>
    352. 

  352. 			<TD><span dir="LTR"><%=RS1("order_date")%></span></TD>
    353. 

  353. 			<TD align="left">:</TD>
    354. 

  354. 			<TD align="right"><%=RS1("order_time")%></TD>
    355. 

  355. 		</TR>
    356. 

  356. 		<TR height=30>
    357. 

  357. 			<TD align="left"> :</TD>
    358. 

  358. 			<TD><%=RS1("company_name")%></TD>
    359. 

  359. 			<TD align="left"> :</TD>
    360. 

  360. 			<TD align="right" dir=LTR><%=RS1("return_date")%></TD>
    361. 

  361. 			<TD align="left"> :</TD>
    362. 

  362. 			<TD align="right" dir=LTR><%=RS1("return_time")%></TD>
    363. 

  363. 		</TR>
    364. 

  364. 		<TR height=30>
    365. 

  365. 			<TD align="left"> :</TD>
    366. 

  366. 			<TD><%=RS1("customer_name")%></TD>
    367. 

  367. 			<TD align="left"> :</TD>
    368. 

  368. 			<TD><%=RS1("order_kind")%></TD>
    369. 

  369. 			<TD align="left"> :</TD>
    370. 

  370. 			<TD><%=RS1("salesperson")%>	</TD>
    371. 

  371. 		</TR>
    372. 

  372. 		<TR height=30>
    373. 

  373. 			<TD align="left">:</TD>
    374. 

  374. 			<TD><%=RS1("telephone")%></TD>
    375. 

  375. 			<TD align="left">   :</TD>
    376. 

  376. 			<TD colspan="3"><%=RS1("order_title")%></TD>
    377. 

  377. 		</TR>
    378. 

  378. 	
    379. 

  379. 		<TR height=30>
    380. 

  380. 			<td align="left">:</td>
    381. 

  381. 			<td><%=rs1("qtty")%></td>
    382. 

  382. 			<TD align="left">:</TD>
    383. 

  383. 			<TD><%=RS1("PaperSize")%></TD>
    384. 

  384. 			<TD align="left"> :</TD>
    385. 

  385. 			<TD>
    386. 

  386. 			<%if RS1("productionDuration") = 0 then 
    387. 

  387. 				response.write "<font color=red></font>" 
    388. 

  388. 			else
    389. 

  389. 				response.write RS1("productionDuration") & " "
    390. 

  390. 			end if %>
    391. 

  391. 			
    392. 

  392. 			</TD>
    393. 

  393. 		</TR>
    394. 

  394. 		<TR height=30>
    395. 

  395. 			<TD align="left">:</TD>
    396. 

  396. 			<TD colspan="3"><%=RS1("marhale")%></TD>
    397. 

  397. 			<TD align="left"> :</TD>
    398. 

  398. 			<TD><span class="price"><%=RS1("Price")%></span></TD>
    399. 

  399. 		</TR>
    400. 

  400. 		<TR height=30>
    401. 

  401. 			<TD align="left" valign="top" colspan="3"> :</TD>
    402. 

  402. 			<TD colspan="3">
    403. 

  403. 			<%if not IsNull(RS1("Notes")) then response.write replace(RS1("Notes"),chr(13),"<br>")%>
    404. 

  404. 			</TD>
    405. 

  405. 		</TR>
    406. 

  406. 	</TABLE>
    407. 

  407. <%
    408. 

  408. set rs = conn.Execute("select *,users.RealName from QuoteLogs inner join Users on QuoteLogs.LastUpdatedBy=users.ID where QuoteLogs.QuoteID=" & quote & " and QuoteLogs.ID in (select min(id) from QuoteLogs group by QuoteID,productionDuration)")
    409. 

  409. if not rs.eof then 
    410. 

  410. %>
    411. 

  411. 	<TABLE class="" cellspacing="0" cellpadding="2" align="center" style="background-color:#CCCCCC; color:black; direction:RTL; width:700; border: 2 solid #555599;">
    412. 

  412. 	<tr bgcolor="#555599" height=30 style="color:yellow;">
    413. 

  413. 		<td></td>
    414. 

  414. 		<td></td>
    415. 

  415. 		<td> </td>
    416. 

  416. 		<td></td>
    417. 

  417. 	</tr>
    418. 

  418. <%
    419. 

  419. 	while not rs.eof 
    420. 

  420. 		response.write "<tr><td>" & rs("LastUpdatedDate") & "</td><td>" & rs("LastUpdatedTime") & "</td><td>" 
    421. 

  421. 		if CInt(rs("productionDuration"))=0 then 
    422. 

  422. 			response.write "<font color=red></font>"
    423. 

  423. 		else
    424. 

  424. 			response.write  rs("productionDuration") & " "
    425. 

  425. 		end if
    426. 

  426. 		response.write  "</td><td>" & rs("RealName") & "</td></tr>"
    427. 

  427. 		rs.moveNext
    428. 

  428. 	wend
    429. 

  429. %>	
    430. 

  430. 	<tr>
    431. 

  431. 	
    432. 

  432. 	</tr>
    433. 

  433. 	</table>
    434. 

  434. <%
    435. 

  435. end if
    436. 

  436. %>
    437. 

  437. 	<BR>
    438. 

  438. 	<%
    439. 

  439. if (not (IsNull(rs1("property")) or rs1("property")="")) then
    440. 

  440. %>
    441. 

  441. 	<div> </div>
    442. 

  442. 

  443. <%
    444. 

  444. 	set rs=Conn.Execute("select * from OrderTraceTypes where id="&rs1("type"))
    445. 

  445. 	set typeProp = server.createobject("MSXML2.DomDocument")
    446. 

  446. 	set orderProp = server.createobject("MSXML2.DomDocument")
    447. 

  447. 	
    448. 

  448. 	orderProp.loadXML(rs1("property"))
    449. 

  449. 	typeProp.loadXML(rs("property"))
    450. 

  450. 	set rs=nothing
    451. 

  451. sub showKey(key)
    452. 

  452. 	oldGroup="---first---"
    453. 

  453. 	oldLabel="---first---"
    454. 

  454. 	maxID=-1
    455. 

  455. 	oldID=-1
    456. 

  456. 	rowEmpty=false
    457. 

  457. 	for each mykey in orderProp.SelectNodes(key)
    458. 

  458. 		id=myKey.GetAttribute("id")
    459. 

  459. 		if maxID<id then maxID=id
    460. 

  460. 	next
    461. 

  461. 	thisRow = "<div class='myRow'>"'<div class='exteraArea' id='" & Replace(key,"/","-") & "-0'>"
    462. 

  462. 	for id = 0 to maxID
    463. 

  463. 		For Each myKey In orderProp.SelectNodes(key & "[@id='" & id & "']")
    464. 

  464. 			thisName = myKey.GetAttribute("name")
    465. 

  465. 			set typeKey = typeProp.selectNodes(key & "[@name='" & thisName & "']")(0)
    466. 

  466. 			thisType = typeKey.GetAttribute("type") 
    467. 

  467. 			thisLabel= typeKey.GetAttribute("label")
    468. 

  468. 			thisGroup= typeKey.GetAttribute("group")
    469. 

  469. 			if thisType="radio" then 
    470. 

  470. 				radioID = CInt(myKey.text)
    471. 

  471. 				set typeKey = typeProp.selectNodes(key & "[@name='" & thisName & "']")(radioID - 1)
    472. 

  472. 				thisType = typeKey.GetAttribute("type") 
    473. 

  473. 				thisLabel= typeKey.GetAttribute("label")
    474. 

  474. 				thisGroup= typeKey.GetAttribute("group")
    475. 

  475. 			end if
    476. 

  476. 			isRow =false
    477. 

  477. 			if Replace(key,"/","-")="keys-service-key" then response.write "::--------::" & myKey.text
    478. 

  478. 			if thisName<>"" then 
    479. 

  479. 				isRow=true
    480. 

  480. 				if oldID<>id then thisRow = thisRow & "<div class='exteraArea' id='" & Replace(key,"/","-") & "-" & id & "'>"
    481. 

  481. 				if (oldGroup<>thisGroup and oldID=id and oldGroup <> "---first---") then thisRow = thisRow &  "</div>"
    482. 

  482. 				if oldGroup<>thisGroup or oldID<>id then 
    483. 

  483. 					thisRow = thisRow & "<div class='mySection'>"
    484. 

  484. 					if typeKey.GetAttribute("grouplabel")<>"" then thisRow = thisRow & "<b>" & typeKey.GetAttribute("grouplabel") & "</b>"
    485. 

  485. 				end if
    486. 

  486. 				if oldLabel<>thisLabel and thisType<>"radio" then thisRow = thisRow &  "<label class='myLabel'>" & thisLabel & ": </label>"
    487. 

  487. 				
    488. 

  488. 				if left(thisType,6)="option" then set myOptions=typeKey
    489. 

  489. 				myText=""
    490. 

  490. 				select case thisType
    491. 

  491. 					case "option"
    492. 

  492. 						for each optKey in myOptions.selectNodes("option")
    493. 

  493. 							if optKey.text=myKey.text then 
    494. 

  494. 								myText = optKey.GetAttribute("label")
    495. 

  495. 								exit for
    496. 

  496. 							end if
    497. 

  497. 						next
    498. 

  498. 					case "option-other"
    499. 

  499. 						if left(myKey.text,6)="other:" then 
    500. 

  500. 							myText = mid(myKey.text,7)
    501. 

  501. 						else
    502. 

  502. 							for each optKey in myOptions.selectNodes("option")
    503. 

  503. 								if optKey.text=myKey.text then 
    504. 

  504. 									myText = optKey.GetAttribute("label")
    505. 

  505. 									exit for
    506. 

  506. 								end if
    507. 

  507. 							next
    508. 

  508. 						end if
    509. 

  509. 						if myText="" then myText = myKey.text
    510. 

  510. 					case "check"
    511. 

  511. 						if left(myKey.text,2)="on" then myText = "<img src='/images/Checkmark-32.png' width='15px'>"
    512. 

  512. 					case "radio"
    513. 

  513. 						myText=thisLabel
    514. 

  514. 					case else
    515. 

  515. 						myText = myKey.text
    516. 

  516. 				end select
    517. 

  517. 				set myOptions=nothing
    518. 

  518. 				thisRow = thisRow & "<span class='myProp'>" & myText & "</span>"		
    519. 

  519. 			else
    520. 

  520. 				if id=0 then 
    521. 

  521. 					thisRow=""
    522. 

  522. 					rowEmpty=true
    523. 

  523. 				end if
    524. 

  524. 			end if
    525. 

  525. 			oldGroup=thisGroup
    526. 

  526. 			oldLabel=thisLabel
    527. 

  527. 			oldID=id
    528. 

  528. 			if typeKey.GetAttribute("br")="yes" then thisRow = thisRow & "<br><br>"
    529. 

  529. 		Next
    530. 

  530. 		if isRow then thisRow = thisRow & "</div></div>"
    531. 

  531. 	next
    532. 

  532. 	'response.write maxID
    533. 

  533. 	if not rowEmpty then thisRow = thisRow & "</div>" '"<div id='extreArea" &Replace(key,"/","-")& "'></div>"
    534. 

  534. 	response.write thisRow 'prependTo 
    535. 

  535. '	response.write 
    536. 

  536. end sub
    537. 

  537. 	oldTmp="---first---"
    538. 

  538. 	for each tmp in orderProp.selectNodes("//key")
    539. 

  539. 		if oldTmp<>tmp.parentNode.nodeName then 
    540. 

  540. 			oldTmp=tmp.parentNode.nodeName
    541. 

  541. 			call showKey("/keys/" & oldTmp & "/key")
    542. 

  542. 		end if
    543. 

  543. 	next
    544. 

  544. ' 	call showKey("/keys/printing/key")
    545. 

  545. ' 	call showKey("keys/binding/key")
    546. 

  546. ' 	call showKey("keys/service/key")
    547. 

  547. ' 	call showKey("keys/delivery/key")
    548. 

  548. 	
    549. 

  549. end if
    550. 

  550. %>
    551. 

  551. <br><br>
    552. 

  552. 	<table class="CustTable" cellspacing='1' align=center style="width:700; ">
    553. 

  553. 		<tr>
    554. 

  554. 			<td colspan="2" class="CusTableHeader"><span style="width:450;text-align:center;"> </span><span style="width:100;text-align:left;background-color:red;"><input class="GenButton" type="button" value=" " onclick="window.location = '../home/message.asp?RelatedTable=quotes&RelatedID=<%=quote%>&retURL=<%=Server.URLEncode("../order/Inquiry.asp?act=show&quote="&quote)%>';"></span></td>
    555. 

  555. 		</tr>
    556. 

  556. <%
    557. 

  557. 	mySQL="SELECT * FROM Messages INNER JOIN Users ON Messages.MsgFrom = Users.ID WHERE (Messages.RelatedTable = 'quotes') AND (Messages.RelatedID = "& quote & ") ORDER BY Messages.ID DESC"
    558. 

  558. 	Set RS = conn.execute(mySQL)
    559. 

  559. 	if NOT RS.eof then
    560. 

  560. 

  561. 		tmpCounter=0
    562. 

  562. 		Do While NOT RS.eof 
    563. 

  563. 			tmpCounter=tmpCounter+1
    564. 

  564. %>
    565. 

  565. 			<tr class="<%if (tmpCounter MOD 2) = 1 then response.write "CusTD3" else response.write "CusTD4" %>">
    566. 

  566. 				<td> <%=RS("RealName")%><br>
    567. 

  567. 					<%=RS("MsgDate")%> <BR> <%=RS("MsgTime")%>
    568. 

  568. 				</td>
    569. 

  569. 				<td dir='RTL'><%=replace(RS("MsgBody"),chr(13),"<br>")%></td>
    570. 

  570. 			</tr>
    571. 

  571. <%
    572. 

  572. 			RS.moveNext
    573. 

  573. 		Loop
    574. 

  574. 	else
    575. 

  575. %>
    576. 

  576. 		<tr class="CusTD3">
    577. 

  577. 			<td colspan="2"></td>
    578. 

  578. 		</tr>
    579. 

  579. <%
    580. 

  580. 	end if
    581. 

  581. 	RS.close
    582. 

  582. %>
    583. 

  583. 	</table><BR>
    584. 

  584. 

  585. <%
    586. 

  586.   end if
    587. 

  587. elseif Request.QueryString("act")="advancedSearch" then
    588. 

  588. '------  Advanced Search 
    589. 

  589. %>
    590. 

  590. <!--#include File="../include_JS_InputMasks.asp"-->
    591. 

  591. <%
    592. 

  592. 	'Server.ScriptTimeout = 3600
    593. 

  593. 	tmpTime=time
    594. 

  594. 	tmpTime=Hour(tmpTime)&":"&Minute(tmpTime)
    595. 

  595. 	if instr(tmpTime,":")<3 then tmpTime="0" & tmpTime
    596. 

  596. 	if len(tmpTime)<5 then tmpTime=Left(tmpTime,3) & "0" & Right(tmpTime,1)
    597. 

  597. 

  598. 	if request("resultsCount")="" OR not isnumeric(request("resultsCount")) then
    599. 

  599. 		resultsCount = 50
    600. 

  600. 	else
    601. 

  601. 		resultsCount = cint(request("resultsCount"))
    602. 

  602. 	end if
    603. 

  603. 

  604. %>
    605. 

  605. 	<hr>
    606. 

  606. 	<TABLE border="4" cellspacing="0" cellpadding="0" width="700" align="center" bordercolor="#555599">
    607. 

  607. 	<FORM METHOD=POST ACTION="?act=advancedSearch" onSubmit="return checkValidation();">
    608. 

  608. 	<TR><TD>
    609. 

  609. 		<TABLE border="0" cellspacing="0" cellpadding="1" dir="RTL" width="100%" bgcolor="white">
    610. 

  610. 		<TR bgcolor="#EEEEEE">
    611. 

  611. 			<TD><INPUT TYPE="checkbox" NAME="check_sefaresh" onclick="check_sefaresh_Click()" checked></TD>
    612. 

  612. 			<TD> </TD>
    613. 

  613. 			<TD><INPUT TYPE="text" NAME="az_sefaresh" dir="LTR" value="<%=request.form("az_sefaresh")%>" size="8" maxlength="6" onKeyPress="return maskNumber(this);"></TD>
    614. 

  614. 			<TD></TD>
    615. 

  615. 			<TD><INPUT TYPE="text" NAME="ta_sefaresh" dir="LTR" value="<%=request.form("ta_sefaresh")%>" size="8" maxlength="6" onKeyPress="return maskNumber(this);" ></TD>
    616. 

  616. 			<td rowspan="12" style="width:1px" bgcolor="#555599"></td>
    617. 

  617. 			<TD><INPUT TYPE="checkbox" NAME="check_kind" onclick="check_kind_Click()" checked></TD>
    618. 

  618. 			<TD> </TD>
    619. 

  619. 			<TD colspan="3"><SELECT NAME="order_kind_box" style='font-family: tahoma,arial ; font-size: 8pt; font-weight: bold; width: 140px'>
    620. 

  620. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    621. 

  621. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    622. 

  622. 				<OPTION value="  " <%if request.form("order_kind_box")="  " then response.write "selected" %> >  </option>
    623. 

  623. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    624. 

  624. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    625. 

  625. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    626. 

  626. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    627. 

  627. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    628. 

  628. 				<OPTION value="" <%if request.form("order_kind_box")="" then response.write "selected" %> ></option>
    629. 

  629. 			</SELECT></TD>
    630. 

  630. 		</TR>
    631. 

  631. 		<TR bgcolor="#555599">
    632. 

  632. 			<td colspan="11" style="height:2px"></td>
    633. 

  633. 		</TR>
    634. 

  634. 		<TR>
    635. 

  635. 			<TD>
    636. 

  636. 				<INPUT TYPE="checkbox" NAME="check_tarikh_sefaresh" onclick="check_tarikh_sefaresh_Click()" checked>
    637. 

  637. 			</TD>
    638. 

  638. 			<TD> </TD>
    639. 

  639. 			<TD>
    640. 

  640. 				<INPUT TYPE="text" NAME="az_tarikh_sefaresh" dir="LTR" value="<%=request.form("az_tarikh_sefaresh")%>" size="10" onKeyPress="return maskDate(this);" onBlur="if(acceptDate(this))document.all.ta_tarikh_sefaresh.value=this.value;" maxlength="10">
    641. 

  641. 			</TD>
    642. 

  642. 			<TD></TD>
    643. 

  643. 			<TD>
    644. 

  644. 				<INPUT TYPE="text" NAME="ta_tarikh_sefaresh" dir="LTR" value="<%=request.form("ta_tarikh_sefaresh")%>" size="10" onKeyPress="return maskDate(this);" onblur="acceptDate(this)" maxlength="10">
    645. 

  645. 			</TD>
    646. 

  646. 			<TD>
    647. 

  647. 				<INPUT TYPE="checkbox" NAME="check_marhale" onclick="check_marhale_Click()" checked>
    648. 

  648. 			</TD>
    649. 

  649. 			<TD></TD>
    650. 

  650. 			<TD>
    651. 

  651. 				<SELECT NAME="marhale_box" style='font-family: tahoma,arial ; font-size: 8pt; font-weight: bold; width: 140px'>
    652. 

  652. 					<%
    653. 

  653. 					set RS_STEP=Conn.Execute ("SELECT * FROM QuoteSteps WHERE (IsActive=1)")
    654. 

  654. 					Do while not RS_STEP.eof	
    655. 

  655. 					%>
    656. 

  656. 						<OPTION value="<%=RS_STEP("ID")%>" <%if cint(request("marhale_box"))=cint(RS_STEP("ID")) then response.write "selected" %> ><%=RS_STEP("name")%></option>
    657. 

  657. 						<%
    658. 

  658. 						RS_STEP.moveNext
    659. 

  659. 					loop
    660. 

  660. 					RS_STEP.close
    661. 

  661. 					%>
    662. 

  662. 				</SELECT>
    663. 

  663. 			</TD>
    664. 

  664. 			<TD>
    665. 

  665. 				<span id="marhale_not_check_label" style='font-weight:bold;color:red'></span>
    666. 

  666. 			</TD>
    667. 

  667. 			<TD>
    668. 

  668. 				<INPUT TYPE="checkbox" NAME="marhale_not_check" onclick="marhale_not_check_Click();" checked>
    669. 

  669. 			</TD>
    670. 

  670. 		</TR>
    671. 

  671. 		<TR bgcolor="#555599">
    672. 

  672. 			<td colspan="11" style="height:2px"></td>
    673. 

  673. 		</TR>
    674. 

  674. 		<TR bgcolor="#EEEEEE">
    675. 

  675. 			<TD>
    676. 

  676. 				<INPUT TYPE="checkbox" NAME="check_tarikh_tahvil" onclick="check_tarikh_tahvil_Click()" checked>
    677. 

  677. 			</TD>
    678. 

  678. 			<TD> </TD>
    679. 

  679. 			<TD>
    680. 

  680. 				<INPUT TYPE="text" NAME="az_tarikh_tahvil" dir="LTR" value="<%=request.form("az_tarikh_tahvil")%>" size="10" onblur="acceptDate(this)" maxlength="10" onKeyPress="return maskDate(this);">
    681. 

  681. 			</TD>
    682. 

  682. 			<TD></TD>
    683. 

  683. 			<TD>
    684. 

  684. 				<INPUT TYPE="text" NAME="ta_tarikh_tahvil" dir="LTR" value="<%=request.form("ta_tarikh_tahvil")%>" onblur="acceptDate(this)" maxlength="10" size="10" onKeyPress="return maskDate(this);">
    685. 

  685. 			</TD>
    686. 

  686. 			<td colspan="5"></td>
    687. 

  687. 			
    688. 

  688. 		</TR>
    689. 

  689. 		<TR bgcolor="#EEEEEE">
    690. 

  690. 			<TD colspan="5">&nbsp;</TD>
    691. 

  691. 			<TD>
    692. 

  692. 				<INPUT TYPE="checkbox" NAME="check_closed" onclick="check_closed_Click()" checked>
    693. 

  693. 			</TD>
    694. 

  694. 			<TD colspan="4">
    695. 

  695. 				<span id="check_closed_label" style='color:black;'>   </span>
    696. 

  696. 			</TD>
    697. 

  697. 		</TR>
    698. 

  698. 		<TR bgcolor="#555599">
    699. 

  699. 			<td colspan="11" style="height:2px"></td>
    700. 

  700. 		</TR>
    701. 

  701. 		<TR>
    702. 

  702. 			<TD colspan="5">&nbsp;</TD>
    703. 

  703. 			<TD>
    704. 

  704. 				<INPUT TYPE="checkbox" NAME="check_salesperson" onclick="check_salesperson_Click()" checked>
    705. 

  705. 			</TD>
    706. 

  706. 			<TD> </TD>
    707. 

  707. 			<TD colspan="3">
    708. 

  708. 				<SELECT NAME="salesperson_box" style='font-family: tahoma,arial ; font-size: 8pt; font-weight: bold; width: 140px'>
    709. 

  709. <%				set RSV=Conn.Execute ("SELECT RealName,id FROM Users WHERE Display=1 ORDER BY RealName") 
    710. 

  710. 				Do while not RSV.eof
    711. 

  711. %>
    712. 

  712. 					<option value="<%=RSV("RealName")%>" 
    713. 

  713. 						<%
    714. 

  714. 						if request.form("salesperson_box")="" then 
    715. 

  715. 							if RSV("id")=session("id") then response.write " selected "
    716. 

  716. 						else
    717. 

  717. 							if RSV("RealName")=request.form("salesperson_box") then response.write " selected "
    718. 

  718. 						end if
    719. 

  719. 						%> >
    720. 

  720. 						<%=RSV("RealName")%>
    721. 

  721. 					</option>
    722. 

  722. <%
    723. 

  723. 				RSV.moveNext
    724. 

  724. 				Loop
    725. 

  725. 				RSV.close
    726. 

  726. %>
    727. 

  727. 				</SELECT>
    728. 

  728. 			</TD>
    729. 

  729. 		</TR>
    730. 

  730. 		<TR bgcolor="#555599">
    731. 

  731. 			<td colspan="11" style="height:2px"></td>
    732. 

  732. 		</TR>
    733. 

  733. 		<TR bgcolor="#EEEEEE">
    734. 

  734. 			<TD>
    735. 

  735. 				<INPUT TYPE="checkbox" NAME="check_company_name" onclick="check_company_name_Click()" checked>
    736. 

  736. 			</TD>
    737. 

  737. 			<TD> </TD>
    738. 

  738. 			<TD colspan="3">
    739. 

  739. 				<INPUT TYPE="text" NAME="company_name_box" value="<%=request.form("company_name_box")%>">
    740. 

  740. 			</TD>
    741. 

  741. 			<TD>
    742. 

  742. 				<INPUT TYPE="checkbox" NAME="check_telephone" onclick="check_telephone_Click()" checked>
    743. 

  743. 			</TD>
    744. 

  744. 			<TD></TD>
    745. 

  745. 			<TD colspan="3">
    746. 

  746. 				<INPUT TYPE="text" NAME="telephone_box" value="<%=request.form("telephone_box")%>">
    747. 

  747. 			</TD>
    748. 

  748. 		</TR>
    749. 

  749. 		<TR bgcolor="#555599">
    750. 

  750. 			<td colspan="11" style="height:2px"></td>
    751. 

  751. 		</TR>
    752. 

  752. 		<TR>
    753. 

  753. 			<TD>
    754. 

  754. 				<INPUT TYPE="checkbox" NAME="check_customer_name" onclick="check_customer_name_Click()" checked>
    755. 

  755. 			</TD>
    756. 

  756. 			<TD> </TD>
    757. 

  757. 			<TD colspan="3">
    758. 

  758. 				<INPUT TYPE="text" NAME="customer_name_box" value="<%=request.form("customer_name_box")%>">
    759. 

  759. 			</TD>
    760. 

  760. 			<TD>
    761. 

  761. 				<INPUT TYPE="checkbox" NAME="check_order_title" onclick="check_order_title_Click()" checked>
    762. 

  762. 			</TD>
    763. 

  763. 			<TD> </TD>
    764. 

  764. 			<TD colspan="3">
    765. 

  765. 				<INPUT TYPE="text" NAME="order_title_box" value="<%=request.form("order_title_box")%>">
    766. 

  766. 			</TD>
    767. 

  767. 		</TR>
    768. 

  768. 		<TR bgcolor="#555599">
    769. 

  769. 			<td colspan="11" style="height:2px"></td>
    770. 

  770. 		</TR>
    771. 

  771. 		<TR bgcolor="#AAAAEE">
    772. 

  772. 			<td colspan="11" style="height:30px">
    773. 

  773. 			<TABLE align="center" width="50%">
    774. 

  774. 			<TR>
    775. 

  775. 				<TD><INPUT TYPE="submit" Name="Submit" Value="" style="font-family:tahoma,arial; font-size:10pt;width:100px;"></TD>
    776. 

  776. 				<TD align="left"><INPUT TYPE="button" Name="Cancel" Value=" " style="font-family:tahoma,arial; font-size:10pt;width:100px;" onclick="window.location='?act=advancedSearch';"></TD>
    777. 

  777. 			</TR>
    778. 

  778. 			<TR>
    779. 

  779. 				<TD align="left"> :</TD>
    780. 

  780. 				<TD>&nbsp;<INPUT TYPE="Text" Name="resultsCount" value="<%=resultsCount%>" maxlength="4" size="4" onKeyPress="return maskNumber(this);"></TD>
    781. 

  781. 			</TR>
    782. 

  782. 			</TABLE>
    783. 

  783. 			</td>
    784. 

  784. 		</TR>
    785. 

  785. 		</TABLE>
    786. 

  786. 	</TD></TR>
    787. 

  787. 	</FORM>
    788. 

  788. 	</TABLE>
    789. 

  789. 	<hr>
    790. 

  790. 	<SCRIPT LANGUAGE='JavaScript'>
    791. 

  791. 	<!--
    792. 

  792. 	function check_sefaresh_Click(){
    793. 

  793. 		if ( document.all.check_sefaresh.checked ) {
    794. 

  794. 			document.all.az_sefaresh.style.visibility = "visible";
    795. 

  795. 			document.all.ta_sefaresh.style.visibility = "visible";
    796. 

  796. 			document.all.az_sefaresh.focus();
    797. 

  797. 		}
    798. 

  798. 		else{
    799. 

  799. 			document.all.az_sefaresh.style.visibility = "hidden";
    800. 

  800. 			document.all.ta_sefaresh.style.visibility = "hidden";
    801. 

  801. 		}
    802. 

  802. 	}
    803. 

  803. 

  804. 	function check_tarikh_sefaresh_Click(){
    805. 

  805. 		if ( document.all.check_tarikh_sefaresh.checked ) {
    806. 

  806. 			document.all.az_tarikh_sefaresh.style.visibility = "visible";
    807. 

  807. 			document.all.ta_tarikh_sefaresh.style.visibility = "visible";
    808. 

  808. 			document.all.az_tarikh_sefaresh.focus();
    809. 

  809. 		}
    810. 

  810. 		else{
    811. 

  811. 			document.all.az_tarikh_sefaresh.style.visibility = "hidden";
    812. 

  812. 			document.all.ta_tarikh_sefaresh.style.visibility = "hidden";
    813. 

  813. 		}
    814. 

  814. 	}
    815. 

  815. 

  816. 	function check_tarikh_tahvil_Click(){
    817. 

  817. 		if ( document.all.check_tarikh_tahvil.checked ) {
    818. 

  818. 			document.all.az_tarikh_tahvil.style.visibility = "visible";
    819. 

  819. 			document.all.ta_tarikh_tahvil.style.visibility = "visible";
    820. 

  820. 			document.all.az_tarikh_tahvil.focus();
    821. 

  821. 		}
    822. 

  822. 		else{
    823. 

  823. 			document.all.az_tarikh_tahvil.style.visibility = "hidden";
    824. 

  824. 			document.all.ta_tarikh_tahvil.style.visibility = "hidden";
    825. 

  825. 		}
    826. 

  826. 	}
    827. 

  827. 

  828. 	function check_company_name_Click(){
    829. 

  829. 		if (document.all.check_company_name.checked) {
    830. 

  830. 			document.all.company_name_box.style.visibility = "visible";
    831. 

  831. 			document.all.company_name_box.focus();
    832. 

  832. 		}
    833. 

  833. 		else{
    834. 

  834. 			document.all.company_name_box.style.visibility = "hidden";
    835. 

  835. 		}
    836. 

  836. 	}
    837. 

  837. 

  838. 	function check_customer_name_Click(){
    839. 

  839. 		if (document.all.check_customer_name.checked) {
    840. 

  840. 			document.all.customer_name_box.style.visibility = "visible";
    841. 

  841. 			document.all.customer_name_box.focus();
    842. 

  842. 		}
    843. 

  843. 		else{
    844. 

  844. 			document.all.customer_name_box.style.visibility = "hidden";
    845. 

  845. 		}
    846. 

  846. 	}
    847. 

  847. 

  848. 	function check_kind_Click(){
    849. 

  849. 		if (document.all.check_kind.checked) {
    850. 

  850. 			document.all.order_kind_box.style.visibility = "visible";
    851. 

  851. 			document.all.order_kind_box.focus();
    852. 

  852. 		}
    853. 

  853. 		else{
    854. 

  854. 			document.all.order_kind_box.style.visibility = "hidden";
    855. 

  855. 		}
    856. 

  856. 	}
    857. 

  857. 

  858. 	function check_marhale_Click(){
    859. 

  859. 		if (document.all.check_marhale.checked) {
    860. 

  860. 			document.all.marhale_box.style.visibility = "visible";
    861. 

  861. 			document.all.marhale_box.focus();
    862. 

  862. 			document.all.marhale_not_check.style.visibility = "visible";
    863. 

  863. 			marhale_not_check_Click();	
    864. 

  864. 		}
    865. 

  865. 		else{
    866. 

  866. 			document.all.marhale_box.style.visibility = "hidden";
    867. 

  867. 			document.all.marhale_not_check.style.visibility = "hidden";
    868. 

  868. 			document.all.marhale_not_check_label.style.color='#BBBBBB'
    869. 

  869. 		}
    870. 

  870. 	}
    871. 

  871. 

  872. 	function check_salesperson_Click(){
    873. 

  873. 		if (document.all.check_salesperson.checked) {
    874. 

  874. 			document.all.salesperson_box.style.visibility = "visible";
    875. 

  875. 			document.all.salesperson_box.focus();
    876. 

  876. 		}
    877. 

  877. 		else{
    878. 

  878. 			document.all.salesperson_box.style.visibility = "hidden";
    879. 

  879. 		}
    880. 

  880. 	}
    881. 

  881. 

  882. 	function check_telephone_Click(){
    883. 

  883. 		if (document.all.check_telephone.checked) {
    884. 

  884. 			document.all.telephone_box.style.visibility = "visible";
    885. 

  885. 			document.all.telephone_box.focus();
    886. 

  886. 		}
    887. 

  887. 		else{
    888. 

  888. 			document.all.telephone_box.style.visibility = "hidden";
    889. 

  889. 		}
    890. 

  890. 	}
    891. 

  891. 

  892. 	function check_order_title_Click(){
    893. 

  893. 		if (document.all.check_order_title.checked) {
    894. 

  894. 			document.all.order_title_box.style.visibility = "visible";
    895. 

  895. 			document.all.order_title_box.focus();
    896. 

  896. 		}
    897. 

  897. 		else{
    898. 

  898. 			document.all.order_title_box.style.visibility = "hidden";
    899. 

  899. 		}
    900. 

  900. 	}
    901. 

  901. 

  902. 	function marhale_not_check_Click(){
    903. 

  903. 		if (document.all.marhale_not_check.checked) {
    904. 

  904. 			document.all.marhale_not_check_label.style.color='red'
    905. 

  905. 		}
    906. 

  906. 		else{
    907. 

  907. 			document.all.marhale_not_check_label.style.color='#BBBBBB'
    908. 

  908. 		}
    909. 

  909. 	}
    910. 

  910. 

  911. 

  912. 	function vazyat_not_check_Click(){
    913. 

  913. 		if (document.all.vazyat_not_check.checked) {
    914. 

  914. 			document.all.vazyat_not_check_label.style.color='red'
    915. 

  915. 		}
    916. 

  916. 		else{
    917. 

  917. 			document.all.vazyat_not_check_label.style.color='#BBBBBB'
    918. 

  918. 		}
    919. 

  919. 	}
    920. 

  920. 

  921. 	function check_closed_Click(){
    922. 

  922. 		if (document.all.check_closed.checked) {
    923. 

  923. 			document.all.check_closed_label.style.color='black'
    924. 

  924. 		}
    925. 

  925. 		else{
    926. 

  926. 			document.all.check_closed_label.style.color='#BBBBBB'
    927. 

  927. 		}
    928. 

  928. 	}
    929. 

  929. 

  930. 

  931. 	function Form_Load(){
    932. 

  932. 	<%
    933. 

  933. 	maybeAND = ""
    934. 

  934. 	myCriteria = ""
    935. 

  935. 	If request.form("check_sefaresh") = "on" Then
    936. 

  936. 		if request.form("az_sefaresh") <> "" then
    937. 

  937. 			myCriteria = myCriteria & maybeAND & " Quotes.ID >= " & request.form("az_sefaresh")
    938. 

  938. 			maybeAND=" AND "
    939. 

  939. 		End If
    940. 

  940. 		if request.form("ta_sefaresh") <> "" then
    941. 

  941. 			myCriteria = myCriteria & maybeAND & " Quotes.ID <= " & request.form("ta_sefaresh")
    942. 

  942. 			maybeAND=" AND "
    943. 

  943. 		End If
    944. 

  944. 		If (request.form("az_sefaresh") = "") AND (request.form("ta_sefaresh") = "") then
    945. 

  945. 			response.write "document.all.check_sefaresh.checked = false;" & vbCrLf
    946. 

  946. 			response.write "document.all.az_sefaresh.style.visibility = 'hidden';" & vbCrLf
    947. 

  947. 			response.write "document.all.ta_sefaresh.style.visibility = 'hidden';" & vbCrLf
    948. 

  948. 		End If
    949. 

  949. 	Else
    950. 

  950. 		response.write "document.all.check_sefaresh.checked = false;" & vbCrLf
    951. 

  951. 		response.write "document.all.az_sefaresh.style.visibility = 'hidden';" & vbCrLf
    952. 

  952. 		response.write "document.all.ta_sefaresh.style.visibility = 'hidden';" & vbCrLf
    953. 

  953. 

  954. 	End If
    955. 

  955. 

  956. 	If request.form("check_tarikh_sefaresh") = "on" Then
    957. 

  957. 		if request.form("az_tarikh_sefaresh") <> "" then
    958. 

  958. 			myCriteria = myCriteria & maybeAND & "order_date >= '" & request.form("az_tarikh_sefaresh") & "'"
    959. 

  959. 			maybeAND=" AND "
    960. 

  960. 		End If
    961. 

  961. 		if request.form("ta_tarikh_sefaresh") <> "" then
    962. 

  962. 			myCriteria = myCriteria & maybeAND & "order_date <= '" & request.form("ta_tarikh_sefaresh") & "'"
    963. 

  963. 			maybeAND=" AND "
    964. 

  964. 		End If 
    965. 

  965. 		If (request.form("az_tarikh_sefaresh") = "") AND (request.form("ta_tarikh_sefaresh") = "") then
    966. 

  966. 			response.write "document.all.check_tarikh_sefaresh.checked = false;" & vbCrLf
    967. 

  967. 			response.write "document.all.az_tarikh_sefaresh.style.visibility = 'hidden';" & vbCrLf
    968. 

  968. 			response.write "document.all.ta_tarikh_sefaresh.style.visibility = 'hidden';" & vbCrLf
    969. 

  969. 		End If
    970. 

  970. 	Else
    971. 

  971. 		response.write "document.all.check_tarikh_sefaresh.checked = false;" & vbCrLf
    972. 

  972. 		response.write "document.all.az_tarikh_sefaresh.style.visibility = 'hidden';" & vbCrLf
    973. 

  973. 		response.write "document.all.ta_tarikh_sefaresh.style.visibility = 'hidden';" & vbCrLf
    974. 

  974. 	End If
    975. 

  975. 

  976. 	If request.form("check_tarikh_tahvil") = "on" Then
    977. 

  977. 		if request.form("az_tarikh_tahvil") <> "" then
    978. 

  978. 

  979. 			myCriteria = myCriteria & maybeAND & "return_date >= '" & request.form("az_tarikh_tahvil") & "'"
    980. 

  980. 			maybeAND=" AND "
    981. 

  981. 		End If
    982. 

  982. 		if request.form("ta_tarikh_tahvil") <> "" then
    983. 

  983. 			myCriteria = myCriteria & maybeAND & "return_date <= '" & request.form("ta_tarikh_tahvil") & "'"
    984. 

  984. 			maybeAND=" AND "
    985. 

  985. 		End If
    986. 

  986. 		If (request.form("az_tarikh_tahvil") = "") AND (request.form("ta_tarikh_tahvil") = "") then
    987. 

  987. 			response.write "document.all.check_tarikh_tahvil.checked = false;" & vbCrLf
    988. 

  988. 			response.write "document.all.az_tarikh_tahvil.style.visibility = 'hidden';" & vbCrLf
    989. 

  989. 			response.write "document.all.ta_tarikh_tahvil.style.visibility = 'hidden';" & vbCrLf
    990. 

  990. 		End If
    991. 

  991. 	Else
    992. 

  992. 		response.write "document.all.check_tarikh_tahvil.checked = false;" & vbCrLf
    993. 

  993. 		response.write "document.all.az_tarikh_tahvil.style.visibility = 'hidden';" & vbCrLf
    994. 

  994. 		response.write "document.all.ta_tarikh_tahvil.style.visibility = 'hidden';" & vbCrLf
    995. 

  995. 	End If
    996. 

  996. 

  997. 	If (request.form("check_company_name") = "on" AND request.form("company_name_box") <> "" ) then
    998. 

  998. 		myCriteria = myCriteria & maybeAND & "company_name Like N'%" & request.form("company_name_box") &"%'"
    999. 

  999. 		maybeAND=" AND "
    1000. 

  1000. 	Else
    1001. 

  1001. 		response.write "document.all.check_company_name.checked = false;" & vbCrLf
    1002. 

  1002. 		response.write "document.all.company_name_box.style.visibility = 'hidden';" & vbCrLf
    1003. 

  1003. 	End If
    1004. 

  1004. 

  1005. 	If (request.form("check_customer_name") = "on" AND request.form("customer_name_box") <> "")then
    1006. 

  1006. 		myCriteria = myCriteria & maybeAND & "customer_name Like N'%" & request.form("customer_name_box") &"%'"
    1007. 

  1007. 		maybeAND=" AND "
    1008. 

  1008. 	Else
    1009. 

  1009. 		response.write "document.all.check_customer_name.checked = false;" & vbCrLf
    1010. 

  1010. 		response.write "document.all.customer_name_box.style.visibility = 'hidden';" & vbCrLf
    1011. 

  1011. 	End If
    1012. 

  1012. 

  1013. 	If request.form("check_kind") = "on" then
    1014. 

  1014. 		myCriteria = myCriteria & maybeAND & "order_kind = N'" & request.form("order_kind_box") & "'"
    1015. 

  1015. 		maybeAND=" AND "
    1016. 

  1016. 	Else
    1017. 

  1017. 		response.write "document.all.check_kind.checked = false;" & vbCrLf
    1018. 

  1018. 		response.write "document.all.order_kind_box.style.visibility = 'hidden';" & vbCrLf
    1019. 

  1019. 	End If
    1020. 

  1020. 

  1021. 	If request("check_marhale") = "on" then
    1022. 

  1022. 		If request("marhale_not_check") = "on" then
    1023. 

  1023. 			myCriteria = myCriteria & maybeAND & "NOT(step = " & request("marhale_box") & ")"
    1024. 

  1024. 		Else
    1025. 

  1025. 			myCriteria = myCriteria & maybeAND & "step = " & request("marhale_box") 
    1026. 

  1026. 			response.write "document.all.marhale_not_check.checked = false;" & vbCrLf
    1027. 

  1027. 			response.write "document.all.marhale_not_check_label.style.color='#BBBBBB';"& vbCrLf
    1028. 

  1028. 		End If
    1029. 

  1029. 		maybeAND=" AND "
    1030. 

  1030. 	Else
    1031. 

  1031. 		response.write "document.all.check_marhale.checked = false;" & vbCrLf
    1032. 

  1032. 		response.write "document.all.marhale_box.style.visibility = 'hidden';" & vbCrLf
    1033. 

  1033. 		response.write "document.all.marhale_not_check.style.visibility = 'hidden';" & vbCrLf
    1034. 

  1034. 		response.write "document.all.marhale_not_check_label.style.color='#BBBBBB';"& vbCrLf
    1035. 

  1035. 	End If
    1036. 

  1036. 

  1037. 	If request.form("check_salesperson") = "on" then
    1038. 

  1038. 		myCriteria = myCriteria & maybeAND & "salesperson = N'" & request.form("salesperson_box") & "'"
    1039. 

  1039. 		maybeAND=" AND "
    1040. 

  1040. 	Else
    1041. 

  1041. 		response.write "document.all.check_salesperson.checked = false;" & vbCrLf
    1042. 

  1042. 		response.write "document.all.salesperson_box.style.visibility = 'hidden';" & vbCrLf
    1043. 

  1043. 	End If
    1044. 

  1044. 

  1045. 	If (request.form("check_order_title") = "on" AND request.form("order_title_box") <> "")then
    1046. 

  1046. 		myCriteria = myCriteria & maybeAND & "order_title Like N'%" & request.form("order_title_box") &"%'"
    1047. 

  1047. 		maybeAND=" AND "
    1048. 

  1048. 	Else
    1049. 

  1049. 		response.write "document.all.check_order_title.checked = false;" & vbCrLf
    1050. 

  1050. 		response.write "document.all.order_title_box.style.visibility = 'hidden';" & vbCrLf
    1051. 

  1051. 	End If
    1052. 

  1052. 

  1053. 	If (request.form("check_telephone") = "on" AND request.form("telephone_box") <> "")then
    1054. 

  1054. 		myCriteria = myCriteria & maybeAND & "telephone Like N'%" & request.form("telephone_box") &"%'"
    1055. 

  1055. 		maybeAND=" AND "
    1056. 

  1056. 	Else
    1057. 

  1057. 		response.write "document.all.check_telephone.checked = false;" & vbCrLf
    1058. 

  1058. 		response.write "document.all.telephone_box.style.visibility = 'hidden';" & vbCrLf
    1059. 

  1059. 	End If
    1060. 

  1060. 

  1061. 	If request("check_closed") = "on" then
    1062. 

  1062. 		myCriteria = myCriteria & maybeAND & "Quotes.Closed=0"
    1063. 

  1063. 	Else
    1064. 

  1064. 		If request("Submit")="" then
    1065. 

  1065. 			response.write "document.all.check_closed.checked = false;" & vbCrLf
    1066. 

  1066. 			response.write "document.all.check_closed_label.style.color='#BBBBBB';" & vbCrLf
    1067. 

  1067. 		End If
    1068. 

  1068. 	End If
    1069. 

  1069. 

  1070. 	%>
    1071. 

  1071. 	}
    1072. 

  1072. 	function checkValidation(){
    1073. 

  1073. 		return true;
    1074. 

  1074. 	}
    1075. 

  1075. 

  1076. 	Form_Load();
    1077. 

  1077. 

  1078. 	//-->
    1079. 

  1079. 	</SCRIPT>
    1080. 

  1080. <%
    1081. 

  1081. 	if request("Submit")="" then
    1082. 

  1082. 		IF maybeAND <> " AND " THEN
    1083. 

  1083. 			response.write "Nothing !!!!!!!!!!"
    1084. 

  1084. 		ELSE
    1085. 

  1085. 

  1086. 			mySQL=	"SELECT Quotes.*, OrderTraceStatus.Name AS StatusName, OrderTraceStatus.Icon , Invoices.ID AS InvoiceID, Invoices.Approved, Invoices.Voided, Invoices.Issued, DRV_invoice.price "&_ 
    1087. 

  1087. 					" FROM Quotes INNER JOIN "&_ 
    1088. 

  1088. 					" OrderTraceStatus ON OrderTraceStatus.ID = Quotes.status LEFT OUTER JOIN "&_ 
    1089. 

  1089. 					" Invoices INNER JOIN "&_ 
    1090. 

  1090. 					" InvoiceQuoteRelations ON Invoices.ID = InvoiceQuoteRelations.Invoice ON Quotes.ID = InvoiceQuoteRelations.Quote "&_ 
    1091. 

  1091. 					" left outer join (select Invoice,SUM(InvoiceLines.Price +InvoiceLines.Vat - InvoiceLines.Discount -InvoiceLines.Reverse) as price from InvoiceLines inner join Invoices on invoiceLines.invoice=invoices.id where invoices.voided=0 group by Invoice) DRV_invoice on Invoices.ID=DRV_invoice.Invoice "&_
    1092. 

  1092. 					" WHERE ("& myCriteria & ")  "&_ 
    1093. 

  1093. 					" ORDER BY Quotes.order_date DESC, Quotes.ID DESC "
    1094. 

  1094. 

  1095. '			mySQL=	"SELECT Quotes.*, OrderTraceStatus.Name AS StatusName, OrderTraceStatus.Icon "&_
    1096. 

  1096. '					" FROM Quotes JOIN OrderTraceStatus ON OrderTraceStatus.ID = Quotes.status "&_
    1097. 

  1097. '					" WHERE ("& myCriteria & ") ORDER BY order_date DESC, Quotes.ID DESC"
    1098. 

  1098. '
    1099. 

  1099. 'response.write mySQL
    1100. 

  1100. 			set RS1=Conn.Execute (mySQL)
    1101. 

  1101. 			if not RS1.eof then
    1102. 

  1102. 				tmpCounter=0
    1103. 

  1103. %>
    1104. 

  1104. 			<div align="center" dir="LTR">
    1105. 

  1105. 			<TABLE border="1" cellspacing="0" cellpadding="1" dir="RTL" borderColor="#555588">
    1106. 

  1106. 				<TR bgcolor="#CCCCFF">
    1107. 

  1107. 					<TD width="41"># </TD>
    1108. 

  1108. 					<TD width="46"> </TD>
    1109. 

  1109. 					<TD width="56"> </TD>
    1110. 

  1110. 					<TD width="116"> </TD>
    1111. 

  1111. 					<TD width="106"> </TD>
    1112. 

  1112. 					<TD > </TD>
    1113. 

  1113. 					<TD width="36"></TD>
    1114. 

  1114. 					<TD width="46"></TD>
    1115. 

  1115. 					<TD width="36"> </TD>
    1116. 

  1116. 					<TD width="40"></TD>
    1117. 

  1117. 					<td width="50"></td>
    1118. 

  1118. 				</TR>
    1119. 

  1119. <%				Do while not RS1.eof and tmpCounter < resultsCount
    1120. 

  1120. 				tmpCounter = tmpCounter + 1
    1121. 

  1121. 				if tmpCounter mod 2 = 1 then
    1122. 

  1122. 					tmpColor="#FFFFFF"
    1123. 

  1123. 				Else
    1124. 

  1124. 					tmpColor="#DDDDDD"
    1125. 

  1125. 				End If
    1126. 

  1126. 

  1127. 				if RS1("Closed") then
    1128. 

  1128. 					tmpStyle="background-color:#FFCCCC;"
    1129. 

  1129. 				else
    1130. 

  1130. 					tmpStyle=""
    1131. 

  1131. 				End If
    1132. 

  1132. 				
    1133. 

  1133. 				if isnull(RS1("InvoiceID")) then
    1134. 

  1134. 					InvoiceStatus="<span style='color:red;'><b></b></span>"
    1135. 

  1135. 				else
    1136. 

  1136. 					if RS1("Voided") then
    1137. 

  1137. 						style="style='color:Red' Title=' '"
    1138. 

  1138. 					elseif RS1("Issued") then
    1139. 

  1139. 						style="style='color:Red' Title=' '"
    1140. 

  1140. 					elseif RS1("Approved") then
    1141. 

  1141. 						style="style='color:Green' Title=' '"
    1142. 

  1142. 					else
    1143. 

  1143. 						style="style='color:#3399FF' Title=' '"
    1144. 

  1144. 					end if
    1145. 

  1145. 					InvoiceStatus="<A " & style & " HREF='../AR/AccountReport.asp?act=showInvoice&invoice=" & RS1("InvoiceID")& "' Target='_blank'>" & RS1("InvoiceID") & "</A>"
    1146. 

  1146. 				end if
    1147. 

  1147. 

  1148. %>
    1149. 

  1149. 				<TR bgcolor="<%=tmpColor%>" title="<%=RS1("StatusName")%>">
    1150. 

  1150. 					<TD DIR="LTR"><A HREF="?act=show&quote=<%=RS1("ID")%>" target="_blank"><%=RS1("ID")%></A></TD>
    1151. 

  1151. 					<TD DIR="LTR"><%=RS1("order_date")%></TD>
    1152. 

  1152. 					<TD DIR="LTR"><%=RS1("return_date") & " ("& RS1("return_time") & ")"%></TD>
    1153. 

  1153. 					<TD ><%=RS1("company_name") & "<br>:("& RS1("telephone")& ")"%>&nbsp;</TD>
    1154. 

  1154. 					<TD ><%=RS1("customer_name")%>&nbsp;</TD>
    1155. 

  1155. 					<TD ><%=RS1("order_title")%>&nbsp;</TD>
    1156. 

  1156. 					<TD ><%=RS1("order_kind")%></TD>
    1157. 

  1157. 					<TD style="<%=tmpStyle%>"><%=RS1("marhale")%></TD>
    1158. 

  1158. 					<TD ><%=RS1("salesperson")%>&nbsp;</TD>
    1159. 

  1159. 					<TD ><%=InvoiceStatus%>&nbsp;</TD>
    1160. 

  1160. 					<td><%if isnull(RS1("price")) then response.write "----" else response.write Separate(RS1("price")) end if %></td>
    1161. 

  1161. 				</TR>
    1162. 

  1162. 				<TR bgcolor="#FFFFFF">
    1163. 

  1163. 					<TD colspan="12" style="height:10px"></TD>
    1164. 

  1164. 				</TR>
    1165. 

  1165. <%					RS1.moveNext
    1166. 

  1166. 				Loop
    1167. 

  1167. 

  1168. 				if tmpCounter >= resultsCount then
    1169. 

  1169. %>					<TR bgcolor="#CCCCCC">
    1170. 

  1170. 						<TD align="center" colspan="10" style="padding:15px;font-size:12pt;color:red;cursor:hand;" onclick="document.all.resultsCount.focus();"><B>     <%=resultsCount%>  .</B></TD>
    1171. 

  1171. 					</TR>
    1172. 

  1172. <%				else
    1173. 

  1173. %>					<TR bgcolor="#ccccFF">
    1174. 

  1174. 						<TD colspan="10">  : <%=tmpCounter%></TD>
    1175. 

  1175. 					</TR>
    1176. 

  1176. <%				end if
    1177. 

  1177. %>
    1178. 

  1178. 			</TABLE>
    1179. 

  1179. 			</div>
    1180. 

  1180. 			<BR>
    1181. 

  1181. <%			else
    1182. 

  1182. %>			<TABLE border="1" cellspacing="0" cellpadding="0" dir="RTL" align="center" width="600">
    1183. 

  1183. 				<TR bgcolor="#FFFFDD">
    1184. 

  1184. 					<TD align="center" style="height:40px;font-size:12pt;font-weight:bold;color:red">     .</TD>
    1185. 

  1185. 				</TR>
    1186. 

  1186. 			</TABLE>
    1187. 

  1187. 			<hr>
    1188. 

  1188. <%			End If
    1189. 

  1189. 		End If
    1190. 

  1190. 	End If
    1191. 

  1191. ' Trace Quote End.
    1192. 

  1192. '-----------------------------
    1193. 

    1194. 

  1194. '-----------------------------
    1195. 

  1195. ' Quote Input
    1196. 

  1196. '-----------------------------
    1197. 

  1197. elseif Request.QueryString("act")="quoteInpCustSearch" then
    1198. 

  1198. 	if isnumeric(request("CustomerNameSearchBox")) then
    1199. 

  1199. 		conn.close
    1200. 

  1200. 		response.redirect "?act=getQuote&selectedCustomer=" & request("CustomerNameSearchBox")
    1201. 

  1201. 	elseif request("CustomerNameSearchBox") <> "" then
    1202. 

  1202. 		SA_TitleOrName=request("CustomerNameSearchBox")
    1203. 

  1203. 		mySQL="SELECT * FROM Accounts WHERE (REPLACE(AccountTitle, ' ', '') LIKE REPLACE(N'%"& sqlSafe(SA_TitleOrName) & "%', ' ', '') ) ORDER BY AccountTitle"
    1204. 

  1204. 		Set RS1 = conn.Execute(mySQL)
    1205. 

  1205. 

  1206. 		if (RS1.eof) then 
    1207. 

  1207. 			conn.close
    1208. 

  1208. 			response.redirect "?errmsg=" & Server.URLEncode("   .<br><a href='../CRM/AccountEdit.asp?act=getAccount'> Ͽ</a>")
    1209. 

  1209. 		end if 
    1210. 

  1210. 

  1211. 		SA_TitleOrName=request("CustomerNameSearchBox")
    1212. 

  1212. 		SA_Action="return true;"
    1213. 

  1213. 		SA_SearchAgainURL="Inquiry.asp"
    1214. 

  1214. 		SA_StepText="  :  "
    1215. 

  1215. %>
    1216. 

  1216. <br>
    1217. 

  1217. <FORM METHOD=POST ACTION="?act=getType">
    1218. 

  1218. 	<!--#include File="../AR/include_SelectAccount.asp"-->
    1219. 

  1219. </FORM>
    1220. 

  1220. <%
    1221. 

  1221. 	end if
    1222. 

  1222. elseif Request.QueryString("act")="getType" then 
    1223. 

  1223. 	customerID=request("selectedCustomer")
    1224. 

  1224. 	mySQL="SELECT * FROM Accounts WHERE (ID='"& CustomerID & "')"
    1225. 

  1225. 	Set RS1 = conn.Execute(mySQL)
    1226. 

  1226. 

  1227. 	if (RS1.eof) then 
    1228. 

  1228. 		conn.close
    1229. 

  1229. 		response.redirect "?errmsg=" & Server.URLEncode("   .<br><a href='..//CRM/AccountEdit.asp?act=getAccount'> Ͽ</a>")
    1230. 

  1230. 	end if 
    1231. 

  1231. %>
    1232. 

  1232. 		<br>
    1233. 

  1233. 		<div dir='rtl'>
    1234. 

  1234. 			<B>  :   </B>
    1235. 

  1235. 		</div>
    1236. 

  1236. 		<form method="post" action="?act=getQuote">
    1237. 

  1237. 			<input name="selectedCustomer" type="hidden" value="<%=customerID%>">
    1238. 

  1238. 			<SELECT NAME="OrderType" style='font-family: tahoma,arial ; font-size: 9pt; font-weight: bold; width: 100px' tabIndex="7">
    1239. 

  1239. 			<OPTION value="-1" style='color:red;'> </option>
    1240. 

  1240. <%
    1241. 

  1241. 			Set RS2 = conn.Execute("SELECT [User] as ID, DefaultOrderType FROM UserDefaults WHERE ([User] = "& session("ID") & ") OR (UserDefaults.[User] = 0) ORDER BY ABS(UserDefaults.[User]) DESC")
    1242. 

  1242. 			defaultOrderType=RS2("DefaultOrderType")
    1243. 

  1243. 			RS2.close
    1244. 

  1244. 			Set RS2 = Nothing
    1245. 

  1245. 

  1246. 			set RS_TYPE=Conn.Execute ("SELECT ID, Name FROM OrderTraceTypes WHERE (IsActive=1) ORDER BY ID")
    1247. 

  1247. 			Do while not RS_TYPE.eof	
    1248. 

  1248. %>
    1249. 

  1249. 				<OPTION value="<%=RS_TYPE("ID")%>" <%if RS_TYPE("ID")=defaultOrderType then response.write "selected"%>><%=RS_TYPE("Name")%></option>
    1250. 

  1250. <%
    1251. 

  1251. 			RS_TYPE.moveNext
    1252. 

  1252. 			loop
    1253. 

  1253. 			RS_TYPE.close
    1254. 

  1254. 			set RS_TYPE = nothing
    1255. 

  1255. %>		
    1256. 

  1256. 			</SELECT>
    1257. 

  1257. 			<input type="submit" value="">
    1258. 

  1258. 		</form>
    1259. 

  1259. <%	
    1260. 

  1260. elseif Request.QueryString("act")="getQuote" then
    1261. 

  1261. 	customerID=request("selectedCustomer")
    1262. 

  1262. 	mySQL="SELECT * FROM Accounts WHERE (ID='"& CustomerID & "')"
    1263. 

  1263. 	Set RS1 = conn.Execute(mySQL)
    1264. 

  1264. 

  1265. 	if (RS1.eof) then 
    1266. 

  1266. 		conn.close
    1267. 

  1267. 		response.redirect "?errmsg=" & Server.URLEncode("   .<br><a href='..//CRM/AccountEdit.asp?act=getAccount'> Ͽ</a>")
    1268. 

  1268. 	end if 
    1269. 

  1269. 	rs1.close
    1270. 

  1270. 	set rs1=nothing
    1271. 

  1271. 	set rs=Conn.Execute("select * from OrderTraceTypes where id=" & request("orderType"))
    1272. 

  1272. 	if rs.eof then 
    1273. 

  1273. 		conn.close
    1274. 

  1274. 		response.redirect "?errmsg=" & server.urlEncode("    ")
    1275. 

  1275. 	end if
    1276. 

  1276. 	orderTypeID=rs("id")
    1277. 

  1277. 

  1278. 	rs.close
    1279. 

  1279. 	set rs=nothing
    1280. 

  1280. 	
    1281. 

  1281. %>
    1282. 

  1282. 	<script type="text/javascript" src="calcOrder.js"></script>
    1283. 

  1283. 	<script type="text/javascript">
    1284. 

  1284. 		function checkValidation() {
    1285. 

  1285. 			if ($('input[name="CustomerName"]').val().replace(/^\s*|\s*$/g,'')==''){
    1286. 

  1286. 				alert("    ");
    1287. 

  1287. 				$('input[name="CustomerName"]').focus();
    1288. 

  1288. 				//$("input#Submit").prop("disabled",true);
    1289. 

  1289. 				return false;
    1290. 

  1290. 			} else if ($('input[name="SalesPerson"]').val().replace(/^\s*|\s*$/g,'')==''){
    1291. 

  1291. 				alert("    ");
    1292. 

  1292. 				$('input[name="SalesPerson"]').focus();
    1293. 

  1293. 				//$("input#Submit").prop("disabled",true);
    1294. 

  1294. 				return false;
    1295. 

  1295. 			} else if ($('input[name="ReturnDate"]').val().replace(/^\s*|\s*$/g,'')==''){
    1296. 

  1296. 				alert("    ");
    1297. 

  1297. 				$('input[name="ReturnDate"]').focus();
    1298. 

  1298. 				//$("input#Submit").prop("disabled",true);
    1299. 

  1299. 				return false;
    1300. 

  1300. 			} else if ($('input[name="ReturnTime"]').val().replace(/^\s*|\s*$/g,'')==''){
    1301. 

  1301. 				alert(" ()    ");
    1302. 

  1302. 				$('input[name="ReturnTime"]').focus();
    1303. 

  1303. 				//$("input#Submit").prop("disabled",true);
    1304. 

  1304. 				return false;
    1305. 

  1305. 			} else if ($('input[name="OrderTitle"]').val().replace(/^\s*|\s*$/g,'')==''){
    1306. 

  1306. 				alert("      ");
    1307. 

  1307. 				$('input[name="OrderTitle"]').focus();
    1308. 

  1308. 				//$("input#Submit").prop("disabled",true);
    1309. 

  1309. 				return false;
    1310. 

  1310. 			} else {
    1311. 

  1311. 				return makeOutXML();
    1312. 

  1312. 			} 
    1313. 

  1313. 		}
    1314. 

  1314. 		TransformXmlURL("/service/xml_getOrderProperty.asp?act=getProperty&type=<%=orderTypeID%>","/xsl/orderEditProperty.xsl", function(result){
    1315. 

  1315. 			$("#orderDetails").html(result);	
    1316. 

  1316. 			readyForm();
    1317. 

  1317. 		});
    1318. 

  1318. 		TransformXmlURL("/service/xml_getOrderProperty.asp?act=getNew&isOrder=&typeID=<%=orderTypeID%>&id=<%=CustomerID%>","/xsl/orderEditHeader.xsl", function(result){
    1319. 

  1319. 			$("#orderHeader").html(result);	
    1320. 

  1320. 		});
    1321. 

  1321. 	</script>
    1322. 

  1322. 		
    1323. 

  1323. 

  1324. 	<br>
    1325. 

  1325. 	<div dir='rtl'><B>  :  </B>
    1326. 

  1326. 	</div>
    1327. 

  1327. 	<br>
    1328. 

  1328. <!--   -->
    1329. 

  1329. 	<hr>
    1330. 

  1330. 	<FORM METHOD=POST ACTION="?act=submitQuote" onSubmit="return checkValidation();">
    1331. 

  1331. 		<div id="orderHeader"></div>
    1332. 

  1332. 		<div class="downBtn">
    1333. 

  1333. 			<hr/>
    1334. 

  1334. 			<INPUT TYPE="submit" id='Submit' Name="Submit" Value="" style="width:100px;" tabIndex="14">
    1335. 

  1335. 			<INPUT TYPE="button" Name="Cancel" Value="" style="width:100px;" onClick="window.location='Inquiry.asp';" tabIndex="15">
    1336. 

  1336. 		</div>
    1337. 

  1337. 	</FORM>
    1338. 

  1338. 	<div id='orderDetails'></div>
    1339. 

  1339. <%
    1340. 

  1340. 	set orderProp=nothing
    1341. 

  1341. elseif Request.QueryString("act")="submitQuote" then
    1342. 

  1342. 	//-------------------------------------------------------…
    1343.