Êþº¾ 3E %com/hxzkoa/services/AttendanceService java/lang/Object em !Ljavax/persistence/EntityManager; RuntimeVisibleAnnotations &Ljavax/persistence/PersistenceContext; cs #Lcom/hxzkoa/services/CaozuoService; 8Lorg/springframework/beans/factory/annotation/Autowired; <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 0 2 4 3 javax/persistence/EntityManager 5 6 createNativeQuery -(Ljava/lang/String;)Ljavax/persistence/Query; 8 start
|
( : ; < valueOf (I)Ljava/lang/Integer; > @ ? javax/persistence/Query A B setParameter ?(Ljava/lang/String;Ljava/lang/Object;)Ljavax/persistence/Query; D end > F G H getResultList ()Ljava/util/List; J java/util/ArrayList
|
I M O N java/util/List P Q size ()I M S T U get (I)Ljava/lang/Object; W [Ljava/lang/Object; Y com/hxzkoa/json/vo_kaoqin_p
|
X
|
( \ ] Q intValue
|
X _ ` a setId (I)V c
|
e f toString
|
X h i j setArea (Ljava/lang/String;)V
|
X l m j setName
|
X o p j setBumen
|
X r s j setTagid
|
X u v j setIntime
|
X x y j setBeizhu
|
X { | j setPower M ~ 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_gongzhong > getSingleResult ()Ljava/lang/Object; realAttendance_delete ([Ljava/lang/String;)V :Lorg/springframework/transaction/annotation/Transactional; )DELETE FROM tb_realkaoqing WHERE id = :id
|
¢ tb_realkaoqing
|
¤ ¦ ¥ !com/hxzkoa/services/CaozuoService § ¨ tb_caozuo (Ljava/lang/String;I)V ª id > ¬ Q 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;>; ¿ "SELECT bumen,num FROM tb_gongzhong Á java/util/HashMap
|
À
|
Ä Q Æ È Ç 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
|
X ä å j
|
setOuttime
|
X ç è j
|
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 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 ÷
|
tb_kaoqing 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) tb_tag area
|
com/hxzkoa/json/tb_realkaoqing getArea name
|
getName bumen
|
getBumen
|
getTagid beizhu
|
getBeizhu Lcom/hxzkoa/json/tb_realkaoqing; getRealtongjiType #SELECT type_name,num FROM tb_tongji getRealshishiType /()Ljava/util/List<Lcom/hxzkoa/json/tb_shishi;>;! SELECT type,num FROM tb_shishi# com/hxzkoa/json/tb_shishi
|
"
|
"& ' j setType
|
") * j setNum
|
shishilist shi Lcom/hxzkoa/json/tb_shishi; -Ljava/util/List<Lcom/hxzkoa/json/tb_shishi;>; gettongjishuju &()Ljava/util/List<Ljava/lang/Object;>; rMap zong $Ljava/util/List<Ljava/lang/String;>; %Ljava/util/List<Ljava/lang/Integer;>; $Ljava/util/List<Ljava/lang/Object;>; getgongzhongnum
|
gongzhongk gongzhong getgaojingnum '()Ljava/util/List<Ljava/lang/Integer;>;< æªå¤ç> XSELECT type,count(1) c FROM tb_warning WHERE status = :str GROUP BY type ORDER BY c DESC@ str gaojing
|
SourceFile AttendanceService.java (Lorg/springframework/stereotype/Service; !
|
/ *· ± ! Ý Y¸ ¸ !¸ '=d h> 6::-:*´ /¹ 1 :7 ¸ 9¹ = WC¸ 9¹ = W¹ E :» IY· K:¹ L ô6 § â ¹ R À V:
|
» XY· Z:
|
2À (¶ [¶ ^
|
2Ç b§
|
|
2¶ d¶ g
|
2Ç b§
|
|
2¶ d¶ k
|
2Ç b§
|
|
2¶ d¶ n
|
2Ç b§
|
|
2¶ d¶ q
|
2Ç b§
|
|
2¶ d¶ t
|
2Ç b§
|
2¶ d¶ w
|
2Ç b§
|
2¶ d¶ z ¹ } W ¹ L ¡ÿ° j ( ) * + , / 0 , 1 : 2 I 3 R 4 [ 5 e 6 k 7 y 8 9 : © ; Á < Ù = ñ > ?# @= AG 6V D z Y Y M G 8 D D A >
R [ þ h î y Î W
|
Å [ þ p ÿ k
|
> M M ÿ 3 > M M V X Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X ù ú Q m LML*´ /+¹ 1 M,¹ ¶ d¸ '¬ H I J K L
â KMN6§ <+2¸ '6M*´ ¡¶ £*´ /,¹ 1 N-©¸ 9¹ = W-¹ « W+¾¡ÿñ . Q R S
|
T U V W + X 9 Y @ S J [ > K K ® ¯ I G
C - ª þ
|
>8 ° z $LM±L*´ ¡¶ £*´ /+¹ 1 M,¹ « W± _ ` a b c d # e $ "
³ ´ µ x +MN¶M*´ /,¹ 1 N-¸+¹ = W-¹ E :» IY· K:¹ L ô6§ â¹ R À V:» XY· Z:2À (¶ [¶ ^2Ç b§
|
2¶ d¶ g2Ç b§
|
2¶ d¶ k2Ç b§
|
2¶ d¶ n2Ç b§
|
2¶ d¶ q2Ç b§
|
2¶ d¶ t2Ç b§ 2¶ d¶ w2Ç b§ 2¶ d¶ z¹ } W¹ L ¡ÿ° Z h i j k l m $ n - o 7 p = q K r T s c t { u v « w à x Û y õ z { p( ~ \ + + º ) '
$ - þ : î K Î W T Å - þ g ÿ = > M M ÿ 3 > M M V X Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X ù ú » ¼ ½ 7 hLM¾L*´ /+¹ 1 M,¹ E N» ÀY· Â:*¶ Ã66§ /-¹ R À V:2¶ d2¶ d¸ '¸ 9¹ Å W-¹ L ¡ÿÌ° 2
" ( . ; W e R h f d
O " F Ë Ì ( @ Í + : ; W " F Ë Î ÿ . > M Æ + Ï ç ELMNÐL*´ /+¹ 1 M,¹ E :¹ L ¹ R À V:² Ò¶ Ø2¶ dN-° . & ¡ 3 ¢ ; £ C ¥ > E C A
? Þ ) 3 W ÿ C > M ß H à Ë QLMáL*´ /+¹ 1 M,¹ E N» IY· K:-¹ L &6§-¹ R À V:» XY· Z:2À (¶ [¶ ^2Ç b§
|
2¶ d¶ g2Ç b§
|
2¶ d¶ k2Ç b§
|
2¶ d¶ n2Ç b§
|
2¶ d¶ q2Ç b§
|
2¶ d¶ t2Ç b§ 2¶ d¶ ã2Ç b§ 2¶ d¶ æ2Ç b§ 2¶ d¶ w 2Ç b§ 2¶ d¶ z¹ } W-¹ L ¡þæ° ^ © ª « ¬ ® " ¯ + ° 1 ± > ² G ³ V ´ n µ ¶ · ¶ ¸ Î ¹ è º » ¼6 ½@ °N À R Q O M
8 "/ é . > W G ù ê "/ é ÿ 1 > M M ÿ 2 > M M V X Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X ù ú
|
ß o ¸ ¸ !¸ '=d h> 6::ë:*´ /¹ 1 :7 ¸ 9¹ = WC¸ 9¹ = W¹ E :» IY· K:¹ L (6 § ¹ R À V:
|
» XY· Z:
|
2À (¶ [¶ ^
|
2Ç b§
|
|
2¶ d¶ g
|
2Ç b§
|
|
2¶ d¶ k
|
2Ç b§
|
|
2¶ d¶ n
|
2Ç b§
|
|
2¶ d¶ q
|
2Ç b§
|
|
2¶ d¶ t
|
2Ç b§
|
2¶ d¶ ã
|
2Ç b§
|
2¶ d¶ æ
|
2Ç b§
|
2¶ d¶ w
|
2Ç b§
|
2¶ d¶ z ¹ } W ¹ L ¡þä° r Ä Å Æ Ç È É Ê , Ë : Ì I Í R Î [ Ï e Ð k Ñ y Ò Ó Ô © Õ Á Ö Ù × ñ Ø Ù# Ú= ÛW Üq Ý{ Ð à z { 8 x D u r
R; [2 é h" y W
|
ù ê [2 é Æ ÿ k
|
> M M ÿ 3 > M M V X Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X ù ú í ´ µ _MNîM*´ /,¹ 1 N-¸+¹ = W-¹ E :» IY· K:¹ L (6§¹ R À V:» XY· Z:2À (¶ [¶ ^2Ç b§
|
2¶ d¶ g2Ç b§
|
2¶ d¶ k2Ç b§
|
2¶ d¶ n2Ç b§
|
2¶ d¶ q2Ç b§
|
2¶ d¶ t2Ç b§ 2¶ d¶ ã2Ç b§ 2¶ d¶ æ2Ç b§ 2¶ d¶ w 2Ç b§ 2¶ d¶ z¹ } W¹ L ¡þä° b ä å æ ç è é $ ê - ë 7 ì = í K î T ï c ð { ñ ò « ó Ã ô Û õ õ ö ÷) øC ùM ì\ ü \ _ _ º ] [
$; -2 é :" K W T ù ê -2 é » ÿ = > M M ÿ 3 > M M V X Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X P Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X Q Xÿ > M M V X X ù ú ð Q m LMñL*´ /+¹ 1 M,¹ ¶ d¸ '¬
ó â KMN6§ <+2¸ '6ôM*´ ö¶ £*´ /,¹ 1 N-©¸ 9¹ = W-¹ « W+¾¡ÿñ .
|
|
+ 9 @ J > K K ® ¯ I G
C - ª þ
|
>8 ø z $LMùL*´ ö¶ £*´ /+¹ 1 M,¹ « W± # $ "
û ü ê lMNýM*´ ÿ¶ £*´ /,¹ 1 N-+¶¹ = W-+¶
|
¹ = W- +¶¹ = W-¸+¶¹ = W-+¶¹ = W-¹ « 6¬ 2 ! " # $ % & *' 8( F) S* a+ i, 4 l l j h
i ¼ ½ # cLM L*´ /+¹ 1 M,¹ E N» ÀY· Â:6§ /-¹ R À V:2¶ d2¶ d¸ '¸ 9¹ Å W-¹ L ¡ÿÌ° . = > ? @ A B #C )D 6E RC `G H c a _
I # @ Ë Ì & : 6 W # @ Ë Î ÿ ) > M Æ + H Ì LM L*´ /+¹ 1 M,¹ E N» IY· K:6§ V»"Y·$:-¹ R À V:2Ç b§
|
2¶ d¶%2Ç b§
|
2¶ d¶(¹ } W-¹ L ¡ÿ¥° : K L M N O P #Q )R 2S ?T WU oV yQ X R
p # g+ & a 2 G,- ? : W # g+. ÿ ) > M M ÿ # > M M" V "ÿ > M M" V " P"ÿ > M M" V " ù / H 0 LM L*´ /+¹ 1 M,¹ E N» IY· K:» IY· K:6§ 7-¹ R À V:2¶ d¹ } W2¶ d¸ '¸ 9¹ } W-¹ L ¡ÿÄ» IY· K:¹ } W¹ } W° B \ ] ^ _ ` a #b ,c 2d ?e Nf cc qh zi j k \
w # n1 , e Ë / B ? $ W z 2 # n13 , e Ë4 z 25 ÿ 2 > M M M 3 6 H 0 LM¾L*´ /+¹ 1 M,¹ E N» IY· K:» IY· K:-¹ L d6§ 7-¹ R À V:2¶ d¹ } W2¶ d¸ '¸ 9¹ } WÿÿÊ» IY· K:¹ } W¹ } W° B o p q r s t "u +v 8w Ex Ty iv q{ z| } ~ \
x " o7 + f8 5 < E $ W z 2 " o73 + f84 z 25 ÿ 8 > M M M 3 9 H : P wLM;N=L*´ /+¹ 1 M,?-¹ = W,¹ E :» IY· K:¹ L d6§ )¹ R À V:2¶ d¸ '¸ 9¹ } Wÿÿز Ò¶ Ø° :
" * 3 A O d l t R w u s
o@ * M 3 DA > . O W 3 DA4 ÿ A > M M % B C D
|
