+
    iP                        ^ RI Ht ^ RIHtHt ^ RIHt ^ RIHtH	t	 ^ RI
Ht ^ RIHt ^ RIHt R R	 ltR
 t]! R.4      ]	! ].4      R 4       4       t]! RR.4      ]	! ].4      R 4       4       t]! . RO4      ]	! ].4      R R l4       4       tR# )    )annotations)connectionsDatabaseError)timezone)api_viewpermission_classes)IsAuthenticated)Response)_require_master_adminc                   V ^8  d   QhRR/# )   returndict )formats   "EE:\live-kit-agent\livekit_voicebot\backend\config\master_did_views.py__annotate__r      s      d     c                |    \        \        W4      4      pR V9   d!   VR ,          e   \        VR ,          4      VR &   V# status)r   zipstr)rowcolsds   && r   _row_to_didr      s7    S^A1}80!H+&(Hr   c                 
    . RO# )did_id)r   did_nobot_idbusiness_idr   
changed_by
created_atr   r   r   r   _did_columnsr%      s    ^^r   GETc                   \        V 4      w  rV'       d   V#  \        R ,          P                  4       ;_uu_ 4       pVP                  R4       VP	                  4       ^ ,          pVP                  R4       VP	                  4       ^ ,          pVP                  R4       VP	                  4       ^ ,          pVP                  R4       VP	                  4       ^ ,          pRRR4       \        RRRRXRXRXRX//4      #   + '       g   i     L'; i  \
         d%   p\        RRR\        T4      /R	R
7      u Rp?# Rp?ii ; i)defaultz SELECT COUNT(*) FROM did_numbersz3SELECT COUNT(*) FROM did_numbers WHERE status = '1'z3SELECT COUNT(*) FROM did_numbers WHERE status = '0'zjSELECT COUNT(*) FROM did_numbers WHERE MONTH(created_at) = MONTH(NOW()) AND YEAR(created_at) = YEAR(NOW())NsuccessFmessage  r   Tdatatotalactiveinactive
this_month)r   r   cursorexecutefetchoner   r
   r   )	request_errcurr-   r.   r/   r0   es	   &        r   master_did_statisticsr9      s    #7+FA

K#**,,KK:;LLN1%EKKMN\\^A&FKKMN||~a(HKK| *J - 4Uf*	
   -,  KE9c!f=cJJKs;   #D B!C<D <D	D D D>D93D>9D>POSTc           
        \        V 4      w  rV'       d   V# V P                  R 8X  d    \        R,          P                  4       ;_uu_ 4       pVP	                  R4       VP
                   Uu. uF  qD^ ,          NK  	  ppVP                  4        Uu. uF  p\        We4      NK  	  ppRRR4       \        RR	R
X/4      # \        V P                  \        4      '       d   V P                  M/ p	\        V	P                  R4      ;'       g    R4      P                  4       p
V	P                  R4      pV	P                  R4      p\        V	P                  R4      ;'       g    R4      pV	P                  R4      pV
'       g   \        RRRR/RR7      #  \        R,          P                  4       ;_uu_ 4       pVP	                  RWWV.4       VP                   pVP	                  RV.4       VP
                   Uu. uF  qD^ ,          NK  	  pp\        VP#                  4       V4      pRRR4       \        RR	R
X/^R7      # u upi u upi   + '       g   i     EL; i  \         d%   p\        RRR\        T4      /RR7      u Rp?# Rp?ii ; iu upi   + '       g   i     Lv; i  \         d%   p\        RRR\        T4      /RR7      u Rp?# Rp?ii ; i)r&   r(   ztSELECT did_id, did_no, bot_id, business_id, status, changed_by, created_at FROM did_numbers ORDER BY created_at DESCNr)   Fr*   r+   r   Tr,   
did_number r!   r"   r   1r#   zdid_number is required.i  zxINSERT INTO did_numbers (did_no, bot_id, business_id, status, changed_by, created_at) VALUES (%s, %s, %s, %s, %s, NOW())mSELECT did_id, did_no, bot_id, business_id, status, changed_by, created_at FROM did_numbers WHERE did_id = %s)r   methodr   r1   r2   descriptionfetchallr   r   r
   r   
isinstancer,   r   getstrip	lastrowidr3   )r4   r5   r6   r7   cr   rrowsr8   payloadr    r!   r"   r   r#   new_idr   s   &                r   master_did_collectionrL   9   sl    #7+FA

~~		OY'..00C@ '*oo6o!o669llnEnA,nE 1 D&$788 )t<<gll"G\*00b1779F[["F++m,KX&--#.F\*JE96OPY\]]K#**,,KK5jA
 ]]FKK5
 #&//2/QaDD/D2cllnd3C -" Yfc23??I 7E 100  	OYy#a&A#NN	O: 3 -,  KE9c!f=cJJKs   #I  I-H<>II&I(I #J$ 3AJ6JJ#J$ <
II	I I J	%J>J	J	JJ!	J$ !J$ $K/KKKc                   V ^8  d   QhRR/# )r   r   intr   )r   s   "r   r   r   p   s     >G >Gs >Gr   c           	     d   \        V 4      w  r#V'       d   V#  \        R ,          P                  4       ;_uu_ 4       pVP                  RV.4       VP                   Uu. uF  qU^ ,          NK  	  ppVP                  4       pRRR4       X'       g   \        RRRR/R	R7      # T P                  R
8X  d   \        RRR\        TX4      /4      # T P                  R8X  dP    \        R ,          P                  4       ;_uu_ 4       pTP                  RT.4       RRR4       \        RRRR/4      # \        T P                  \        4      '       d   T P                  M/ p	/ p
RT	9   d$   \        T	R,          4      P                  4       T
R&   RT	9   d   T	R,          T
R&   RT	9   d   T	R,          T
R&   RT	9   d   \        T	R,          4      T
R&   RT	9   d   T	R,          T
R&   T
'       d   RP                  R T
 4       4      p\!        T
P#                  4       4      T.,           p \        R ,          P                  4       ;_uu_ 4       pTP                  RT R2T4       TP                  RT.4       TP                   Uu. uF  qU^ ,          NK  	  pp\        TP                  4       T4      pRRR4       \        RRRXRR/4      # \        RRR\        TX4      /4      # u upi   + '       g   i     ELd; i  \         d%   p\        RRR\        T4      /RR7      u Rp?# Rp?ii ; i  + '       g   i     EL; i  \         d%   p\        RRR\        T4      /RR7      u Rp?# Rp?ii ; iu upi   + '       g   i     L; i  \         d%   p\        RRR\        T4      /RR7      u Rp?# Rp?ii ; i)r(   r?   Nr)   Fr*   r+   r   zDID number not found.i  r&   Tr,   DELETEz)DELETE FROM did_numbers WHERE did_id = %szDID number deleted.r<   r    r!   r"   r   r#   z, c              3  *   "   T F	  q R 2x  K  	  R# 5i)z = %sNr   ).0ks   & r   	<genexpr>$master_did_detail.<locals>.<genexpr>   s     ;FqE{Fs   zUPDATE did_numbers SET z WHERE did_id = %szDID number updated.)r   r   r1   r2   rA   r3   r   r
   r   r@   r   rC   r,   r   rE   joinlistvalues)r4   r   r5   r6   r7   rG   r   r   r8   rJ   fields
set_clauserX   updateds   &&            r   master_did_detailr\   n   sN    #7+FA


K#**,,KK5
 #&//2/QaDD/D2,,.C - E96MNWZ[[~~D&+c42HIJJ~~!	OY'..00CG&R 1 D)5JKLL )t<<gll"GFww|45;;=x7"8,x ' 6}7wx01xw&|4|YY;F;;
fmmo&&1	OY'..00C5j\ASTV\]9H
 '*oo6o!o6%cllnd; 1 D&'9F[\]]Yfk#t.DEFFe 3 -,,  KE9c!f=cJJK 100 	OYy#a&A#NN	O: 7 10  	OYy#a&A#NN	Os   #K0 "KK/KK0 #L6 L"L6 #N   8M-8M(	M-%N  KK-	'K0 -K0 0L;LLL"L3	-L6 3L6 6M%M M% M%(M--M=	8N  =N   N/N*$N/*N/N)r&   PUTPATCHrP   )
__future__r   	django.dbr   r   django.utilsr   rest_framework.decoratorsr   r   rest_framework.permissionsr	   rest_framework.responser
   config.master_business_viewsr   r   r%   r9   rL   r\   r   r   r   <module>rf      s    " 0 ! B 6 , >_ 
5'_%& ' > 
5&/_%&0@ ' 0@f 

+,_%&>G ' ->Gr   