Êþº¾ 3 %com/hxzkoa/services/AttendanceService java/lang/Object em !Ljavax/persistence/EntityManager; RuntimeVisibleAnnotations &Ljavax/persistence/PersistenceContext; <init> ()V Code
|
|
LineNumberTable LocalVariableTable this 'Lcom/hxzkoa/services/AttendanceService; getRealAttendance (I)Ljava/util/List; Signature 2(I)Ljava/util/List<Lcom/hxzkoa/json/vo_kaoqin_p;>;
|
com/hxzkoa/util/Config getPageConfig ()Ljava/lang/String; perPage
|
! com/hxzkoa/util/ModifyConfig " # readData 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
% ' & java/lang/Integer ( ) parseInt (Ljava/lang/String;)I + SELECT rk.id, rk.area, rk.name, rk.bumen, rk.tagid, rk.intime, rk.beizhu, t.power FROM tb_realkaoqing rk, tb_tag t WHERE rk.tagid = t.tag_id LIMIT :start,:end - / 1 0 javax/persistence/EntityManager 2 3 createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; 5 start
|
% 7 8 9 valueOf (I)Ljava/lang/Integer; ; = < javax/persistence/Query > ? setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; A end ; C D E getResultList ()Ljava/util/List; G java/util/ArrayList
|
F J L K java/util/List M N size ()I J P Q R get (I)Ljava/lang/Object; T [Ljava/lang/Object; V com/hxzkoa/json/vo_kaoqin_p
|
U
|
% Y Z N intValue
|
U \ ] ^ setId (I)V `
|
b c toString
|
U e f g setArea (Ljava/lang/String;)V
|
U i j g setName
|
U l m g setBumen
|
U o p g setTagid
|
U r s g setIntime
|
U u v g setBeizhu
|
U x y g setPower J { | } add (Ljava/lang/Object;)Z page I sql Ljava/lang/String; query Ljavax/persistence/Query;
|
resultList Ljava/util/List; tb_realkaoqingList i obj realkaoqing Lcom/hxzkoa/json/vo_kaoqin_p; LocalVariableTypeTable /Ljava/util/List<Lcom/hxzkoa/json/vo_kaoqin_p;>; StackMapTable java/lang/String getRealAttendanceCount #SELECT count(1) FROM tb_realkaoqing ; getSingleResult ()Ljava/lang/Object; realAttendance_delete ([Ljava/lang/String;)V :Lorg/springframework/transaction/annotation/Transactional; )DELETE FROM tb_realkaoqing WHERE id = :id id ; N executeUpdate checkVal [Ljava/lang/String; realAttendance_deleteAll ¥ DELETE FROM tb_realkaoqing searchRealAttendance $(Ljava/lang/String;)Ljava/util/List; C(Ljava/lang/String;)Ljava/util/List<Lcom/hxzkoa/json/vo_kaoqin_p;>; ª ¢SELECT rk.id, rk.area, rk.name, rk.bumen, rk.tagid, rk.intime, rk.beizhu, t.power FROM tb_realkaoqing rk, tb_tag t WHERE rk.tagid = t.tag_id AND rk.tagid = :tagid ¬ tagid input getRealAttendanceType ()Ljava/util/Map; 8()Ljava/util/Map<Ljava/lang/String;Ljava/lang/Integer;>; ² HSELECT area,count(1) c FROM tb_realkaoqing GROUP BY area ORDER BY c DESC ´ java/util/HashMap
|
³
|
· N ¹ » º java/util/Map ¼ ½ put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; ¿ å
¶ä» reMap Ljava/util/Map; realAttendanceCount 6Ljava/util/Map<Ljava/lang/String;Ljava/lang/Integer;>; getPeople Æ Iselect area,count('åå
¬å®¤') as count from tb_realkaoqing group by area È Ê É java/lang/System Ë Ì out Ljava/io/PrintStream;
|
Î Ð Ï java/io/PrintStream Ñ Ò print (Ljava/lang/Object;)V people getHistoricalAttendance 1()Ljava/util/List<Lcom/hxzkoa/json/vo_kaoqin_p;>; × SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t WHERE k.tagid = t.tag_id
|
U Ù Ú g
|
setOuttime
|
U Ü Ý g
|
setAlltime tb_kaoqingList kaoqing á SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t WHERE k.tagid = t.tag_id LIMIT :start,:end searchHistoricalAttendance ä SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t WHERE k.tagid = t.tag_id AND k.tagid = :tagid getHistoricalAttendanceCount ç SELECT count(1) FROM tb_kaoqing historicalAttendance_delete ê %DELETE FROM tb_kaoqing WHERE id = :id historicalAttendance_deleteAll í DELETE FROM tb_kaoqing realAttendance_add #(Lcom/hxzkoa/json/tb_realkaoqing;)I ñ gINSERT INTO tb_tag(area,name,bumen,tagid,intime,beizhu) VALUES(:area,:name,:bumen,:tagid,now(),:beizhu) ó area
|
õ ÷ ö com/hxzkoa/json/tb_realkaoqing ø getArea ú name
|
õ ü ý getName ÿ bumen
|
õ getBumen
|
õ getTagid beizhu
|
õ
|
getBeizhu Lcom/hxzkoa/json/tb_realkaoqing;
|
SourceFile AttendanceService.java (Lorg/springframework/stereotype/Service; !
|
/ *· ± Ý Y¸ ¸ ¸ $=d h> 6::*:*´ ,¹ . :4 ¸ 6¹ : W@¸ 6¹ : W¹ B :» FY· H:¹ I ô6 § â ¹ O À S:
|
» UY· W:
|
2À %¶ X¶ [
|
2Ç _§
|
|
2¶ a¶ d
|
2Ç _§
|
|
2¶ a¶ h
|
2Ç _§
|
|
2¶ a¶ k
|
2Ç _§
|
|
2¶ a¶ n
|
2Ç _§
|
|
2¶ a¶ q
|
2Ç _§
|
2¶ a¶ t
|
2Ç _§
|
2¶ a¶ w ¹ z W ¹ I ¡ÿ° j $ % & ' ( + , , - : . I / R 0 [ 1 e 2 k 3 y 4 5 6 © 7 Á 8 Ù 9 ñ : ;# <= =G 2V @ z Y Y ~ M G 5 D A A > R
[ þ
h î y Î T
|
Å [ þ p ÿ k
|
; J J ÿ 3 ; J J S U Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U ù ú N m LML*´ ,+¹ . M,¹ ¶ a¸ $¬ D E F G H Ô AMN6§ 2+2¸ $6M*´ ,,¹ . N-¸ 6¹ : W-¹ W+¾¡ÿͱ *
|
M N O
|
P Q R ! S / T 6 O @ V > A A ¡ ¢ ? = 9 # þ
|
;. £
|
l LM¤L*´ ,+¹ . M,¹ W± Z [ \ ] ^ _ ¦ § ¨ x +MN©M*´ ,,¹ . N-«+¹ : W-¹ B :» FY· H:¹ I ô6§ â¹ O À S:» UY· W:2À %¶ X¶ [2Ç _§
|
2¶ a¶ d2Ç _§
|
2¶ a¶ h2Ç _§
|
2¶ a¶ k2Ç _§
|
2¶ a¶ n2Ç _§
|
2¶ a¶ q2Ç _§ 2¶ a¶ t2Ç _§ 2¶ a¶ w¹ z W¹ I ¡ÿ° Z b c d e f g $ h - i 7 j = k K l T m c n { o p « q à r Û s õ t u j( x \ + + ) ' $
- þ
: î K Î T T Å - þ g ÿ = ; J J ÿ 3 ; J J S U Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U ù ú ® ¯ ° Ù ËLM±L*´ ,+¹ . M,¹ B N» ³Y· µ:*¶ ¶6-¹ I ¤ \6§ >-¹ O À S:2¶ a2¶ a¸ $¸ 6¹ ¸ W2¶ a¸ $d6¡ÿ¾¸ 6¹ ¸ W§ @6§ /-¹ O À S:2¶ a2¶ a¸ $¸ 6¹ ¸ W-¹ I ¡ÿÌ° R | } ~ " ( 2 8
E a p y º È f
|
Ë É Ç ²
" © À Á ( £ Â 5 D E + T : T " © À Ã & ÿ 8 ; J ¹ :ú ü +ú
|
Ä ç ELMNÅL*´ ,+¹ . M,¹ B :¹ I ¹ O À S:² Ƕ Í2¶ aN-° . & 3 ; C > E C A ? Ó )
3 T ÿ C ; J Ô E Õ Ë QLMÖL*´ ,+¹ . M,¹ B N» FY· H:-¹ I &6§-¹ O À S:» UY· W:2À %¶ X¶ [2Ç _§
|
2¶ a¶ d2Ç _§
|
2¶ a¶ h2Ç _§
|
2¶ a¶ k2Ç _§
|
2¶ a¶ n2Ç _§
|
2¶ a¶ q2Ç _§ 2¶ a¶ Ø2Ç _§ 2¶ a¶ Û2Ç _§ 2¶ a¶ t 2Ç _§ 2¶ a¶ w¹ z W-¹ I ¡þæ° ^ £ ¤ ¥ ¦ § ¨ " © + ª 1 « > ¬ G V ® n ¯ ° ± ¶ ² Î ³ è ´ µ ¶6 ·@ ªN º R Q O M 8
"/ Þ
. > T G ù ß "/ Þ ÿ 1 ; J J ÿ 2 ; J J S U Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U ù ú
|
Ô o ¸ ¸ ¸ $=d h> 6::à:*´ ,¹ . :4 ¸ 6¹ : W@¸ 6¹ : W¹ B :» FY· H:¹ I (6 § ¹ O À S:
|
» UY· W:
|
2À %¶ X¶ [
|
2Ç _§
|
|
2¶ a¶ d
|
2Ç _§
|
|
2¶ a¶ h
|
2Ç _§
|
|
2¶ a¶ k
|
2Ç _§
|
|
2¶ a¶ n
|
2Ç _§
|
|
2¶ a¶ q
|
2Ç _§
|
2¶ a¶ Ø
|
2Ç _§
|
2¶ a¶ Û
|
2Ç _§
|
2¶ a¶ t
|
2Ç _§
|
2¶ a¶ w ¹ z W ¹ I ¡þä° r ¾ ¿ À Á Â Ã Ä , Å : Æ I Ç R È [ É e Ê k Ë y Ì Í Î © Ï Á Ð Ù Ñ ñ Ò Ó# Ô= ÕW Öq ×{ Ê Ú z ~ { 5 x A u r R;
[2 Þ
h" y T
|
ù ß [2 Þ Æ ÿ k
|
; J J ÿ 3 ; J J S U Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U ù ú â § ¨ _MNãM*´ ,,¹ . N-«+¹ : W-¹ B :» FY· H:¹ I (6§¹ O À S:» UY· W:2À %¶ X¶ [2Ç _§
|
2¶ a¶ d2Ç _§
|
2¶ a¶ h2Ç _§
|
2¶ a¶ k2Ç _§
|
2¶ a¶ n2Ç _§
|
2¶ a¶ q2Ç _§ 2¶ a¶ Ø2Ç _§ 2¶ a¶ Û2Ç _§ 2¶ a¶ t 2Ç _§ 2¶ a¶ w¹ z W¹ I ¡þä° b Þ ß à á â ã $ ä - å 7 æ = ç K è T é c ê { ë ì « í Ã î Û ï õ ð ñ) òC óM æ\ ö \ _ _ ] [ $;
-2 Þ
:" K T T ù ß -2 Þ » ÿ = ; J J ÿ 3 ; J J S U Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U P Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U Q Uÿ ; J J S U U ù ú å N m LMæL*´ ,+¹ . M,¹ ¶ a¸ $¬ ú û ü ý þ è Ô AMN6§ 2+2¸ $6éM*´ ,,¹ . N-¸ 6¹ : W-¹ W+¾¡ÿͱ *
|
|
! /
|
6 @ > A A ¡ ¢ ? = 9 # þ
|
;. ë
|
l LMìL*´ ,+¹ . M,¹ W± î ï Ù _MNðM*´ ,,¹ . N-ò+¶ ô¹ : W-ù+¶ û¹ : W-þ+¶ ¹ : W-«+¶¹ : W-+¶¹ : W-¹ 6¬ . , 9 F! T" \# 4 _ _ ] [ \
|
