API tools faq
paste
linccce

SUperHard

linccce
Apr 28th, 2014
226
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.96 KB | None | 0 0
raw download clone embed print report
  1. SELECT person.`personid`, person.`name`, person.`familyname`, person.`name`, doorreader.`portid`, doorreader.`boardid`, doorreader.`doorid`, doorreader.`readerid`, doorreader.`readername`, cardevent.`cardno`, company.`companyname`, depart.`departname`, cardevent.`cardeventdate`, cardevent.`cardeventtime` FROM `t_person` AS person INNER JOIN `t_cardevent` AS cardevent ON cardevent.`personid` = person.`personid` INNER JOIN `t_door` AS door ON door.`doorid` = cardevent.`doorid` INNER JOIN `t_doorreader` AS doorreader ON doorreader.`readerid` = cardevent.`readerid` INNER JOIN `t_company` AS company ON company.`companycode` = person.`companycode` INNER JOIN `t_department` AS depart ON depart.`departcode` = person.`departcode` WHERE cardevent.`cardeventdate` BETWEEN '20090101' AND '20090128' AND (person.`personid` = '318' OR person.`personid` = '364' OR person.`personid` = '418' OR person.`personid` = '626' OR person.`personid` = '643' OR person.`personid` = '661' OR person.`personid` = '737' OR person.`personid` = '799' OR person.`personid` = '800' OR person.`personid` = '808' OR person.`personid` = '810' OR person.`personid` = 'aaaaa1' OR person.`personid` = 'dublikatas') AND doorreader.`doorid` = '1' AND doorreader.`boardid` = '005' ORDER BY cardevent.`cardeventdate`, cardevent.`cardeventtime` ASC
  2.  
  3. array (size=22)
  4. 0 =>
  5. array (size=13)
  6. 'personid' => string 'dublikatas' (length=10)
  7. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  8. 'familyname' => string '' (length=0)
  9. 'portid' => string '01' (length=2)
  10. 'boardid' => string '005' (length=3)
  11. 'doorid' => string '1' (length=1)
  12. 'readerid' => string '1' (length=1)
  13. 'readername' => string 'Vartai IN' (length=9)
  14. 'cardno' => string '05910680' (length=8)
  15. 'companyname' => string 'Baltijos brasta' (length=15)
  16. 'departname' => string 'Logistika' (length=9)
  17. 'cardeventdate' => string '20090114' (length=8)
  18. 'cardeventtime' => string '073940' (length=6)
  19. 1 =>
  20. array (size=13)
  21. 'personid' => string 'dublikatas' (length=10)
  22. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  23. 'familyname' => string '' (length=0)
  24. 'portid' => string '01' (length=2)
  25. 'boardid' => string '005' (length=3)
  26. 'doorid' => string '1' (length=1)
  27. 'readerid' => string '1' (length=1)
  28. 'readername' => string 'Vartai IN' (length=9)
  29. 'cardno' => string '05910680' (length=8)
  30. 'companyname' => string 'Baltijos brasta' (length=15)
  31. 'departname' => string 'Logistika' (length=9)
  32. 'cardeventdate' => string '20090114' (length=8)
  33. 'cardeventtime' => string '132415' (length=6)
  34. 2 =>
  35. array (size=13)
  36. 'personid' => string 'dublikatas' (length=10)
  37. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  38. 'familyname' => string '' (length=0)
  39. 'portid' => string '01' (length=2)
  40. 'boardid' => string '005' (length=3)
  41. 'doorid' => string '1' (length=1)
  42. 'readerid' => string '2' (length=1)
  43. 'readername' => string 'Vartai OUT' (length=10)
  44. 'cardno' => string '05910680' (length=8)
  45. 'companyname' => string 'Baltijos brasta' (length=15)
  46. 'departname' => string 'Logistika' (length=9)
  47. 'cardeventdate' => string '20090114' (length=8)
  48. 'cardeventtime' => string '172532' (length=6)
  49. 3 =>
  50. array (size=13)
  51. 'personid' => string 'dublikatas' (length=10)
  52. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  53. 'familyname' => string '' (length=0)
  54. 'portid' => string '01' (length=2)
  55. 'boardid' => string '005' (length=3)
  56. 'doorid' => string '1' (length=1)
  57. 'readerid' => string '1' (length=1)
  58. 'readername' => string 'Vartai IN' (length=9)
  59. 'cardno' => string '05910680' (length=8)
  60. 'companyname' => string 'Baltijos brasta' (length=15)
  61. 'departname' => string 'Logistika' (length=9)
  62. 'cardeventdate' => string '20090115' (length=8)
  63. 'cardeventtime' => string '101837' (length=6)
  64. 4 =>
  65. array (size=13)
  66. 'personid' => string 'dublikatas' (length=10)
  67. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  68. 'familyname' => string '' (length=0)
  69. 'portid' => string '01' (length=2)
  70. 'boardid' => string '005' (length=3)
  71. 'doorid' => string '1' (length=1)
  72. 'readerid' => string '2' (length=1)
  73. 'readername' => string 'Vartai OUT' (length=10)
  74. 'cardno' => string '05910680' (length=8)
  75. 'companyname' => string 'Baltijos brasta' (length=15)
  76. 'departname' => string 'Logistika' (length=9)
  77. 'cardeventdate' => string '20090115' (length=8)
  78. 'cardeventtime' => string '170758' (length=6)
  79. 5 =>
  80. array (size=13)
  81. 'personid' => string 'dublikatas' (length=10)
  82. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  83. 'familyname' => string '' (length=0)
  84. 'portid' => string '01' (length=2)
  85. 'boardid' => string '005' (length=3)
  86. 'doorid' => string '1' (length=1)
  87. 'readerid' => string '1' (length=1)
  88. 'readername' => string 'Vartai IN' (length=9)
  89. 'cardno' => string '05910680' (length=8)
  90. 'companyname' => string 'Baltijos brasta' (length=15)
  91. 'departname' => string 'Logistika' (length=9)
  92. 'cardeventdate' => string '20090116' (length=8)
  93. 'cardeventtime' => string '075832' (length=6)
  94. 6 =>
  95. array (size=13)
  96. 'personid' => string 'dublikatas' (length=10)
  97. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  98. 'familyname' => string '' (length=0)
  99. 'portid' => string '01' (length=2)
  100. 'boardid' => string '005' (length=3)
  101. 'doorid' => string '1' (length=1)
  102. 'readerid' => string '2' (length=1)
  103. 'readername' => string 'Vartai OUT' (length=10)
  104. 'cardno' => string '05910680' (length=8)
  105. 'companyname' => string 'Baltijos brasta' (length=15)
  106. 'departname' => string 'Logistika' (length=9)
  107. 'cardeventdate' => string '20090116' (length=8)
  108. 'cardeventtime' => string '111225' (length=6)
  109. 7 =>
  110. array (size=13)
  111. 'personid' => string 'dublikatas' (length=10)
  112. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  113. 'familyname' => string '' (length=0)
  114. 'portid' => string '01' (length=2)
  115. 'boardid' => string '005' (length=3)
  116. 'doorid' => string '1' (length=1)
  117. 'readerid' => string '1' (length=1)
  118. 'readername' => string 'Vartai IN' (length=9)
  119. 'cardno' => string '05910680' (length=8)
  120. 'companyname' => string 'Baltijos brasta' (length=15)
  121. 'departname' => string 'Logistika' (length=9)
  122. 'cardeventdate' => string '20090116' (length=8)
  123. 'cardeventtime' => string '123715' (length=6)
  124. 8 =>
  125. array (size=13)
  126. 'personid' => string 'dublikatas' (length=10)
  127. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  128. 'familyname' => string '' (length=0)
  129. 'portid' => string '01' (length=2)
  130. 'boardid' => string '005' (length=3)
  131. 'doorid' => string '1' (length=1)
  132. 'readerid' => string '2' (length=1)
  133. 'readername' => string 'Vartai OUT' (length=10)
  134. 'cardno' => string '05910680' (length=8)
  135. 'companyname' => string 'Baltijos brasta' (length=15)
  136. 'departname' => string 'Logistika' (length=9)
  137. 'cardeventdate' => string '20090116' (length=8)
  138. 'cardeventtime' => string '170935' (length=6)
  139. 9 =>
  140. array (size=13)
  141. 'personid' => string 'dublikatas' (length=10)
  142. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  143. 'familyname' => string '' (length=0)
  144. 'portid' => string '01' (length=2)
  145. 'boardid' => string '005' (length=3)
  146. 'doorid' => string '1' (length=1)
  147. 'readerid' => string '1' (length=1)
  148. 'readername' => string 'Vartai IN' (length=9)
  149. 'cardno' => string '05910680' (length=8)
  150. 'companyname' => string 'Baltijos brasta' (length=15)
  151. 'departname' => string 'Logistika' (length=9)
  152. 'cardeventdate' => string '20090119' (length=8)
  153. 'cardeventtime' => string '080549' (length=6)
  154. 10 =>
  155. array (size=13)
  156. 'personid' => string 'dublikatas' (length=10)
  157. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  158. 'familyname' => string '' (length=0)
  159. 'portid' => string '01' (length=2)
  160. 'boardid' => string '005' (length=3)
  161. 'doorid' => string '1' (length=1)
  162. 'readerid' => string '1' (length=1)
  163. 'readername' => string 'Vartai IN' (length=9)
  164. 'cardno' => string '05910680' (length=8)
  165. 'companyname' => string 'Baltijos brasta' (length=15)
  166. 'departname' => string 'Logistika' (length=9)
  167. 'cardeventdate' => string '20090119' (length=8)
  168. 'cardeventtime' => string '102301' (length=6)
  169. 11 =>
  170. array (size=13)
  171. 'personid' => string 'dublikatas' (length=10)
  172. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  173. 'familyname' => string '' (length=0)
  174. 'portid' => string '01' (length=2)
  175. 'boardid' => string '005' (length=3)
  176. 'doorid' => string '1' (length=1)
  177. 'readerid' => string '2' (length=1)
  178. 'readername' => string 'Vartai OUT' (length=10)
  179. 'cardno' => string '05910680' (length=8)
  180. 'companyname' => string 'Baltijos brasta' (length=15)
  181. 'departname' => string 'Logistika' (length=9)
  182. 'cardeventdate' => string '20090119' (length=8)
  183. 'cardeventtime' => string '171749' (length=6)
  184. 12 =>
  185. array (size=13)
  186. 'personid' => string 'dublikatas' (length=10)
  187. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  188. 'familyname' => string '' (length=0)
  189. 'portid' => string '01' (length=2)
  190. 'boardid' => string '005' (length=3)
  191. 'doorid' => string '1' (length=1)
  192. 'readerid' => string '1' (length=1)
  193. 'readername' => string 'Vartai IN' (length=9)
  194. 'cardno' => string '05910680' (length=8)
  195. 'companyname' => string 'Baltijos brasta' (length=15)
  196. 'departname' => string 'Logistika' (length=9)
  197. 'cardeventdate' => string '20090120' (length=8)
  198. 'cardeventtime' => string '075647' (length=6)
  199. 13 =>
  200. array (size=13)
  201. 'personid' => string 'dublikatas' (length=10)
  202. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  203. 'familyname' => string '' (length=0)
  204. 'portid' => string '01' (length=2)
  205. 'boardid' => string '005' (length=3)
  206. 'doorid' => string '1' (length=1)
  207. 'readerid' => string '2' (length=1)
  208. 'readername' => string 'Vartai OUT' (length=10)
  209. 'cardno' => string '05910680' (length=8)
  210. 'companyname' => string 'Baltijos brasta' (length=15)
  211. 'departname' => string 'Logistika' (length=9)
  212. 'cardeventdate' => string '20090120' (length=8)
  213. 'cardeventtime' => string '113503' (length=6)
  214. 14 =>
  215. array (size=13)
  216. 'personid' => string 'dublikatas' (length=10)
  217. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  218. 'familyname' => string '' (length=0)
  219. 'portid' => string '01' (length=2)
  220. 'boardid' => string '005' (length=3)
  221. 'doorid' => string '1' (length=1)
  222. 'readerid' => string '1' (length=1)
  223. 'readername' => string 'Vartai IN' (length=9)
  224. 'cardno' => string '05910680' (length=8)
  225. 'companyname' => string 'Baltijos brasta' (length=15)
  226. 'departname' => string 'Logistika' (length=9)
  227. 'cardeventdate' => string '20090120' (length=8)
  228. 'cardeventtime' => string '132655' (length=6)
  229. 15 =>
  230. array (size=13)
  231. 'personid' => string 'dublikatas' (length=10)
  232. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  233. 'familyname' => string '' (length=0)
  234. 'portid' => string '01' (length=2)
  235. 'boardid' => string '005' (length=3)
  236. 'doorid' => string '1' (length=1)
  237. 'readerid' => string '2' (length=1)
  238. 'readername' => string 'Vartai OUT' (length=10)
  239. 'cardno' => string '05910680' (length=8)
  240. 'companyname' => string 'Baltijos brasta' (length=15)
  241. 'departname' => string 'Logistika' (length=9)
  242. 'cardeventdate' => string '20090120' (length=8)
  243. 'cardeventtime' => string '171318' (length=6)
  244. 16 =>
  245. array (size=13)
  246. 'personid' => string 'dublikatas' (length=10)
  247. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  248. 'familyname' => string '' (length=0)
  249. 'portid' => string '01' (length=2)
  250. 'boardid' => string '005' (length=3)
  251. 'doorid' => string '1' (length=1)
  252. 'readerid' => string '1' (length=1)
  253. 'readername' => string 'Vartai IN' (length=9)
  254. 'cardno' => string '05910680' (length=8)
  255. 'companyname' => string 'Baltijos brasta' (length=15)
  256. 'departname' => string 'Logistika' (length=9)
  257. 'cardeventdate' => string '20090121' (length=8)
  258. 'cardeventtime' => string '075841' (length=6)
  259. 17 =>
  260. array (size=13)
  261. 'personid' => string 'dublikatas' (length=10)
  262. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  263. 'familyname' => string '' (length=0)
  264. 'portid' => string '01' (length=2)
  265. 'boardid' => string '005' (length=3)
  266. 'doorid' => string '1' (length=1)
  267. 'readerid' => string '2' (length=1)
  268. 'readername' => string 'Vartai OUT' (length=10)
  269. 'cardno' => string '05910680' (length=8)
  270. 'companyname' => string 'Baltijos brasta' (length=15)
  271. 'departname' => string 'Logistika' (length=9)
  272. 'cardeventdate' => string '20090121' (length=8)
  273. 'cardeventtime' => string '110322' (length=6)
  274. 18 =>
  275. array (size=13)
  276. 'personid' => string 'dublikatas' (length=10)
  277. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  278. 'familyname' => string '' (length=0)
  279. 'portid' => string '01' (length=2)
  280. 'boardid' => string '005' (length=3)
  281. 'doorid' => string '1' (length=1)
  282. 'readerid' => string '1' (length=1)
  283. 'readername' => string 'Vartai IN' (length=9)
  284. 'cardno' => string '05910680' (length=8)
  285. 'companyname' => string 'Baltijos brasta' (length=15)
  286. 'departname' => string 'Logistika' (length=9)
  287. 'cardeventdate' => string '20090121' (length=8)
  288. 'cardeventtime' => string '122253' (length=6)
  289. 19 =>
  290. array (size=13)
  291. 'personid' => string 'dublikatas' (length=10)
  292. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  293. 'familyname' => string '' (length=0)
  294. 'portid' => string '01' (length=2)
  295. 'boardid' => string '005' (length=3)
  296. 'doorid' => string '1' (length=1)
  297. 'readerid' => string '2' (length=1)
  298. 'readername' => string 'Vartai OUT' (length=10)
  299. 'cardno' => string '05910680' (length=8)
  300. 'companyname' => string 'Baltijos brasta' (length=15)
  301. 'departname' => string 'Logistika' (length=9)
  302. 'cardeventdate' => string '20090121' (length=8)
  303. 'cardeventtime' => string '170634' (length=6)
  304. 20 =>
  305. array (size=13)
  306. 'personid' => string 'dublikatas' (length=10)
  307. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  308. 'familyname' => string '' (length=0)
  309. 'portid' => string '01' (length=2)
  310. 'boardid' => string '005' (length=3)
  311. 'doorid' => string '1' (length=1)
  312. 'readerid' => string '1' (length=1)
  313. 'readername' => string 'Vartai IN' (length=9)
  314. 'cardno' => string '05910680' (length=8)
  315. 'companyname' => string 'Baltijos brasta' (length=15)
  316. 'departname' => string 'Logistika' (length=9)
  317. 'cardeventdate' => string '20090122' (length=8)
  318. 'cardeventtime' => string '075600' (length=6)
  319. 21 =>
  320. array (size=13)
  321. 'personid' => string 'dublikatas' (length=10)
  322. 'name' => string 'BoguslauskienÄ— Asta' (length=20)
  323. 'familyname' => string '' (length=0)
  324. 'portid' => string '01' (length=2)
  325. 'boardid' => string '005' (length=3)
  326. 'doorid' => string '1' (length=1)
  327. 'readerid' => string '2' (length=1)
  328. 'readername' => string 'Vartai OUT' (length=10)
  329. 'cardno' => string '05910680' (length=8)
  330. 'companyname' => string 'Baltijos brasta' (length=15)
  331. 'departname' => string 'Logistika' (length=9)
  332. 'cardeventdate' => string '20090122' (length=8)
  333. 'cardeventtime' => string '170847' (length=6)
  334.  
  335. foreach ($prafiltruotas_cardeventtime as $k => $value)
  336. {
  337. if ($value['readerid'] == 1 || $value['readerid']==3) { $veiksmas = 'atejo'; }
  338. elseif ($value['readerid'] == 2 || $value['readerid']==4) { $veiksmas = 'isejo'; }
  339. //elseif ($k % $count);
  340.  
  341. $atvikimas[$value['personid']][$value['cardeventdate']][$veiksmas] = $value['cardeventtime'];
  342. }
  343.  
  344.  
  345. $isd = array();
  346. $virs = array();
  347. foreach ($atvikimas as $k1 => $value1) { $sum = 0; $virsval = 0; $diff = 0;
  348. foreach ($value1 as $k2 => $value2) {
  349. if (isset($value2['isejo']) && isset($value2['atejo'])) {
  350. $date_atejo = new DateTime($k2.$value2['atejo']);
  351.  
  352. $date_isejo = new DateTime($k2.$value2['isejo']);
  353. $diff = abs(strtotime($date_isejo->format('Y-m-d H:i:s')) - strtotime($date_atejo->format('Y-m-d H:i:s'))); }
  354. if ($diff > 28800) { $virsval += ($diff - 28800); } $sum += $diff; }
  355. $timef = $model->secondsToTime($sum); $timefv = $model->secondsToTime($virsval);
  356. $isd[$k1] = $timef['h'].':'.$timef['m'].':'.$timef['s'];
  357. $virs[$k1] = $timefv['h'].':'.$timefv['m'].':'.$timefv['s']; }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!