ticket_overviews_controller.rb 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524
  1. class TicketOverviewsController < ApplicationController
  2. before_filter :authentication_check
  3. # GET /tickets
  4. def show
  5. #sleep 2
  6. # get navbar overview data
  7. if !params[:view]
  8. result = Ticket.overview(
  9. :current_user => current_user,
  10. )
  11. render :json => result
  12. return
  13. end
  14. # get real overview data
  15. if params[:array]
  16. overview = Ticket.overview(
  17. :view => params[:view],
  18. :current_user => current_user,
  19. :array => true,
  20. )
  21. tickets = []
  22. overview[:tickets].each {|ticket|
  23. data = { :id => ticket.id }
  24. tickets.push data
  25. }
  26. # return result
  27. render :json => {
  28. :overview => overview[:overview],
  29. :tickets => tickets,
  30. :tickets_count => overview[:tickets_count],
  31. }
  32. return
  33. end
  34. overview = Ticket.overview(
  35. :view => params[:view],
  36. :view_mode => params[:view_mode],
  37. :current_user_id => current_user.id,
  38. :start_page => params[:start_page],
  39. :array => true,
  40. )
  41. # get related users
  42. users = {}
  43. tickets = []
  44. overview[:tickets].each {|ticket|
  45. data = Ticket.full_data(ticket.id)
  46. tickets.push data
  47. if !users[ data['owner_id'] ]
  48. users[ data['owner_id'] ] = User.user_data_full( data['owner_id'] )
  49. end
  50. if !users[ data['customer_id'] ]
  51. users[ data['customer_id'] ] = User.user_data_full( data['customer_id'] )
  52. end
  53. if !users[ data['created_by_id'] ]
  54. users[ data['created_by_id'] ] = User.user_data_full( data['created_by_id'] )
  55. end
  56. }
  57. # get groups
  58. group_ids = []
  59. Group.where( :active => true ).each { |group|
  60. group_ids.push group.id
  61. }
  62. agents = {}
  63. Ticket.agents.each { |user|
  64. agents[ user.id ] = 1
  65. }
  66. groups_users = {}
  67. group_ids.each {|group_id|
  68. groups_users[ group_id ] = []
  69. Group.find(group_id).users.each {|user|
  70. next if !agents[ user.id ]
  71. groups_users[ group_id ].push user.id
  72. if !users[user.id]
  73. users[user.id] = User.user_data_full(user.id)
  74. end
  75. }
  76. }
  77. # return result
  78. render :json => {
  79. :overview => overview[:overview],
  80. :tickets => tickets,
  81. :tickets_count => overview[:tickets_count],
  82. :users => users,
  83. :bulk => {
  84. :group_id__owner_id => groups_users,
  85. },
  86. }
  87. end
  88. # GET /ticket_create/1
  89. def ticket_create
  90. # get attributes
  91. create_attributes = Ticket.create_attributes(
  92. :current_user_id => current_user.id,
  93. )
  94. # split data
  95. ticket = nil
  96. articles = nil
  97. users = {}
  98. if params[:ticket_id] && params[:article_id]
  99. ticket = Ticket.find( params[:ticket_id] )
  100. # get related users
  101. if !users[ticket.owner_id]
  102. users[ticket.owner_id] = User.user_data_full(ticket.owner_id)
  103. end
  104. if !users[ticket.customer_id]
  105. users[ticket.customer_id] = User.user_data_full(ticket.customer_id)
  106. end
  107. if !users[ticket.created_by_id]
  108. users[ticket.created_by_id] = User.user_data_full(ticket.created_by_id)
  109. end
  110. owner_ids = []
  111. ticket.agent_of_group.each { |user|
  112. owner_ids.push user.id
  113. if !users[user.id]
  114. users[user.id] = User.user_data_full(user.id)
  115. end
  116. }
  117. # get related articles
  118. ticket[:article_ids] = [ params[:article_id] ]
  119. article = Ticket::Article.find( params[:article_id] )
  120. # add attachment list to article
  121. article['attachments'] = Store.list( :object => 'Ticket::Article', :o_id => article.id )
  122. # load users
  123. if !users[article.created_by_id]
  124. users[article.created_by_id] = User.user_data_full(article.created_by_id)
  125. end
  126. end
  127. create_attributes[:owner_id].each {|user_id|
  128. if !users[user_id]
  129. users[user_id] = User.user_data_full(user_id)
  130. end
  131. }
  132. # return result
  133. render :json => {
  134. :ticket => ticket,
  135. :articles => [ article ],
  136. :users => users,
  137. :edit_form => create_attributes,
  138. }
  139. end
  140. # GET /ticket_full/1
  141. def ticket_full
  142. # permission check
  143. ticket = Ticket.find(params[:id])
  144. return if !ticket_permission(ticket)
  145. # get related users
  146. users = {}
  147. if !users[ticket.owner_id]
  148. users[ticket.owner_id] = User.user_data_full(ticket.owner_id)
  149. end
  150. if !users[ticket.customer_id]
  151. users[ticket.customer_id] = User.user_data_full(ticket.customer_id)
  152. end
  153. if !users[ticket.created_by_id]
  154. users[ticket.created_by_id] = User.user_data_full(ticket.created_by_id)
  155. end
  156. owner_ids = []
  157. ticket.agent_of_group.each { |user|
  158. owner_ids.push user.id
  159. if !users[user.id]
  160. users[user.id] = User.user_data_full(user.id)
  161. end
  162. }
  163. # log object as viewed
  164. log_view(ticket)
  165. # get related articles
  166. ticket = ticket.attributes
  167. ticket[:article_ids] = []
  168. articles = Ticket::Article.where( :ticket_id => params[:id] )
  169. # get related users
  170. articles_used = []
  171. articles.each {|article|
  172. # ignore internal article if customer is requesting
  173. next if article.internal == true && is_role('Customer')
  174. article_tmp = article.attributes
  175. # load article ids
  176. ticket[:article_ids].push article_tmp['id']
  177. # add attachment list to article
  178. article_tmp['attachments'] = Store.list( :object => 'Ticket::Article', :o_id => article.id )
  179. # remember article
  180. articles_used.push article_tmp
  181. # load users
  182. if !users[article.created_by_id]
  183. users[article.created_by_id] = User.user_data_full(article.created_by_id)
  184. end
  185. }
  186. # get groups
  187. group_ids = []
  188. Group.where( :active => true ).each { |group|
  189. group_ids.push group.id
  190. }
  191. agents = {}
  192. Ticket.agents.each { |user|
  193. agents[ user.id ] = 1
  194. }
  195. groups_users = {}
  196. group_ids.each {|group_id|
  197. groups_users[ group_id ] = []
  198. Group.find(group_id).users.each {|user|
  199. next if !agents[ user.id ]
  200. groups_users[ group_id ].push user.id
  201. if !users[user.id]
  202. users[user.id] = User.user_data_full(user.id)
  203. end
  204. }
  205. }
  206. # return result
  207. render :json => {
  208. :ticket => ticket,
  209. :articles => articles_used,
  210. :users => users,
  211. :edit_form => {
  212. :group_id__owner_id => groups_users,
  213. :owner_id => owner_ids,
  214. }
  215. }
  216. end
  217. # POST /ticket_attachment/new
  218. def ticket_attachment_new
  219. # puts '-------'
  220. # puts params.inspect
  221. # store file
  222. # content_type = request.content_type
  223. content_type = request[:content_type]
  224. puts 'content_type: ' + content_type.inspect
  225. if !content_type || content_type == 'application/octet-stream'
  226. if MIME::Types.type_for(params[:qqfile]).first
  227. content_type = MIME::Types.type_for(params[:qqfile]).first.content_type
  228. else
  229. content_type = 'application/octet-stream'
  230. end
  231. end
  232. headers_store = {
  233. 'Content-Type' => content_type
  234. }
  235. Store.add(
  236. :object => 'UploadCache::' + params[:form] + '::' + current_user.id.to_s,
  237. :o_id => params[:form_id],
  238. :data => request.body.read,
  239. :filename => params[:qqfile],
  240. :preferences => headers_store
  241. )
  242. # return result
  243. render :json => {
  244. :success => true,
  245. }
  246. end
  247. # GET /ticket_attachment/1
  248. def ticket_attachment
  249. # permissin check
  250. ticket = Ticket.find( params[:ticket_id] )
  251. if !ticket_permission(ticket)
  252. render( :json => 'No such ticket.', :status => :unauthorized )
  253. return
  254. end
  255. article = Ticket::Article.find( params[:article_id] )
  256. if ticket.id != article.ticket_id
  257. render( :json => 'No access, article_id/ticket_id is not matching.', :status => :unauthorized )
  258. return
  259. end
  260. list = Store.list( :object => 'Ticket::Article', :o_id => params[:article_id] ) || []
  261. access = false
  262. list.each {|item|
  263. if item.id.to_i == params[:id].to_i
  264. access = true
  265. end
  266. }
  267. if !access
  268. render( :json => 'Requested file id is not linked with article_id.', :status => :unauthorized )
  269. return
  270. end
  271. # find file
  272. file = Store.find(params[:id])
  273. send_data(
  274. file.store_file.data,
  275. :filename => file.filename,
  276. :type => file.preferences['Content-Type'] || file.preferences['Mime-Type'],
  277. :disposition => 'inline'
  278. )
  279. end
  280. # GET /ticket_article_plain/1
  281. def ticket_article_plain
  282. # permissin check
  283. article = Ticket::Article.find( params[:id] )
  284. return if !ticket_permission( article.ticket )
  285. list = Store.list(
  286. :object => 'Ticket::Article::Mail',
  287. :o_id => params[:id],
  288. )
  289. # find file
  290. if list
  291. file = Store.find(list.first)
  292. send_data(
  293. file.store_file.data,
  294. :filename => file.filename,
  295. :type => 'message/rfc822',
  296. :disposition => 'inline'
  297. )
  298. end
  299. end
  300. # GET /ticket_customer
  301. # GET /tickets_customer
  302. def ticket_customer
  303. # get closed/open states
  304. ticket_state_list_open = Ticket::State.where(
  305. :ticket_state_type_id => Ticket::StateType.where(:name => ['new','open', 'pending remidner', 'pending action'])
  306. )
  307. ticket_state_list_closed = Ticket::State.where(
  308. :ticket_state_type_id => Ticket::StateType.where(:name => ['closed'] )
  309. )
  310. # get tickets
  311. tickets_open = Ticket.where(
  312. :customer_id => params[:customer_id],
  313. :ticket_state_id => ticket_state_list_open
  314. ).limit(15).order('created_at DESC')
  315. tickets_closed = Ticket.where(
  316. :customer_id => params[:customer_id],
  317. :ticket_state_id => ticket_state_list_closed
  318. ).limit(15).order('created_at DESC')
  319. # tickets = Ticket.where(:customer_id => user_id).limit(15).order('created_at DESC')
  320. # ticket_items = []
  321. # tickets.each do |ticket|
  322. # style = ''
  323. # ticket_state_type = ticket.ticket_state.ticket_state_type.name
  324. # if ticket_state_type == 'closed' || ticket_state_type == 'merged'
  325. # style = 'text-decoration: line-through'
  326. # end
  327. # item = {
  328. # :url => '#ticket/zoom/' + ticket.id.to_s,
  329. # :name => 'T:' + ticket.number.to_s,
  330. # :title => ticket.title,
  331. # :style => style
  332. # }
  333. # ticket_items.push item
  334. # end
  335. # if ticket_items[0]
  336. # topic = {
  337. # :title => 'Tickets',
  338. # :items => ticket_items
  339. # }
  340. # user['links'].push topic
  341. # end
  342. # return result
  343. render :json => {
  344. :tickets => {
  345. :open => tickets_open,
  346. :closed => tickets_closed
  347. }
  348. # :users => users,
  349. }
  350. end
  351. # GET /ticket_history/1
  352. def ticket_history
  353. # get ticket data
  354. ticket = Ticket.find(params[:id])
  355. # permissin check
  356. return if !ticket_permission(ticket)
  357. # get history of ticket
  358. history = History.history_list( 'Ticket', params[:id], 'Ticket::Article' )
  359. # get related users
  360. users = {}
  361. history.each do |item|
  362. users[ item['created_by_id'] ] = User.user_data_full( item['created_by_id'] )
  363. if item['history_object'] == 'Ticket::Article'
  364. item['type'] = 'Article ' + item['type'].to_s
  365. else
  366. item['type'] = 'Ticket ' + item['type'].to_s
  367. end
  368. end
  369. # fetch meta relations
  370. history_objects = History::Object.all()
  371. history_types = History::Type.all()
  372. history_attributes = History::Attribute.all()
  373. # return result
  374. render :json => {
  375. :ticket => ticket,
  376. :users => users,
  377. :history => history,
  378. :history_objects => history_objects,
  379. :history_types => history_types,
  380. :history_attributes => history_attributes
  381. }
  382. end
  383. # GET /ticket_merge/1/1
  384. def ticket_merge
  385. # check master ticket
  386. ticket_master = Ticket.where( :number => params[:master_ticket_number] ).first
  387. if !ticket_master
  388. render :json => {
  389. :result => 'faild',
  390. :message => 'No such master ticket number!',
  391. }
  392. return
  393. end
  394. # permissin check
  395. return if !ticket_permission(ticket_master)
  396. # check slave ticket
  397. ticket_slave = Ticket.where( :id => params[:slave_ticket_id] ).first
  398. if !ticket_slave
  399. render :json => {
  400. :result => 'faild',
  401. :message => 'No such slave ticket!',
  402. }
  403. return
  404. end
  405. # permissin check
  406. return if !ticket_permission(ticket_slave)
  407. # check diffetent ticket ids
  408. if ticket_slave.id == ticket_master.id
  409. render :json => {
  410. :result => 'faild',
  411. :message => 'Can\'t merge ticket with it self!',
  412. }
  413. return
  414. end
  415. # merge ticket
  416. success = ticket_slave.merge_to(
  417. {
  418. :ticket_id => ticket_master.id,
  419. :created_by_id => current_user.id,
  420. }
  421. )
  422. # return result
  423. render :json => {
  424. :result => 'success',
  425. :master_ticket => ticket_master.attributes,
  426. :slave_ticket => ticket_slave.attributes,
  427. }
  428. end
  429. # GET /user_search
  430. def user_search
  431. # get params
  432. query = params[:term]
  433. limit = params[:limit] || 18
  434. # do query
  435. user_all = User.find(
  436. :all,
  437. :limit => limit,
  438. :conditions => ['firstname LIKE ? or lastname LIKE ? or email LIKE ?', "%#{query}%", "%#{query}%", "%#{query}%"],
  439. :order => 'firstname'
  440. )
  441. # build result list
  442. users = []
  443. user_all.each do |user|
  444. realname = user.firstname.to_s + ' ' + user.lastname.to_s
  445. if user.email && user.email.to_s != ''
  446. realname = realname + ' <' + user.email.to_s + '>'
  447. end
  448. a = { :id => user.id, :label => realname, :value => realname }
  449. users.push a
  450. end
  451. # return result
  452. render :json => users
  453. end
  454. end