API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 76.06 KB | None | 0 0
raw download clone embed print report
  1.  
  2. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  3.  
  4. <html>
  5. <head>
  6. <title>Artnet</title>
  7. <style type="text/css">
  8. .prv_td{
  9.  
  10. width: 250px;
  11. }
  12. .desc{
  13. display: block; /* Fallback for non-webkit */
  14. display: -webkit-box;
  15. width: 200px;
  16. height: auto; /* Fallback for non-webkit */
  17.  
  18. font-size: 12px;
  19. line-height: 1.4;
  20. -webkit-line-clamp: 3;
  21. -webkit-box-orient: vertical;
  22. overflow: hidden;
  23. text-overflow: ellipsis;
  24. }
  25. .desctd{
  26.  
  27. height: 50px;
  28. }
  29. </style>
  30. </head>
  31.  
  32. <body>
  33. <!--- useoracle --->
  34.  
  35. <!--- <cfquery name="ajde" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  36. insert into comp_aliases (comp_id_comp,comp_alias) values ('swdeveloper4','3')
  37. </cfquery> --->
  38.  
  39. <cfparam name="url.mod" default="12">
  40.  
  41. <cfif view neq "3">
  42. <cfinclude template="dbtasks.cfm">
  43. </cfif>
  44. <!--- <cfdump var="#qtasks#"> --->
  45. <cfinclude template="../mod19/statuses_colors.cfm">
  46.  
  47. <cfif 19 eq '#url.mod#'>
  48. <cfset MyTasks='on'>
  49. </cfif>
  50.  
  51. <cfif isdefined("show_task_activities") and show_task_activities eq 1>
  52. <cfoutput>
  53.  
  54. <cfif view neq 3 and qtasks.recordcount neq 0>
  55.  
  56. <cfif application.useoracle eq 1>
  57. <cfquery name="quserroles" dbtype="query">
  58. select distinct username,id_role,role,username_def, pro_id_project
  59. from qtasks
  60. order by role,username
  61. </cfquery>
  62. <cfelse>
  63. <cfquery name="quserroles" dbtype="query">
  64. select distinct username,id_role,role,username_def, pro_id_project
  65. from qtasks
  66. order by role,username
  67. </cfquery>
  68. </cfif>
  69.  
  70.  
  71. <!--- <cfdump var="#quserroles#"> --->
  72. <cfloop query="quserroles">
  73. <cfset url.id_proj = quserroles.pro_id_project>
  74. <cfinclude template="../mod19/dbgetbosses.cfm">
  75. <cfset bossids = listToArray("#valuelist(bosses.olice,',')#",",")>
  76. <cfset bossids2 = listToArray("#valuelist(bosses.flice,',')#",",")>
  77. <cfif arraycontains(bossids,session.id_user)>
  78. <!--- sem e dali korisnikot e odgovorno lice na nekoj roditel proekt --->
  79. <cfset sem = 1>
  80. <cfelse>
  81. <cfset sem = 0>
  82. </cfif>
  83. <cfif arraycontains(bossids2,session.id_user)>
  84. <!--- sem2 e dali korisnikot e finansiski menadzer na nekoj roditel proekt --->
  85. <cfset sem2 = 1>
  86. <cfelse>
  87. <cfset sem2 = 0>
  88. </cfif>
  89. <cfquery name="resbossescheck" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  90. select pr.username
  91. from project_resources pr
  92. where pr.comp_id_comp = '#client.idcomp#'
  93. and pr.id_project_resource in (<cfqueryparam value="#valueList(resbosses.id_project_resource, ',')#" list="true" cfsqltype="cf_sql_integer">)
  94. and exists (
  95. select prr.username from project_resources prr
  96. where prr.id_project_resource = pr.id_project_resource
  97. and prr.username = '#quserroles.username#'
  98. )
  99. and (
  100. pr.tim_leader = '#session.id_user#'
  101. or
  102. pr.financial_manager='#session.id_user#'
  103. )
  104. </cfquery>
  105. <!--- <cfdump var="#resbossescheck#"> --->
  106. <cfif sem or sem2 or quserroles.username eq session.id_user or quserroles.username_def eq session.id_user or resbossescheck.recordcount>
  107.  
  108. <cfif application.useoracle eq 1>
  109. <cfquery name="qtasksactivities" dbtype="query">
  110. select *
  111. from qtasks
  112. where username='#username#'
  113. and id_role=#id_role#
  114. and role='#quserroles.role#'
  115. </cfquery>
  116. <cfelse>
  117. <cfquery name="qtasksactivities" dbtype="query">
  118. select *
  119. from qtasks
  120. where username='#username#'
  121. and id_role=#id_role#
  122. and role='#quserroles.role#'
  123. </cfquery>
  124. </cfif>
  125.  
  126.  
  127. <!--- <cfdump var="#qtasksactivities#"> --->
  128. <h4>#username#<cfif session.restrictions neq 1>,&nbsp;#quserroles.role#</cfif></h4><br>
  129.  
  130. <table class="grid2" id="project_table_2" <cfif view neq "2">style="display:none"</cfif>>
  131. <thead>
  132. <tr>
  133. <!--- <th>
  134. ##
  135. </th>
  136. <th>
  137. id
  138. </th> --->
  139. <!--- <th>
  140. #label('04174')#
  141. </th> --->
  142. <th>
  143. #label('12003')#
  144. </th>
  145. <th>
  146. #label('00279')#
  147. </th>
  148. <th>
  149. #label('04263')#
  150. </th>
  151. <th>
  152. #label('04248')#
  153. </th>
  154. <th>
  155. #label('04254')#
  156. </th>
  157. <cfif view_type eq 1 and session.restrictions neq 1>
  158. <th>
  159. #label('04269')#
  160. </th>
  161. </cfif>
  162. <th>Defined by</th>
  163. <th style="display:none;">
  164. #label('00300')#
  165. </th>
  166.  
  167. <th>
  168. #label('00301')#
  169. </th>
  170. <th style="display:none;">
  171. #label('00302')#
  172. </th>
  173. <th>
  174. #label('04239')#
  175. </th>
  176. <th>
  177. #label('04242')#
  178. </th>
  179. <!--- <th>
  180. #label('04266')#
  181. </th> --->
  182. <cfif session.restrictions neq 1>
  183. <!--- <th>
  184. #label('04246')#
  185. </th> --->
  186. <th>
  187. #label('04247')#
  188. </th>
  189. </cfif>
  190. </tr>
  191. </thead>
  192. <tbody>
  193. <cfset no_task=0>
  194. <cfquery name="get_task_resource" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  195. select *
  196. from tasks t, task_resources tr
  197. where t.id_task='#qtasks.id_task#' and tr.id_task='#qtasks.id_task#' and t.acc_comp_id_comp='#client.idcomp#' and tr.comp_id_comp='#client.idcomp#'
  198. </cfquery>
  199. <cfloop query="qtasksactivities">
  200. <cfset no_task++>
  201. <!--- <cfset username=project_manager> --->
  202. <cfinclude template="../mod07/dbselaccount.cfm">
  203. <!--- <cfinclude template="../mod22/dbselectplans.cfm"> --->
  204. <!--- <cfdump var="#qselectplans#"> --->
  205. <cfsavecontent variable="desc">
  206. <cfif view_type eq 2>
  207. <cfif tsk_short_desc neq "">#tsk_short_desc##chr(10)#</cfif>
  208. #diff_comment#
  209. <cfelse>
  210. <cfif activity_long_desc neq "">#activity_long_desc##chr(10)#</cfif>
  211. #activity_comment_desc#
  212. </cfif>
  213. </cfsavecontent>
  214. <cfif view_type eq 2>
  215. <cfset tsk_name=task_name>
  216. <cfset s_date=date_assign>
  217. <cfset e_date=date_end_planned>
  218. <cfset addquerystring="mod=12&wherecolumn=&wherevalue=&whereoper=&firstrow=1&rowsonpage=20&lstorder=date_assign,id_task,name,name,name,id_task,id_task,prt_id_prior,user_def,creator,date_def,date_end_planned,date_end_planned,name,id_task,id_task,name,creator,user_assigned,efford_left,efford_used,percent,date_assign,date_end_planned,creator,user_assigned,efford_left,id_task,name,name,user_assigned&lstdirect=desc,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&type=edit&viewtype=2&previousfilter=&id_task=#id_task#">
  219. <cfelse>
  220. <cfset tsk_name=activity_name>
  221. <cfset s_date=start_d>
  222. <cfset e_date=end_d>
  223. <cfset addquerystring="activities=1&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#">
  224. </cfif>
  225. <cfinclude template="dbstatuses.cfm">
  226. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  227. select ts.label_#client.lang# as status, ts.id_status, ts.color
  228. from task_statuses ts, tasks t
  229. where t.tskstat_id_task_status=ts.id_status
  230. and t.id_task='#id_task#'
  231. </cfquery>
  232.  
  233. <tr>
  234. <td style="display:none">
  235. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  236. #reden_broj#
  237. </a>
  238. </td>
  239.  
  240. <!--- <td>
  241. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  242. #reden_broj#
  243. </a>
  244. </td> --->
  245.  
  246. <td style="display:none">
  247. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  248. #id_task#
  249. </a>
  250. </td>
  251. <td>
  252. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  253. #tsk_name#
  254. <cfif view_type eq 2>
  255. <cfinclude template="dbtaskchildren.cfm">
  256. <cfif qseltaskactivities.recordcount neq 0>
  257. <a href="##" id="more_#id_task#" style="margin-left:4px;" onclick="document.getElementById('less_#id_task#').style.display='';document.getElementById('more_#id_task#').style.display='none';document.getElementById('subtasks_tr_#id_task#').style.display='';ColdFusion.navigate('mod12/childrenpanel.cfm?mod=#url.mod#&task_id=#id_task#', 'subtasks_#id_task#', '','','post','frm_search');">
  258. &raquo;
  259. </a>
  260. <a href="##" id="less_#id_task#" style="margin-left:4px;display:none" onclick="document.getElementById('subtasks_tr_#id_task#').style.display='none';document.getElementById('more_#id_task#').style.display='';document.getElementById('less_#id_task#').style.display='none';">
  261. &laquo;
  262. </a>
  263. </cfif>
  264. </cfif>
  265. </a>
  266. </td>
  267. <td>
  268. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  269. #activity_description#
  270. </a>
  271. </td>
  272. <td>
  273. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  274. #project_name#
  275. </a>
  276. </td>
  277.  
  278. <td>
  279. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  280. #task_status.status#
  281.  
  282. </a>
  283. </td>
  284. <td>
  285. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  286. <!--- blagoj: ova go promeniv vo username --->
  287. <!--- #get_task_resource.username# --->
  288. #username#
  289. </a>
  290. </td>
  291. <td>
  292. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  293.  
  294. #get_task_resource.acc_username_def#
  295.  
  296. </a>
  297. </td>
  298. <cfif view_type eq 1 and session.restrictions neq 1>
  299. <td>
  300. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  301. #task_type#
  302. </a>
  303. </td>
  304. </cfif>
  305. <td>
  306. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  307. #effort_planned#
  308. </a>
  309. </td>
  310. <td style="display:none;">
  311. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  312. #effort_used#
  313. </a>
  314. </td>
  315. <td style="display:none;">
  316. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  317. #effort_left#
  318. </a>
  319. </td>
  320. <td>
  321. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  322. #s_date#
  323. </a>
  324. </td>
  325. <td>
  326. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  327. #e_date#
  328. </a>
  329. </td>
  330. <cfif session.restrictions neq 1>
  331. <td style="display:none">
  332. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  333. #client_comp#
  334. </a>
  335. </td>
  336. <td>
  337. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  338. #priority#
  339. </a>
  340. </td>
  341. </cfif>
  342. </tr>
  343. <cfif view_type eq 2 and qseltaskactivities.recordcount neq 0>
  344. <tr style="display:none"></tr>
  345. <tr style="display:none" id="subtasks_tr_#id_task#">
  346. <td style="background-color:white">
  347. </td>
  348. <td style="padding:0;margin:0;background-color:white" colspan="13">
  349. <div id="subtasks_#id_task#">
  350. </div>
  351. </td>
  352. </tr>
  353. </cfif>
  354. </cfloop>
  355. </tbody>
  356. </table>
  357. <br>
  358. </cfif>
  359. </cfloop>
  360. <!--- <cfdump var="#quserroles#"> --->
  361. <cfelse>
  362. #label('04173')#
  363. </cfif>
  364. </cfoutput>
  365. <cfelse>
  366. <cfoutput>
  367. <cfif view neq 3 and qtasks.recordcount neq 0>
  368. <cfif view eq 1>
  369. <div id="project_table_1" <cfif view neq "1">style="display:none;overflow:auto;"</cfif>>
  370. <!--- <table style="width:100%"> --->
  371. <cfset no_task=0>
  372. <cfloop query="qtasks">
  373. <cfquery name="get_task_resource" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  374. select *
  375. from tasks t, task_resources tr
  376. where t.id_task='#qtasks.id_task#' and tr.id_task='#qtasks.id_task#' and t.acc_comp_id_comp='#client.idcomp#' and tr.comp_id_comp='#client.idcomp#'
  377. </cfquery>
  378. <cfset no_task++>
  379. <cfif no_task%4 eq 1>
  380. <!--- <tr> --->
  381. </cfif>
  382. <!--- <td valign="top"> --->
  383. <!--- <cfset username=project_manager> --->
  384. <cfinclude template="../mod07/dbselaccount.cfm">
  385. <!--- <cfinclude template="../mod22/dbselectplans.cfm"> --->
  386. <!--- <cfdump var="#qselectplans#"> --->
  387. <cfsavecontent variable="desc">
  388. <cfif view_type eq 2>
  389. <cfif tsk_short_desc neq "">#tsk_short_desc##chr(10)#</cfif>
  390. #diff_comment#
  391. <cfelse>
  392. <cfif activity_long_desc neq "">#activity_long_desc##chr(10)#</cfif>
  393. #activity_comment_desc#
  394. </cfif>
  395. </cfsavecontent>
  396. <cfif view_type eq 2>
  397. <cfset tsk_name=task_name>
  398. <cfset s_date=date_assign>
  399. <cfset e_date=date_end_planned>
  400. <cfset addquerystring="mod=12&wherecolumn=&wherevalue=&whereoper=&firstrow=1&rowsonpage=20&lstorder=date_assign,id_task,name,name,name,id_task,id_task,prt_id_prior,user_def,creator,date_def,date_end_planned,date_end_planned,name,id_task,id_task,name,creator,user_assigned,efford_left,efford_used,percent,date_assign,date_end_planned,creator,user_assigned,efford_left,id_task,name,name,user_assigned&lstdirect=desc,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&type=edit&viewtype=2&previousfilter=">
  401. <cfelse>
  402. <cfset tsk_name=activity_name>
  403. <cfset s_date=start_d>
  404. <cfset e_date=end_d>
  405. <cfset addquerystring="activities=1">
  406. </cfif>
  407. <cfif id_status eq 1>
  408. <cfset color_sts="f9dc60">
  409. <cfelseif id_status eq 3>
  410. <cfset color_sts="e8483f">
  411. <cfelseif id_status eq 6>
  412. <cfset color_sts="a9ca6f">
  413. </cfif>
  414. <cfinclude template="dbstatuses.cfm">
  415. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  416. select ts.label_#client.lang# as status, ts.id_status, ts.color
  417. from task_statuses ts, tasks t
  418. where t.tskstat_id_task_status=ts.id_status
  419. and t.id_task='#id_task#'
  420. </cfquery>
  421. <cfset color_sts=task_status.color>
  422. <!--- <cfoutput>#color_sts#</cfoutput> --->
  423. <cfif id_status eq 1>
  424. <cfinclude template="dbCompareDates.cfm">
  425. <cfif qDatesCompare.compare eq 0>
  426. <cfset color_sts="6693b0">
  427. </cfif>
  428. </cfif>
  429. <table class="frm1" style="float:left;width:270px;height:250px;margin:5px;" >
  430. <cfif MyTasks eq 'on'>
  431.  
  432.  
  433. <cfif get_task_resource.username eq #session.id_user#>
  434. <tr>
  435. <cfif color_sts neq "">
  436.  
  437. <th class="horizontal" style="border-top:5px solid ###color_sts#;">
  438. <cfelse>
  439. <th class="horizontal">
  440. </cfif>
  441.  
  442. <!--- <div class="table_color1"></div> --->
  443. <cfif view_type eq 2>
  444. <a href="frm_main.cfm?#addquerystring#&id_task=#id_task#" <cfif Trim(desc) neq ""> title="#tsk_name##chr(10)##desc#" </cfif>>#mid(tsk_name,1,35)#<cfif len(tsk_name) gt 35>...</cfif></a>
  445. <cfelse>
  446. <a href="frm_main.cfm?#addquerystring#&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#" <cfif Trim(desc) neq "">title="#tsk_name##chr(10)##desc#"</cfif>>#mid(tsk_name,1,35)#<cfif len(tsk_name) gt 35>...</cfif></a>
  447. </cfif>
  448. <!--- #id_status# --->
  449. <cfif view_type eq 2>
  450. <cfinclude template="dbtaskchildren.cfm">
  451. <cfif qseltaskactivities.recordcount neq 0>
  452. <a href="##" id="children_#id_task#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';$('##childrenpanel').load('mod12/childrenpanel.cfm?mod=12&task_id=#id_task#&view=#view#');">
  453.  
  454. &raquo;
  455. </a>
  456. </cfif>
  457. </cfif>
  458. <!--- <cfif qchildrenprojects.recordcount neq 0>
  459. <a href="##" id="children_#id_project#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';document.getElementById('parent_project').value='#id_project#';ColdFusion.navigate('mod19/childrenpanel.cfm?mod=19', 'childrenpanel', '','','post','frm_search');">
  460. &raquo;
  461. </a>
  462. </cfif> --->
  463. <p>
  464. #label('04240')#
  465. #get_task_resource.username#
  466. (&nbsp;#s_date#-#e_date#&nbsp;),&nbsp;#project_name#
  467. </p>
  468. </th>
  469. </tr>
  470. <tr>
  471. <td <cfif Trim(desc) neq "">title="#desc#"</cfif>>
  472. <cfset qlist= querynew("effort,label")>
  473. <cfset i=0>
  474. <cfset i++>
  475. <cfset newrow = queryaddrow(qlist,1)>
  476. <cfset temp = querysetcell(qlist, "effort", "#effort_planned#",#i#)>
  477. <cfset temp = querysetcell(qlist, "label", "#label('00300')#",#i#)>
  478. <cfset i++>
  479. <cfset newrow = queryaddrow(qlist,1)>
  480. <cfset temp = querysetcell(qlist, "effort", "#effort_used#",#i#)>
  481. <cfset temp = querysetcell(qlist, "label", "#label('00301')#",#i#)>
  482. <cfset i++>
  483. <cfset newrow = queryaddrow(qlist,1)>
  484. <cfset temp = querysetcell(qlist, "effort", "#effort_left#",#i#)>
  485. <cfset temp = querysetcell(qlist, "label", "#label('00302')#",#i#)>
  486. <!--- <a href="##" style="float:right" onclick="document.getElementById('percent_#id_project#').style.display='';document.getElementById('time_#id_project#').style.display='none';">
  487. %
  488. </a> --->
  489.  
  490. <cfchart format="png" font = "arial" labelformat="number" pieslicestyle = "sliced"
  491. show3d = "yes" chartheight="90" chartwidth="250"
  492. foregroundcolor="999999">
  493.  
  494. <cfchartseries type="bar" paintstyle="light"
  495. query="qlist"
  496. itemcolumn="label"
  497. valuecolumn="effort" colorlist="##75b000,##6693b0,##e48701">
  498. </cfchartseries>
  499. </cfchart>
  500.  
  501. </td>
  502. </tr>
  503. <cfif view_type eq 2>
  504. <tr>
  505. <td class="small">
  506. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=3">#label('12077')#</a>&nbsp;|
  507. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4">#label('12093')#</a>&nbsp;|
  508. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4&inssubtask=1">#label('04273')#</a>
  509. </td>
  510. </tr>
  511. </cfif>
  512. <!--- <tr>
  513. <td class="small">
  514. <a href="frm_main.cfm?mod=22&id_project=#id_project#&type=edit&plan_type=#plan_type#&date_from=#date_from#&date_to=#date_to#">#label('04257')#</a>&nbsp;|&nbsp;
  515. <cfif qselectplans.id_plan neq "">
  516. <a href="frm_main.cfm?mod=22&id_plan=#qselectplans.id_plan#&type=edit">#label('04258')#</a>&nbsp;|&nbsp;
  517. </cfif>
  518. <a href="frm_main.cfm?mod=#url.mod#&nad_proj=#id_project#">#label('04259')#</a>&nbsp;|&nbsp;
  519. <a href="frm_main.cfm?mod=12&nad_task=#id_project#">#label('12017')#</a>
  520.  
  521. </td>
  522. </tr>
  523. <tr>
  524. <td class="small">
  525. <a href="frm_main.cfm?mod=21&wherecolumn=&wherevalue=&whereoper=&firstrow=1&rowsonpage=20&lstorder=post_date&lstdirect=desc&sbminstask=1&projects=#id_project#">#label('21001')#</a>&nbsp;|&nbsp;
  526. <a href="frm_main.cfm?#addquerystring#&type=edit&viewtype=4&id_proj=#id_project#&tab=3">#label('04256')#</a>&nbsp;|&nbsp;
  527. <a href="frm_main.cfm?#addquerystring#&type=edit&viewtype=4&id_proj=#id_project#&tab=2">#label('04248')#</a>&nbsp;|&nbsp;
  528. <a href="frm_main.cfm?#addquerystring#&type=edit&viewtype=4&id_proj=#id_project#&tab=4">#label('04260')#</a>
  529. </td>
  530. </tr> --->
  531. </cfif>
  532. <cfelse>
  533. <tr>
  534. <cfif color_sts neq "">
  535.  
  536. <th class="horizontal" style="border-top:5px solid ###color_sts#;">
  537. <cfelse>
  538. <th class="horizontal">
  539. </cfif>
  540.  
  541. <!--- <div class="table_color1"></div> --->
  542. <cfif view_type eq 2>
  543. <a href="frm_main.cfm?#addquerystring#&id_task=#id_task#" <cfif Trim(desc) neq ""> title="#tsk_name##chr(10)##desc#" </cfif>>#mid(tsk_name,1,35)#<cfif len(tsk_name) gt 35>...</cfif></a>
  544. <cfelse>
  545. <a href="frm_main.cfm?#addquerystring#&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#" <cfif Trim(desc) neq "">title="#tsk_name##chr(10)##desc#"</cfif>>#mid(tsk_name,1,35)#<cfif len(tsk_name) gt 35>...</cfif></a>
  546. </cfif>
  547. <!--- #id_status# --->
  548. <cfif view_type eq 2>
  549. <cfinclude template="dbtaskchildren.cfm">
  550. <cfif qseltaskactivities.recordcount neq 0>
  551. <a href="##" id="children_#id_task#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';$('##childrenpanel').load('mod12/childrenpanel.cfm?mod=12&task_id=#id_task#&view=#view#');">
  552.  
  553. &raquo;
  554. </a>
  555. </cfif>
  556. </cfif>
  557. <!--- <cfif qchildrenprojects.recordcount neq 0>
  558. <a href="##" id="children_#id_project#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';document.getElementById('parent_project').value='#id_project#';ColdFusion.navigate('mod19/childrenpanel.cfm?mod=19', 'childrenpanel', '','','post','frm_search');">
  559. &raquo;
  560. </a>
  561. </cfif> --->
  562. <p>
  563. #label('04240')#
  564. #get_task_resource.username#
  565. (&nbsp;#s_date#-#e_date#&nbsp;),&nbsp;#project_name#
  566. </p>
  567. </th>
  568. </tr>
  569. <tr>
  570. <td <cfif Trim(desc) neq "">title="#desc#"</cfif>>
  571. <cfset qlist= querynew("effort,label")>
  572. <cfset i=0>
  573. <cfset i++>
  574. <cfset newrow = queryaddrow(qlist,1)>
  575. <cfset temp = querysetcell(qlist, "effort", "#effort_planned#",#i#)>
  576. <cfset temp = querysetcell(qlist, "label", "#label('00300')#",#i#)>
  577. <cfset i++>
  578. <cfset newrow = queryaddrow(qlist,1)>
  579. <cfset temp = querysetcell(qlist, "effort", "#effort_used#",#i#)>
  580. <cfset temp = querysetcell(qlist, "label", "#label('00301')#",#i#)>
  581. <cfset i++>
  582. <cfset newrow = queryaddrow(qlist,1)>
  583. <cfset temp = querysetcell(qlist, "effort", "#effort_left#",#i#)>
  584. <cfset temp = querysetcell(qlist, "label", "#label('00302')#",#i#)>
  585. <!--- <a href="##" style="float:right" onclick="document.getElementById('percent_#id_project#').style.display='';document.getElementById('time_#id_project#').style.display='none';">
  586. %
  587. </a> --->
  588.  
  589. <cfchart format="png" font = "arial" labelformat="number" pieslicestyle = "sliced"
  590. show3d = "yes" chartheight="90" chartwidth="250"
  591. foregroundcolor="999999">
  592.  
  593. <cfchartseries type="bar" paintstyle="light"
  594. query="qlist"
  595. itemcolumn="label"
  596. valuecolumn="effort" colorlist="##75b000,##6693b0,##e48701">
  597. </cfchartseries>
  598. </cfchart>
  599.  
  600. </td>
  601. </tr>
  602. <cfif view_type eq 2>
  603. <tr>
  604. <td class="small">
  605. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=3">#label('12077')#</a>&nbsp;|
  606. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4">#label('12093')#</a>&nbsp;|
  607. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4&inssubtask=1">#label('04273')#</a>
  608. </td>
  609. </tr>
  610. </cfif>
  611. </cfif>
  612.  
  613. </table>
  614. <!--- </td> --->
  615. <cfif no_task%4 eq 0>
  616. <!--- </tr> --->
  617. </cfif>
  618. </cfloop>
  619. <!--- </table> --->
  620. <div class="clear"></div>
  621. </div>
  622. </cfif>
  623. <cfif view eq 2>
  624. <!--- ako e grupirano bez kriteriumi --->
  625. <cfif group_by eq "">
  626. <table class="grid2" id="project_table_2" <cfif view neq "2">style="display:none"</cfif>>
  627. <thead>
  628. <tr>
  629. <th style="display:none">
  630. ##
  631. </th>
  632. <th>
  633. ##
  634. </th>
  635. <cfif view_type neq 2>
  636. <th>
  637. #label('04174')#
  638. </th>
  639. </cfif>
  640. <th class="prv_td">
  641. #label('04236')#
  642. </th>
  643. <th class="prv_td">
  644. Description
  645. </th>
  646. <th>
  647. #label('04263')#
  648. </th>
  649. <th>
  650. #label('04248')#
  651. </th>
  652.  
  653. <th>
  654. <cfif view_type eq 1>
  655. #label('04254')#
  656. <cfelse>
  657. #label('04254')#
  658. </cfif>
  659. </th>
  660. <th>Defined by</th>
  661. <cfif view_type eq 1 and session.restrictions neq 1>
  662. <th>
  663. #label('04269')#
  664. </th>
  665. </cfif>
  666. <!--- <cfif view_type eq 1>
  667. <th>
  668. #label('12153')#
  669. </th>
  670. </cfif> --->
  671.  
  672.  
  673. <th>
  674. #label('00300')#
  675. </th>
  676. <th>
  677. #label('00301')#
  678. </th>
  679. <th>
  680. #label('00302')#
  681. </th>
  682. <th>
  683. #label('04239')#
  684. </th>
  685. <th>
  686. #label('04242')#
  687. </th>
  688. <!--- <th>
  689. #label('04266')#
  690. </th> --->
  691. <cfif session.restrictions neq 1>
  692. <th style="display:none">
  693. #label('04246')#
  694. </th>
  695. <th>
  696. #label('04247')#
  697. </th>
  698. </cfif>
  699. <!--- <cfif view_type eq 2>
  700. <th>
  701. #label('00127')#
  702. </th>
  703. </cfif> --->
  704. </tr>
  705. </thead>
  706. <tbody>
  707.  
  708. <cfset no_task=0>
  709. <cfloop query="qtasks">
  710. <cfquery name="task_planned_tim" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  711. select sum(effort_planned) as planirano
  712. from task_resources
  713. where comp_id_comp = '#client.idcomp#'
  714. and id_task='#qtasks.id_task#'
  715. </cfquery>
  716. <cfset planirano_vrem='#task_planned_tim.planirano#'>
  717. <cfif planirano_vrem eq ''>
  718. <cfset planirano_vrem=0>
  719. </cfif>
  720. <cfquery name="get_task_resource" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  721. select *
  722. from tasks t, task_resources tr
  723. where t.id_task='#qtasks.id_task#' and tr.id_task='#qtasks.id_task#' and t.acc_comp_id_comp='#client.idcomp#' and tr.comp_id_comp='#client.idcomp#'
  724. </cfquery>
  725. <cfset no_task++>
  726. <!--- <cfset username=project_manager> --->
  727. <!--- <cfinclude template="../mod07/dbselaccount.cfm"> --->
  728. <!--- <cfinclude template="../mod22/dbselectplans.cfm"> --->
  729. <!--- <cfdump var="#qselectplans#"> --->
  730. <cfsavecontent variable="desc">
  731. <cfif view_type eq 2>
  732. <cfif tsk_short_desc neq "">#tsk_short_desc##chr(10)#</cfif>
  733. #diff_comment#
  734. <cfelse>
  735. <cfif activity_long_desc neq "">#activity_long_desc##chr(10)#</cfif>
  736. #activity_comment_desc#
  737. </cfif>
  738. </cfsavecontent>
  739. <cfif view_type eq 2>
  740. <cfset tsk_name=task_name>
  741. <cfset s_date=date_assign>
  742. <cfset e_date=date_end_planned>
  743. <cfset addquerystring="mod=12&wherecolumn=&wherevalue=&whereoper=&firstrow=1&rowsonpage=20&lstorder=date_assign,id_task,name,name,name,id_task,id_task,prt_id_prior,user_def,creator,date_def,date_end_planned,date_end_planned,name,id_task,id_task,name,creator,user_assigned,efford_left,efford_used,percent,date_assign,date_end_planned,creator,user_assigned,efford_left,id_task,name,name,user_assigned&lstdirect=desc,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&type=edit&viewtype=2&previousfilter=&id_task=#id_task#">
  744. <cfelse>
  745. <cfset tsk_name=activity_name>
  746. <cfset s_date=start_d>
  747. <cfset e_date=end_d>
  748. <cfset addquerystring="activities=1&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#">
  749. </cfif>
  750. <cfinclude template="dbstatuses.cfm">
  751. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  752. select ts.label_#client.lang# as status, ts.id_status, ts.color
  753. from task_statuses ts, tasks t
  754. where t.tskstat_id_task_status=ts.id_status
  755. and t.id_task='#id_task#'
  756. </cfquery>
  757. <cfif MyTasks eq 'on'>
  758.  
  759. <cfif get_task_resource.username eq #session.id_user#>
  760.  
  761.  
  762. <tr>
  763. <td style="display:none">
  764. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  765. #reden_broj#
  766. </a>
  767. </td>
  768.  
  769. <td>
  770. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  771. #id_task#
  772. </a>
  773. </td>
  774. <cfif view_type neq 2>
  775. <td>
  776. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  777. <input type="checkbox" <cfif id_status eq "6"> checked disabled="true"</cfif>name="close_activity_#no_task#" id="close_activity_#no_task#" >
  778. <input type="hidden" style="width:70px" name="id_task_#no_task#" id="id_task_#no_task#" value="#id_task#" maxlength="10" class="gen_input" >
  779. <input type="hidden" style="width:70px" name="id_activity_#no_task#" id="id_activity_#no_task#" value="#id_task_res_pl_activity#" maxlength="10" class="gen_input" >
  780. <input type="hidden" style="width:70px" name="id_task_resource_#no_task#" id="id_task_resource_#no_task#" value="#id_task_resource#" MAXLENGTH="10" CLASS="gen_input" >
  781. <input type="hidden" style="width:70px" name="task_name_#no_task#" id="task_name_#no_task#" value="#tsk_name#" maxlength="10" class="gen_input" >
  782.  
  783. </a>
  784. </td>
  785. </cfif>
  786. <td>
  787. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  788. #tsk_name#
  789. <!---<cfif view_type eq 2>
  790. <cfinclude template="dbtaskchildren.cfm">
  791. <cfif qseltaskactivities.recordcount neq 0>
  792. <a class="bold" href="##" id="more_#id_task#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';$('##childrenpanel').load('mod12/childrenpanel.cfm?mod=12&task_id=#id_task#&view=2&temp_tasks=1');">
  793. &raquo;
  794. </a>
  795. <a class="bold" href="##" id="less_#id_task#" style="margin-left:4px;display:none" onclick="document.getElementById('subtasks_tr_#id_task#').style.display='none';document.getElementById('more_#id_task#').style.display='';document.getElementById('less_#id_task#').style.display='none';">
  796. &laquo;
  797. </a>
  798. </cfif>
  799. </cfif>--->
  800. </a>
  801. </td>
  802. <td class="desctd">
  803. <a class="desc" href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  804. #tsk_short_desc#
  805. </a>
  806. </td>
  807. <td>
  808. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  809. #project_name#
  810. </a>
  811. </td>
  812.  
  813. <td>
  814. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  815. #task_status.status#
  816. <!--- #task_status# --->
  817. </a>
  818. </td>
  819. <td>
  820. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  821. <!--- <cfif accdtls.name neq "">
  822. #accdtls.name#&nbsp;#accdtls.surname#
  823. <cfelse> --->
  824. #get_task_resource.username#
  825.  
  826. <!--- </cfif> --->
  827. </a>
  828. </td>
  829. <td>
  830. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  831.  
  832. #get_task_resource.acc_username_def#
  833.  
  834. </a>
  835. </td>
  836. <cfif view_type eq 1>
  837. <cfif session.restrictions neq 1>
  838. <td>
  839. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  840. #task_type#
  841. </a>
  842. </td>
  843. </cfif>
  844. <td>
  845. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  846. #planirano_vrem#
  847. </a>
  848. </td>
  849. <td>
  850. <!--- <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#"> --->
  851. <input type="text" style="width:70px" name="effort_used_#no_task#" id="effort_used_#no_task#" value="#effort_used#" maxlength="10" class="gen_input" readonly >
  852. <!--- </a> --->
  853. </td>
  854. <td>
  855. <!--<a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">-->
  856. <input type="text" style="width:70px" name="effort_left_#no_task#" id="effort_left_#no_task#" value="#effort_left#" maxlength="10" class="gen_input" readonly >
  857. <!--- #effort_left# --->
  858. </a>
  859. </td>
  860. <cfelse>
  861. <td>
  862. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  863. #planirano_vrem#
  864. </a>
  865. </td>
  866. <td>
  867. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  868. #effort_planned#
  869. </a>
  870. </td>
  871. <cfset ostanato=#planirano_vrem#-#effort_planned#>
  872. <td>
  873. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  874. #ostanato#
  875. </a>
  876. </td>
  877. </cfif>
  878.  
  879. <td>
  880. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  881. #s_date#
  882. </a>
  883. </td>
  884. <td>
  885. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  886. #e_date#
  887. </a>
  888. </td>
  889. <cfif session.restrictions neq 1>
  890. <td style="display:none">
  891. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  892. #client_comp#
  893. </a>
  894. </td>
  895. <td>
  896. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  897. #priority#
  898. </a>
  899. </td>
  900. </cfif>
  901. <!--- <cfif view_type eq 2>
  902. <td class="small">
  903. <div style="width:100%;border-bottom:1px dashed ##999;padding-bottom:2px;margin-bottom:1px;">
  904. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=3">#label('12077')#</a>&nbsp;|
  905. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=4">#label('12093')#</a>
  906. </div>
  907. <div style="width:100%;">
  908. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=4&inssubtask=1">#label('04273')#</a>
  909. </div>
  910. </td>
  911. </cfif> --->
  912. </tr>
  913. <!--- <cfif view_type eq 2 and qseltaskactivities.recordcount neq 0>
  914. <tr style="display:none"></tr>
  915. <tr style="display:none" id="subtasks_tr_#id_task#">
  916. <td style="background-color:white">
  917. </td>
  918. <td style="padding:0;margin:0;background-color:white" colspan="14">
  919. <div id="subtasks_#id_task#">
  920. </div>
  921. </td>
  922. </tr>
  923. </cfif> --->
  924. </cfif>
  925. <cfelse>
  926. <tr>
  927. <td style="display:none">
  928. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  929. #reden_broj#
  930. </a>
  931. </td>
  932.  
  933. <td>
  934. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  935. #id_task#
  936. </a>
  937. </td>
  938. <!--- <cfif view_type neq 2>
  939. <td>
  940. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  941. <input type="checkbox" <cfif id_status eq "6"> checked disabled="true"</cfif>name="close_activity_#no_task#" id="close_activity_#no_task#" >
  942. <input type="hidden" style="width:70px" name="id_task_#no_task#" id="id_task_#no_task#" value="#id_task#" maxlength="10" class="gen_input" >
  943. <input type="hidden" style="width:70px" name="id_activity_#no_task#" id="id_activity_#no_task#" value="#id_task_res_pl_activity#" maxlength="10" class="gen_input" >
  944. <input type="hidden" style="width:70px" name="id_task_resource_#no_task#" id="id_task_resource_#no_task#" value="#id_task_resource#" MAXLENGTH="10" CLASS="gen_input" >
  945. <input type="hidden" style="width:70px" name="task_name_#no_task#" id="task_name_#no_task#" value="#tsk_name#" maxlength="10" class="gen_input" >
  946.  
  947. </a>
  948. </td>
  949. </cfif> --->
  950. <td>
  951. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  952. #tsk_name#
  953. <!---<cfif view_type eq 2>
  954. <cfinclude template="dbtaskchildren.cfm">
  955. <cfif qseltaskactivities.recordcount neq 0>
  956. <a class="bold" href="##" id="more_#id_task#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';$('##childrenpanel').load('mod12/childrenpanel.cfm?mod=12&task_id=#id_task#&view=2&temp_tasks=1');">
  957. &raquo;
  958. </a>
  959. <a class="bold" href="##" id="less_#id_task#" style="margin-left:4px;display:none" onclick="document.getElementById('subtasks_tr_#id_task#').style.display='none';document.getElementById('more_#id_task#').style.display='';document.getElementById('less_#id_task#').style.display='none';">
  960. &laquo;
  961. </a>
  962. </cfif>
  963. </cfif>--->
  964. </a>
  965. </td>
  966.  
  967. <td class="desctd">
  968. <a class="desc" href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  969. #tsk_short_desc#
  970. </a>
  971. </td>
  972. <td>
  973. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  974. #project_name#
  975. </a>
  976. </td>
  977.  
  978. <td>
  979. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  980. #task_status.status#
  981. <!--- #task_status# --->
  982. </a>
  983. </td>
  984. <td>
  985. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  986. <!--- <cfif accdtls.name neq "">
  987. #accdtls.name#&nbsp;#accdtls.surname#
  988. <cfelse> --->
  989. #get_task_resource.username#
  990.  
  991. <!--- </cfif> --->
  992. </a>
  993. </td>
  994. <td>
  995. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  996. <!--- <cfif accdtls.name neq "">
  997. #accdtls.name#&nbsp;#accdtls.surname#
  998. <cfelse> --->
  999. #get_task_resource.acc_username_def#
  1000.  
  1001. <!--- </cfif> --->
  1002. </a>
  1003. </td>
  1004. <cfif view_type eq 1>
  1005. <cfif session.restrictions neq 1>
  1006. <td>
  1007. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1008. #task_type#
  1009. </a>
  1010. </td>
  1011. </cfif>
  1012. <td>
  1013. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1014. #planirano_vrem#
  1015. </a>
  1016. </td>
  1017. <td>
  1018. <!--- <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#"> --->
  1019. <input type="text" style="width:70px" name="effort_used_#no_task#" id="effort_used_#no_task#" value="#effort_used#" maxlength="10" class="gen_input" readonly >
  1020. <!--- </a> --->
  1021. </td>
  1022. <td>
  1023. <!--<a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">-->
  1024. <input type="text" style="width:70px" name="effort_left_#no_task#" id="effort_left_#no_task#" value="#effort_left#" maxlength="10" class="gen_input" readonly >
  1025. <!--- #effort_left# --->
  1026. </a>
  1027. </td>
  1028. <cfelse>
  1029. <td>
  1030. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1031. #planirano_vrem#
  1032. </a>
  1033. </td>
  1034. <td>
  1035. <cfif effort_planned eq ''>
  1036. <cfset realizi=0>
  1037. <cfelse>
  1038. <cfset realizi=0>
  1039. </cfif>
  1040. <cfset realizi=#effort_planned#>
  1041. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1042.  
  1043. #realizi#
  1044. </a>
  1045. </td>
  1046. <cfset ostanato=#planirano_vrem#-#realizi#>
  1047. <td>
  1048. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1049. #ostanato#
  1050. </a>
  1051. </td>
  1052. </cfif>
  1053.  
  1054. <td>
  1055. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1056. #s_date#
  1057. </a>
  1058. </td>
  1059. <td>
  1060. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1061. #e_date#
  1062. </a>
  1063. </td>
  1064. <cfif session.restrictions neq 1>
  1065. <td style="display:none">
  1066. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1067. #client_comp#
  1068. </a>
  1069. </td>
  1070. <td>
  1071. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1072. #priority#
  1073. </a>
  1074. </td>
  1075. </cfif>
  1076. <!--- <cfif view_type eq 2>
  1077. <td class="small">
  1078. <div style="width:100%;border-bottom:1px dashed ##999;padding-bottom:2px;margin-bottom:1px;">
  1079. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=3">#label('12077')#</a>&nbsp;|
  1080. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=4">#label('12093')#</a>
  1081. </div>
  1082. <div style="width:100%;">
  1083. <a class="bold" href="frm_main.cfm?#addquerystring#&tab=4&inssubtask=1">#label('04273')#</a>
  1084. </div>
  1085. </td>
  1086. </cfif> --->
  1087. </tr>
  1088. </cfif>
  1089. </cfloop>
  1090. </tbody>
  1091. </table>
  1092. <cfelse>
  1093.  
  1094. <cfset no_group=0>
  1095. <cfset group_value="">
  1096. <cfset group_label="">
  1097. <cfif group_by eq 1>
  1098. <cfset group_label=label('04263')>
  1099. <cfset group_name="project_name">
  1100. <cfelseif group_by eq 2>
  1101. <cfset group_label=label('04264')>
  1102. <cfset group_name="username">
  1103. <cfelseif group_by eq 3>
  1104. <cfset group_label=label('04248')>
  1105. <cfset group_name="id_status">
  1106. </cfif>
  1107. <cfquery name="sumGroup" dbtype="query">
  1108. select count(*) as count_group, sum(effort_planned) as ep_group,
  1109. sum(effort_used) as eu_group, sum(effort_left) as el_group,
  1110. <cfif group_by eq 1>project_name<cfelseif group_by eq 2>username
  1111. <cfelseif group_by eq 3>id_status</cfif> as group_ime
  1112. from qtasks
  1113. group by #group_name#
  1114. </cfquery>
  1115. <!--- <cfdump var="#sumGroup#"> --->
  1116. <div id="project_table_2" <cfif view neq "2">style="display:none"</cfif>>
  1117. <cfset no_task=0>
  1118. <cfloop query="qtasks">
  1119. <cfquery name="get_task_resource" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1120. select *
  1121. from tasks t, task_resources tr
  1122. where t.id_task='#qtasks.id_task#' and tr.id_task='#qtasks.id_task#' and t.acc_comp_id_comp='#client.idcomp#' and tr.comp_id_comp='#client.idcomp#'
  1123. </cfquery>
  1124. <cfif group_by eq 1>
  1125. <cfset group_compare=project_name>
  1126. <cfelseif group_by eq 2>
  1127. <cfset group_compare=username>
  1128. <cfelseif group_by eq 3>
  1129. <cfset group_compare=id_status>
  1130. </cfif>
  1131. <cfinclude template="dbstatuses.cfm">
  1132. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1133. select ts.label_#client.lang# as status, ts.id_status, ts.color
  1134. from task_statuses ts, tasks t
  1135. where t.tskstat_id_task_status=ts.id_status
  1136. and t.id_task='#id_task#'
  1137. </cfquery>
  1138. <cfif group_compare neq group_value>
  1139. <cfset no_group=0>
  1140. <cfset no_group ++>
  1141. <cfset group_value=group_compare>
  1142. <cfif no_task neq 0>
  1143. </tbody>
  1144. </table>
  1145. </cfif>
  1146.  
  1147. <cfquery name="groupData" dbtype="query">
  1148. select * from sumGroup
  1149. where group_ime='#group_value#'
  1150. </cfquery>
  1151. <br>
  1152. <h4><cfif group_by eq 3>#task_status.status#<cfelse>#group_compare#</cfif>
  1153. &nbsp;(##:#groupData.count_group#,&nbsp;#label('00300')#:#groupData.ep_group#,
  1154. &nbsp;#label('00301')#:#groupData.eu_group#,&nbsp;#label('00302')#:#groupData.el_group#)
  1155. </h4>
  1156. <br>
  1157.  
  1158. <!--- ako e grupirano po nekoj kriterium --->
  1159. <table class="grid2" id="" >
  1160. <thead>
  1161. <tr>
  1162. <th style="display:none">
  1163. ##
  1164. </th>
  1165. <th>
  1166. ##
  1167. </th>
  1168. <cfif view_type neq 2>
  1169. <th>
  1170. #label('04174')#
  1171. </th>
  1172. </cfif>
  1173. <th class="prv_td">
  1174. #label('04236')#
  1175. </th>
  1176. <th>
  1177. Description
  1178. </th>
  1179. <th>
  1180. #label('04263')#
  1181. </th>
  1182. <th>
  1183. #label('04248')#
  1184. </th>
  1185. <th>
  1186. <cfif view_type eq 1>
  1187. #label('04254')#
  1188. <cfelse>
  1189. #label('04254')#
  1190. </cfif>
  1191. </th>
  1192. <th>Defined by</th>
  1193. <cfif view_type eq 1 and session.restrictions neq 1>
  1194. <th>
  1195. #label('04269')#
  1196. </th>
  1197. </cfif>
  1198. <!--- <cfif view_type eq 1>
  1199. <th>
  1200. #label('12153')#
  1201. </th>
  1202. </cfif> --->
  1203.  
  1204.  
  1205. <th>
  1206. #label('00300')#
  1207. </th>
  1208. <th>
  1209. #label('00301')#
  1210. </th>
  1211. <th>
  1212. #label('00302')#
  1213. </th>
  1214. <th>
  1215. #label('04239')#
  1216. </th>
  1217. <th>
  1218. #label('04242')#
  1219. </th>
  1220. <!--- <th>
  1221. #label('04266')#
  1222. </th> --->
  1223. <cfif session.restrictions neq 1>
  1224. <th style="display:none">
  1225. #label('04246')#
  1226. </th>
  1227. <th>
  1228. #label('04247')#
  1229. </th>
  1230. </cfif>
  1231. <!--- <cfif view_type eq 2>
  1232. <th>
  1233. #label('00127')#
  1234. </th>
  1235. </cfif> --->
  1236. </tr>
  1237. </thead>
  1238. <tbody>
  1239. <cfelse>
  1240. <!--- blagoj:tabela i hederi za koga se grupira po status --->
  1241. <!--- grupirano po status --->
  1242. <table class="grid2">
  1243. <thead>
  1244. <tr>
  1245. <th style="display:none">##</th>
  1246. <th>##</th>
  1247. <th class="prv_td">#label('04236')#</th>
  1248. <th>Description</th>
  1249. <th>#label('04263')#</th>
  1250. <th>#label('04248')#</th>
  1251. <th>#label('04254')#</th>
  1252. <th>#label('00300')#</th>
  1253. <th>#label('00301')#</th>
  1254. <th>#label('00302')#</th>
  1255. <th>#label('04239')#</th>
  1256. <th>#label('04242')#</th>
  1257. <th style="display:none">#label('04246')#</th>
  1258. <th>#label('04247')#</th>
  1259. <!--- <th>#label('00127')#</th> --->
  1260. </tr>
  1261. </thead>
  1262. <tbody>
  1263.  
  1264.  
  1265. <cfset no_group ++>
  1266. </cfif>
  1267. <cfset no_task++>
  1268. <!--- <cfset username=project_manager> --->
  1269. <cfinclude template="../mod07/dbselaccount.cfm">
  1270. <!--- <cfinclude template="../mod22/dbselectplans.cfm">
  1271. <!--- <cfdump var="#qselectplans#"> ---> --->
  1272. <cfsavecontent variable="desc">
  1273. <cfif view_type eq 2>
  1274. <cfif tsk_short_desc neq "">#tsk_short_desc##chr(10)#</cfif>
  1275. #diff_comment#
  1276. <cfelse>
  1277. <cfif activity_long_desc neq "">#activity_long_desc##chr(10)#</cfif>
  1278. #activity_comment_desc#
  1279. </cfif>
  1280. </cfsavecontent>
  1281. <cfif view_type eq 2>
  1282. <cfset tsk_name=task_name>
  1283. <cfset s_date=date_assign>
  1284. <cfset e_date=date_end_planned>
  1285. <cfset addquerystring="mod=12&wherecolumn=&wherevalue=&whereoper=&firstrow=1&rowsonpage=20&lstorder=date_assign,id_task,name,name,name,id_task,id_task,prt_id_prior,user_def,creator,date_def,date_end_planned,date_end_planned,name,id_task,id_task,name,creator,user_assigned,efford_left,efford_used,percent,date_assign,date_end_planned,creator,user_assigned,efford_left,id_task,name,name,user_assigned&lstdirect=desc,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,&type=edit&viewtype=2&previousfilter=&id_task=#id_task#">
  1286. <cfelse>
  1287. <cfset tsk_name=activity_name>
  1288. <cfset s_date=start_d>
  1289. <cfset e_date=end_d>
  1290. <cfset addquerystring="activities=1&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#">
  1291. </cfif>
  1292.  
  1293. <tr>
  1294. <td style="display:none">
  1295. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1296. #reden_broj#
  1297. </a>
  1298. </td>
  1299.  
  1300. <td>
  1301. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1302. #id_task#
  1303. </a>
  1304. </td>
  1305. <cfif view_type neq 2>
  1306. <td>
  1307. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1308. <input type="checkbox" <cfif id_status eq "6"> checked disabled="true"</cfif>name="close_activity_#no_task#" id="close_activity_#no_task#" >
  1309. <input type="hidden" style="width:70px" name="id_task_#no_task#" id="id_task_#no_task#" value="#id_task#" maxlength="10" class="gen_input" >
  1310. <input type="hidden" style="width:70px" name="id_activity_#no_task#" id="id_activity_#no_task#" value="#id_task_res_pl_activity#" maxlength="10" class="gen_input" >
  1311. <input type="hidden" style="width:70px" name="id_task_resource_#no_task#" id="id_task_resource_#no_task#" value="#id_task_resource#" MAXLENGTH="10" CLASS="gen_input" >
  1312. <input type="hidden" style="width:70px" name="task_name_#no_task#" id="task_name_#no_task#" value="#tsk_name#" maxlength="10" class="gen_input" >
  1313.  
  1314. </a>
  1315. </td>
  1316. </cfif>
  1317. <td>
  1318. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1319. #tsk_name#
  1320. <!---<cfif view_type eq 2>
  1321. <cfinclude template="dbtaskchildren.cfm">
  1322. <cfif qseltaskactivities.recordcount neq 0>
  1323. <a class="bold" href="##" id="more_#id_task#" style="margin-left:4px;" onclick="document.getElementById('childrenpanel').style.display='';$('##childrenpanel').load('mod12/childrenpanel.cfm?mod=12&task_id=#id_task#&view=2&temp_tasks=1');">
  1324. &raquo;
  1325. </a>
  1326. <a class="bold" href="##" id="less_#id_task#" style="margin-left:4px;display:none" onclick="document.getElementById('subtasks_tr_#id_task#').style.display='none';document.getElementById('more_#id_task#').style.display='';document.getElementById('less_#id_task#').style.display='none';">
  1327. &laquo;
  1328. </a>
  1329. </cfif>
  1330. </cfif>--->
  1331. </a>
  1332. </td>
  1333. <td class="desctd">
  1334. <a class="desc" href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1335. #tsk_short_desc#
  1336. </a>
  1337. </td>
  1338. <td>
  1339. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1340. #project_name#
  1341. </a>
  1342. </td>
  1343. <td>
  1344. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1345. #task_status.status#
  1346. </a>
  1347. </td>
  1348. <td>
  1349. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1350. #get_task_resource.username#
  1351. </a>
  1352. </td>
  1353. <td>
  1354. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1355. #get_task_resource.acc_username_def#
  1356. </a>
  1357. </td>
  1358. <cfif view_type eq 1>
  1359. <cfif session.restrictions neq 1>
  1360. <td>
  1361. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1362. #task_type#
  1363. </a>
  1364. </td>
  1365. </cfif>
  1366. <td>
  1367. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1368. #effort_planned#
  1369. </a>
  1370. </td>
  1371. <td>
  1372. <!--- <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#"> --->
  1373. <input type="text" style="width:70px" name="effort_used_#no_task#" id="effort_used_#no_task#" value="#effort_used#" maxlength="10" class="gen_input" >
  1374. <!--- </a> --->
  1375. </td>
  1376. <td>
  1377. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1378. <input type="text" style="width:70px" name="effort_left_#no_task#" id="effort_left_#no_task#" value="#effort_left#" maxlength="10" class="gen_input" >
  1379. <!--- #effort_left# --->
  1380. </a>
  1381. </td>
  1382. <cfelse>
  1383. <td>
  1384. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1385. #effort_planned#
  1386. </a>
  1387. </td>
  1388. <td>
  1389. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1390. #effort_used#
  1391. </a>
  1392. </td>
  1393. <td>
  1394. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1395. #effort_left#
  1396. </a>
  1397. </td>
  1398. </cfif>
  1399.  
  1400. <td>
  1401. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1402. #s_date#
  1403. </a>
  1404. </td>
  1405. <td>
  1406. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1407. #e_date#
  1408. </a>
  1409. </td>
  1410. <cfif session.restrictions neq 1>
  1411. <td style="display:none">
  1412. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1413. #client_comp#
  1414. </a>
  1415. </td>
  1416. <td>
  1417. <a href="frm_main.cfm?#addquerystring#" title="#tsk_name##chr(10)##desc#">
  1418. #priority#
  1419. </a>
  1420. </td>
  1421. </cfif>
  1422. <!--- <cfif view_type eq 2>
  1423. <td class="small">
  1424. <div style="width:100%;border-bottom:1px dashed ##999;padding-bottom:2px;margin-bottom:1px;">
  1425. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=3">#label('12077')#</a>&nbsp;|
  1426. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4">#label('12093')#</a>
  1427. </div>
  1428. <div style="width:100%;">
  1429. <a class="bold" href="frm_main.cfm?#addquerystring#&id_task=#id_task#&tab=4&inssubtask=1">#label('04273')#</a>
  1430. </div>
  1431. </td>
  1432. </cfif> --->
  1433. </tr>
  1434. <!--- <cfif view_type eq 2 and qseltaskactivities.recordcount neq 0>
  1435. <tr style="display:none"></tr>
  1436. <tr style="display:none" id="subtasks_tr_#id_task#">
  1437. <td style="background-color:white">
  1438. </td>
  1439. <td style="padding:0;margin:0;background-color:white" colspan="14">
  1440. <div id="subtasks_#id_task#">
  1441. </div>
  1442. </td>
  1443. </tr>
  1444. </cfif> --->
  1445. </cfloop>
  1446. </cfif>
  1447. </tbody>
  1448. </table>
  1449. </div>
  1450.  
  1451.  
  1452. <input type="hidden" style="width:70px" name="no_task" id="no_task" value="#no_task#" maxlength="10" class="gen_input" >
  1453.  
  1454. <div id="view12">
  1455.  
  1456. </div>
  1457. </cfif>
  1458. <cfelse>
  1459. <div id="view12" <cfif view eq 3>style="display: none"</cfif>>
  1460. #label('04173')#
  1461. </div>
  1462. <div id="project_table_1">
  1463.  
  1464. </div>
  1465. <div id="project_table_2">
  1466.  
  1467. </div>
  1468. </cfif>
  1469.  
  1470. </cfoutput>
  1471. </cfif>
  1472. <cfif isdefined("user_group") and not isdefined("sbminstask") and view eq 3>
  1473. <div id="project_table_3" <cfif view neq "3">style="display:none;overflow:auto;"</cfif>>
  1474. <cfquery name="qCompanyParams" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1475. select user_hierarchy from companies
  1476. where id_comp='#client.idcomp#'
  1477. </cfquery>
  1478. <cfif qCompanyParams.user_hierarchy eq 1>
  1479. <cfinvoke component="userHierarchy" method="userHierarchy" returnvariable="userHierarchy">
  1480. <cfinvokeargument name="company" value="#client.idcomp#">
  1481. <cfinvokeargument name="username" value="#session.id_user#">
  1482. <cfinvokeargument name="user_group" value="#user_group#">
  1483. <cfinvokeargument name="datum_do_clenstvo" value="#date_from_report#">
  1484. </cfinvoke>
  1485. <cfset myUsers=QuotedValueList(userHierarchy.username,",")>
  1486.  
  1487.  
  1488. <!--- <cfdump var="#myUsers#"> --->
  1489. <!--- <cfdump var="#userHierarchy#"> --->
  1490. <!--- <cfoutput>user_group=#user_group#=user_group</cfoutput> --->
  1491. <cfif restrict_users eq 0>
  1492. <cfquery name="qAllUsers" dbtype="query">
  1493. select * from userHierarchy
  1494. where personal_computer='1'
  1495. order by level,groups,username
  1496. </cfquery>
  1497. <!--- <cfdump var="#qUsers#"> --->
  1498. <cfelse>
  1499. <cfinclude template="dbUsersNoHours.cfm">
  1500. <cfset usersNoHours=QuotedValueList(qTasksNoHours.username,",")>
  1501. <cfquery name="qAllUsers" dbtype="query">
  1502. select * from userHierarchy
  1503. <cfif usersNoHours neq "">
  1504. where username in (#PreserveSingleQuotes(usersNoHours)#)
  1505. <cfelse>
  1506. where username is null
  1507. </cfif>
  1508. and personal_computer='1'
  1509. order by level,groups,username
  1510. </cfquery>
  1511. <!--- <cfdump var="#qUsers#"> --->
  1512. </cfif>
  1513. <!---<cfif session.id_user eq "artisoft_admin">
  1514. <cfdump var="#qAllUsers#">
  1515. </cfif> --->
  1516. <!--- <cfquery name="qSupervisors" dbtype="query">
  1517. select distinct supervisor, supervisor_name, supervisor_surname, level
  1518. from qAllUsers
  1519. where supervisor <>''
  1520. order by level,supervisor
  1521. </cfquery> --->
  1522. <cfinclude template="dbselgroups.cfm">
  1523. <!--- <cfquery name="qGroups" dbtype="query">
  1524. select distinct groups,id_business_unit
  1525. from qAllUsers
  1526. order by id_business_unit
  1527. </cfquery> --->
  1528. <cfoutput>
  1529. <cfset current_supervisor=".">
  1530. <cfset current_group=".">
  1531. <cfset no_users=0>
  1532. <cfset no_supervisors=0>
  1533. <cfif qAllUsers.RecordCount neq 0>
  1534. <input type="button" style="margin:5px;float:right;width:70px;margin-right:7px" name="pdf" value="PDF" class="btn" onclick="window.open('mod12/reports/#session.id_user#_#client.cfid#.pdf','')"<!--- onclick="window.print()"---> >
  1535. <div style="clear:both"></div>
  1536. <cfsavecontent variable="report">
  1537. <div style="font-family:Arial;font-size:9px">
  1538. <cfloop query="qBusinessUnits">
  1539. <!--- <cfset no_supervisors++>
  1540. <cfif no_supervisors neq 1>
  1541. <div style="height:25px;text-transform:uppercase;width:98%;border:1px dashed ##3c5185;color:##3c5185;margin-bottom:0px;margin-top:15px;vertical-align:middle">
  1542. <div style="margin:8px;margin-left:4px;">&nbsp;&nbsp;#label('04363')#:&nbsp;#supervisor_name#&nbsp;#supervisor_surname#</div>
  1543. </div>
  1544. </cfif> --->
  1545. <div style="clear:both"></div>
  1546. <!--- <cfquery name="qGroups" dbtype="query">
  1547. select distinct groups
  1548. from qAllUsers
  1549. where supervisor='#supervisor#'
  1550. </cfquery>
  1551. <cfloop query="qGroups"> --->
  1552.  
  1553. <cfquery name="qUsers" dbtype="query">
  1554. select distinct username,name,surname,user_priority
  1555. from qAllUsers
  1556. where id_business_unit='#id_business_unit#'
  1557. order by user_priority,name,surname
  1558. </cfquery>
  1559. <cfif qUsers.RecordCount neq 0>
  1560. <cfif business_unit neq "">
  1561. <br><h4 style="color:##3c5185;">#label('04367')#:&nbsp;#business_unit#</h4><br>
  1562. <cfelse>
  1563. <br>
  1564. </cfif>
  1565.  
  1566. <cfif qUsers.RecordCount neq 0>
  1567. <table class="grid2" id="" <cfif report_type eq 1>style="width:auto;border:1px solid ##d3d3d3;border-collapse:collapse;"<cfelse>style="border:1px solid ##d3d3d3;border-collapse:collapse;"</cfif>>
  1568. <thead>
  1569. <tr>
  1570. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1571. ##
  1572. </th>
  1573. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1574. #label('04370')#
  1575. </th>
  1576. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1577. #label('04371')#
  1578. </th>
  1579. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1580. #label('04372')#
  1581. </th>
  1582. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1583. #label('04373')#
  1584. </th>
  1585. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1586. #label('04374')#
  1587. </th>
  1588. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1589. #label('04375')#
  1590. </th>
  1591. </tr>
  1592. </thead>
  1593. <tbody>
  1594. <cfset no=0>
  1595. <cfset boja1="e2e5ed">
  1596. <cfset boja2="ffffff">
  1597. <cfset boja=boja2>
  1598. <cfloop query="qUsers">
  1599. <cfinclude template="dbusersumtasks.cfm">
  1600. <cfset no++>
  1601. <cfif boja eq boja1>
  1602. <cfset boja=boja2>
  1603. <cfelse>
  1604. <cfset boja=boja1>
  1605. </cfif>
  1606.  
  1607. <tr <cfif qtasks.RecordCount eq 0 or (Trim(no_hours_period) neq "" and qtasks.effort_used lt no_hours_period)>style="color:red;background-color:###boja#;"<cfelse>style="color:##666;background-color:###boja#;"</cfif>>
  1608. <td style="font-size:10px;padding:4px;">#no#</td>
  1609. <td style="font-size:10px;padding:4px;">#name#</td>
  1610. <td style="font-size:10px;padding:4px;">#surname#</td>
  1611. <cfif qtasks.RecordCount neq 0>
  1612. <td style="font-size:10px;padding:4px;">#qtasks.effort_planned#</td>
  1613. <td style="font-size:10px;padding:4px;">#qtasks.effort_used#</td>
  1614. <td style="font-size:10px;padding:4px;"><!--- #qtasks.effort_left# --->#qtasks.effort_planned-qtasks.effort_used#</td>
  1615. <td style="font-size:10px;padding:3px;">#qtasks.count_tasks#</td>
  1616. <cfelse>
  1617. <td style="font-size:10px;padding:4px;">0</td>
  1618. <td style="font-size:10px;padding:4px;">0</td>
  1619. <td style="font-size:10px;padding:4px;">0</td>
  1620. <td style="font-size:10px;padding:4px;">0</td>
  1621. </cfif>
  1622. </tr>
  1623. <cfif report_type neq 1 and qtasksDetails.RecordCount neq 0>
  1624. <cfset noDetails=0>
  1625. <cfif boja eq boja1>
  1626. <cfset boja=boja2>
  1627. <cfelse>
  1628. <cfset boja=boja1>
  1629. </cfif>
  1630. <tr>
  1631. <td colspan="2"></td>
  1632. <td colspan="5" style="padding:0;">
  1633. <table class="grid2" style="border:1px solid ##d3d3d3;border-collapse:collapse;width:100%">
  1634. <thead>
  1635. <tr>
  1636. <th class="prv_td" style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">##</th>
  1637. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1638. #label('04236')#
  1639. </th>
  1640. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1641. Description
  1642. </th>
  1643. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1644. #label('121242')#
  1645. </th>
  1646. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1647. #label('04248')#
  1648. </th>
  1649.  
  1650.  
  1651. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1652. #label('00300')#
  1653. </th>
  1654. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1655. #label('00301')#
  1656. </th>
  1657. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1658. #label('00302')#
  1659. </th>
  1660. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1661. #label('04239')#
  1662. </th>
  1663. <th style="text-align:left;font-size:9px;color:##666;padding:4px;border:1px solid ##d3d3d3;">
  1664. #label('04242')#
  1665. </th>
  1666. </tr>
  1667. </thead>
  1668. <tbody>
  1669. <cfloop query="qtasksDetails">
  1670. <cfset addquerystring="activities=1&id_task=#id_task#&id_project=&id_task_res=#id_task_resource#&id_activity=#id_task_res_pl_activity#">
  1671. <cfset noDetails++>
  1672. <cfinclude template="dbstatuses.cfm">
  1673. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1674. select ts.label_#client.lang# as status, ts.id_status, ts.color
  1675. from task_statuses ts, tasks t
  1676. where t.tskstat_id_task_status=ts.id_status
  1677. and t.id_task='#id_task#'
  1678. </cfquery>
  1679. <tr title="#long_desc#" style="background-color:white;border-bottom:1px dashed ##d3d3d3;">
  1680. <td style="padding:4px;">
  1681. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#noDetails#</a>
  1682. </td>
  1683. <td style="padding:4px;">
  1684. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#short_desc#</a>
  1685. </td>
  1686. <td style="padding:4px;">
  1687. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#mid(long_desc,1,300)#</a>
  1688. </td>
  1689. <td style="padding:4px;">
  1690. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#task_status.status#</a>
  1691. </td>
  1692. <td style="padding:4px;">
  1693. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#effort_planned#</a>
  1694. </td>
  1695. <td style="padding:4px;">
  1696. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#effort_used#</a>
  1697. </td>
  1698. <td style="padding:4px;">
  1699. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#effort_planned-effort_used#</a>
  1700. </td>
  1701. <td style="padding:4px;">
  1702. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#sd#</a>
  1703. </td>
  1704. <td style="padding:4px;">
  1705. <a style="font-size:10px;color:##666;text-decoration:none" href="frm_main.cfm?#addquerystring#">#ed#</a>
  1706. </td>
  1707. </tr>
  1708. <cfinclude template="dbTasksDetailActivities.cfm">
  1709. <cfif report_type eq 3 and qtasksDetailActivities.RecordCount neq 0>
  1710. <cfset noAct=0>
  1711. <tr style="border-top:1px dashed ##d3d3d3;">
  1712. <td align="right" style="font-size:10px;color:##666;padding:4px;border-top:1px dashed ##d3d3d3;"><!--- #label('01042')# ---></td>
  1713. <td colspan="8" style="padding:0;border-top:1px dashed ##d3d3d3;">
  1714. <table class="grid2" style="border:0px solid ##d3d3d3;border-collapse:collapse;width:100%">
  1715. <tbody>
  1716. <cfloop query="qtasksDetailActivities">
  1717. <cfset noAct++>
  1718. <cfif noAct%2 eq 0>
  1719. <cfset col="fff">
  1720. <cfelse>
  1721. <cfset col="e2e5ed">
  1722. </cfif>
  1723.  
  1724. <tr style="background-color:###col#;">
  1725. <td style="font-size:10px;padding:4px;color:##666;">#post_date#:&nbsp;#activity_desc#,&nbsp;&nbsp;#efford_used#&nbsp;#label('00269')#</td>
  1726. </tr>
  1727. </cfloop>
  1728. </tbody>
  1729. </table>
  1730. </td>
  1731. </tr>
  1732. </cfif>
  1733.  
  1734.  
  1735. </cfloop>
  1736. </tbody>
  1737. </table>
  1738. </td>
  1739. </tr>
  1740. <!--- <cfelse>
  1741. <script>alert("<cfoutput>#report_type#</cfoutput>")</script> --->
  1742. </cfif>
  1743. </cfloop>
  1744. </tbody>
  1745. </table>
  1746. </cfif>
  1747. <!--- </cfloop> --->
  1748. </cfif>
  1749.  
  1750. </cfloop>
  1751. </div>
  1752. </cfsavecontent>
  1753. <cfoutput>#report#</cfoutput>
  1754. <cfdocument format="pdf" filename="reports/#session.id_user#_#client.cfid#.pdf" overwrite="yes" orientation = "landscape"
  1755. fontembed="yes">
  1756. <!--- <cfdocumentitem type="header"> --->
  1757. <div style="font-family:Arial;font-weight:bold;padding:0px;font-size:13px;color:##666;">
  1758. <cfif report_type eq 1>
  1759. #label('04376')#
  1760. <cfelseif report_type eq 2>
  1761. #label('04377')#
  1762. <cfelseif report_type eq 3>
  1763. #label('04384')#
  1764. </cfif>
  1765. </div>
  1766. <br>
  1767. <div style="font-family:Arial;font-weight:normal;padding:0px;font-size:9px;color:##666;">
  1768. #label('12055')#:&nbsp;#date_from_report#-#date_to_report#<br>
  1769. #label('04378')#:&nbsp;<cfif status_report eq "">#label('04379')#
  1770. <cfelseif status_report eq "not_finished">#label('04341')#
  1771. <cfelse><cfset id_status=status_report><cfinclude template="dbstatuses.cfm">
  1772. <cfquery name="task_status" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1773. select ts.label_#client.lang# as status, ts.id_status, ts.color
  1774. from task_statuses ts, tasks t
  1775. where t.tskstat_id_task_status=ts.id_status
  1776. and t.id_task='#id_task#'
  1777. </cfquery>
  1778. #task_status.status#</cfif><br>
  1779. #label('04367')#:&nbsp;<cfif user_group eq "">#label('04379')#<cfelse>#user_group#</cfif><br>
  1780. #label('04382')#:&nbsp;#no_hours_period#<br>
  1781. <font color="red">#label('04381')#<br></font>
  1782. <cfif restrict_users eq 1>
  1783. #label('04380')#<br>
  1784. </cfif>
  1785. </div>
  1786. <!--- </cfdocumentitem> --->
  1787. <cfoutput>#report#</cfoutput>
  1788. <cfdocumentitem type="footer">
  1789. <div style="float:right;color:##666;font-size:10px;">
  1790. #cfdocument.currentpagenumber#
  1791. </div>
  1792. </cfdocumentitem>
  1793. </cfdocument>
  1794.  
  1795. <cfelse>
  1796. #label('04173')#
  1797. </cfif>
  1798. </cfoutput>
  1799. </cfif>
  1800.  
  1801. </div>
  1802. </cfif>
  1803. <!--- <cfoutput>
  1804. <style type="text/css">
  1805. ##dummy_table_2{
  1806.  
  1807. margin-top: 30px;
  1808. margin-left: 15px;
  1809. margin-right: 30px;
  1810.  
  1811. }
  1812. </style>
  1813. <table class="grid2" id="dummy_table_2">
  1814. <thead>
  1815. <tr>
  1816.  
  1817. <th>
  1818. id
  1819. </th>
  1820.  
  1821. <th>
  1822. #label('04236')#
  1823. </th>
  1824. <th>
  1825. #label('04263')#
  1826. </th>
  1827. <th>
  1828. #label('04248')#
  1829. </th>
  1830. <th>
  1831. <th>
  1832. #label('04254')#
  1833. </th>
  1834.  
  1835. <th>
  1836. #label('00300')#
  1837. </th>
  1838. <th>
  1839. #label('00301')#
  1840. </th>
  1841. <th>
  1842. #label('00302')#
  1843. </th>
  1844. <th>
  1845. #label('04239')#
  1846. </th>
  1847. <th>
  1848. #label('04242')#
  1849. </th>
  1850.  
  1851.  
  1852. <th>
  1853. #label('04247')#
  1854. </th>
  1855.  
  1856. <th>
  1857. #label('00127')#
  1858. </th>
  1859.  
  1860. </tr>
  1861.  
  1862. </thead>
  1863. <cfquery name="get_dummy" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1864. select *
  1865. from tasks t
  1866. where id_task not like '%.%'
  1867. and acc_comp_id_comp='#client.idcomp#'
  1868. </cfquery>
  1869.  
  1870.  
  1871. <tbody>
  1872. <cfloop query="get_dummy">
  1873.  
  1874.  
  1875. <cfquery name="task_planned_timm" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1876. select sum(effort_planned) as planirano
  1877. from task_resources
  1878. where comp_id_comp = '#client.idcomp#'
  1879. and id_task='#qtasks.id_task#'
  1880. </cfquery>
  1881. <cfquery name="task_statuss" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1882. select ts.label_#client.lang# as status, ts.id_status, ts.color
  1883. from task_statuses ts, tasks t
  1884. where t.tskstat_id_task_status=ts.id_status
  1885. and t.id_task='#get_dummy.id_task#'
  1886. </cfquery>
  1887. <cfquery name="task_preprityy" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1888. select p.label_#client.lang# as preorit
  1889. from priorities p, tasks t
  1890. where t.prt_id_prior=p.id_prior
  1891. and t.id_task='#get_dummy.id_task#'
  1892. </cfquery>
  1893. <cfset planirano_vremee='#task_planned_timm.planirano#'>
  1894. <cfif planirano_vremee eq ''>
  1895. <cfset planirano_vremee=0>
  1896. </cfif>
  1897. <tr>
  1898. <td>
  1899. #get_dummy.id_task#
  1900. </td>
  1901. <td>
  1902. #get_dummy.name#
  1903. </td>
  1904. <cfquery name="get_dummy_name" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1905. select name
  1906. from dummy_projects
  1907. where id_dummy=#get_dummy.dummy_project_id# and comp_id='#client.idcomp#'
  1908. </cfquery>
  1909. <td>
  1910. #get_dummy_name.name#
  1911. </td>
  1912. <td>
  1913. #task_statuss.status#
  1914. </td>
  1915. <cfquery name="get_task_resource" datasource="#session.dsn#" username="#session.user#" password="#session.pass#">
  1916. select *
  1917. from tasks t, task_resources tr
  1918. where t.id_task='#get_dummy.id_task#' and tr.id_task='#get_dummy.id_task#' and t.acc_comp_id_comp='#client.idcomp#' and tr.comp_id_comp='#client.idcomp#'
  1919. </cfquery>
  1920. <td>
  1921. #get_task_resource.username#
  1922. </td>
  1923. <td>
  1924. #get_dummy_name.name#
  1925. </td>
  1926. <td>
  1927.  
  1928. #planirano_vremee#
  1929.  
  1930. </td>
  1931. <td>
  1932.  
  1933. #get_dummy.efford_planned#
  1934.  
  1935. </td>
  1936. <cfset ostanato=#planirano_vremee#-#get_dummy.efford_planned#>
  1937. <td>
  1938.  
  1939. #ostanato#
  1940.  
  1941. </td>
  1942. <td>
  1943. #DateFormat(date_def, "d-mmm-yyyy")#
  1944. </td>
  1945. <td>
  1946. #DateFormat(date_end_planned, "d-mmm-yyyy")#
  1947. </td>
  1948.  
  1949. </tr>
  1950. </cfloop>
  1951.  
  1952. </tbody>
  1953.  
  1954. </cfoutput>
  1955. --->
  1956. </body>
  1957. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!