o q c@s<ddlmZddlZddlZddlmZddlmZddlm Z ddl m Z ddl m Z ddl mZdd l mZmZdd lmZdd lmZdd lmZdd lmZmZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm!Z!ddlm"Z"ddlm#Z#ddlm$Z$ddlm%Z%ddl&m'Z'ddl&m(Z(ddl&m)Z)ddl&m*Z*ddl&m+Z+dd l&m,Z,dd!l&m-Z-dd"l&m.Z.dd#l&m/Z/dd$l&m0Z0ddl m Z dd%l&m1Z1dd&l2m3Z3m4Z4m5Z5dd'l6m7Z7ddl8Z8ddl9Z9ddl:Z:dd(l;mZ>ddl?Z?ddl@Z@ddlAZBddl8Z8ddl Z ddlCZCddl=Z=ddl>Z>dd lmZdd)lDmEZEdd*lmFZFd+e?jGd,<ed-gd.d/ZHed-ge7d0d1d2d3ZIed-ge7d0d1d4d5ZJe7d0d1d6d7ZKed8geeEj%fd9d:ZLed-gd;d<ZMed-ge7d0d1d=d>ZNe7d0d1d?d@ZOed8geeEj%fdAdBZPdCdDZQed-gdEdFZRed-gdGdHZSed8geeEj%fdIdJZTed8gdKdLZUed-gdMdNZVed-geeEjfdOdPZWed8geeEj%fdQdRZXed8geeEj%fdSdTZYed-ge7d0d1dUdVZZed-ge7d0d1dWdXZ[dYdZZ\d[d\Z]e7d0d1d]d^Z^e7d0d1d_d`Z_e7d0d1dadbZ`dcddZae7d0d1dedfZbe dgdhZcdidjZde7d0d1dkdlZedmdnZfdodpZge7d0d1dqdrZhdsdtZied8geeEj%fdudvZjed8geeEj%fdwdxZked-gdydzZle7d0d1d{d|Zmd}d~ZnddZoddZpe7d0d1ddZqe7d0d1ddZrddZsddZtddZuddZvddZwe ddZxe ddZyddZzddZ{e7d0d1ddZ|ddZ}e ddZ~ddZe ddZdS))chainN) FileResponse)canvas) csrf_exempt)messages)datetimerender)r redirectResponse)IsAuthenticatedToken)api_viewpermission_classes)RadcheckSerializer)RadgroupreplySerializer)RadacctSerializer)RadusergroupSerializer)PaymentSerializer)BillingPlansSerializer)UserbillinfoSerializer)UserSerializer)BillingHistorySerializer) NasSerializer)InvoiceItemsSerializer)AllowAny) Radusergroup) InvoiceItems)AuthUser) BillingPlans) Radgroupreply)Nas)Radacct) Registration)Payment) Userbillinfo)BillingHistory) authenticateloginlogout)login_required)Radcheck) permissions) JsonResponsetrueDJANGO_ALLOW_ASYNC_UNSAFEGETcCs*ddddddddd d d d d dd}t|S)Nz /user-list/z/user-detail/z /user-create/z/Radusergroup-create/z/user-update/z/user-delete/z/Radgroupreply/z/Radusergroup/z /payment/z/make-payment/z/userbillinfo/z/create-userbillinfo/z /register/z/create_BillingPlans/)listZDetailCreaterupdateDeleteZRad_listzlist-allpaymentz make-payment userbillinfozcreate-userbillinforegistercreate_BillingPlansr )requestZapi_urlsr=5C:\Users\DAVID\Desktop\project\apps\customer\views.py apioverview;s r? auth-login) login_urlcCs2|j}tjj|ddd}t|dd}t|jS)Nz Fixed-Pppoe)planidplantyperadiusTmany)userr"objectsfilterusingrr data)r<idZBillingPlans_data serializerr=r=r>BillingPlans_AllNs  rNcCs&|j}tj}t|dd}t|jSNTrE)rGr rHallrr rK)r<rLInvoiceItems_datarMr=r=r>InvoiceItem_AllUs   rRc Cddlm}|jj|jd}|D].}|}d}dd|i}tj||d}|}t |} dd } | | } || d } t | SdS) NrrrGz'http://127.0.0.1:8000/BillingPlans_All/ Authorizationtoken {}headerscS@d}t|dkr|d7}|d}t|dksd|gd|fSNrirg@@z%.2f%s)KMGTPabsnum magnituder=r=r> human_formath   z+BillingPlans_All_list..human_formatrK count_all rest_framework.authtoken.modelsrrH get_or_createrGformatrequestsgetjsonlenr0 r<rrGtokenmyTokenmyUrlheadresponserKcountrfricontextr=r=r>BillingPlans_All_list]s  rzPOSTcC&t|jd}|r|t|jSNrK)rrKis_validsaver r<rMr=r=r>r;v  r;cC&tjd}t|dd}t|jSNrDTrE)r$rHrPrJrr rK)r<ZNas_datarMr=r=r>Nas_All~s  rcCs tj}t|dd}t|jSrO)r#rHrPrr rK)r<ZRadgroupreply_datarMr=r=r>Radgroupreply_Alls   rc Cshddlm}|jj|jd}|D]!}|}d}dd|i}tj||d}|}d|i} t | SdS) NrrrTz$http://127.0.0.1:8000/Radgroupreply/rUrVrWrK) rkrrHrlrGrmrnrorpr0) r<rrGrsrtrurvrwrKryr=r=r>Radgroupreply_lists  rcCr|r})rrKrrr rr=r=r>create_RadgroupreplyrrcCs|jdkrV|jd}|jd}|jd}|jd}|jd}|jd}|r4tjd|jd |d |d d }|rVtjd |||||||dd|ddd d }t|tjd|dt|dS)Nr{rL package_name package_type rate_limit unit_timepricez+http://127.0.0.1:8000/create_Radgroupreply/zMikrotik-Rate-Limit:=)rL attribute groupnameopvaluerpz*http://127.0.0.1:8000/create_BillingPlans/YesFixed.Ksh) plannamerBrC plantimetypeZplantimerefillCostZplantrafficrefillCostplantraffictotal planrecurringplanrecurringbillingscheduleplancost plancurrency planactivezPackage z add successfully!z plans.html) methodr{rnpostrGr add_messageINFOr )r<rLrrrrrrwr=r=r> plans_lists@          rcCs,|j}tjj|d}t|dd}t|jS)NaddressTrErGr(rHrIrr rK)r<rLZUserbillinfo_datarMr=r=r>Userbillinfo_alls  rcCs.|j}tjj|dd}t|dd}t|jS)NhotspotcompanyleadTrEr)r<rLZ hotspot_datarMr=r=r> hotspot_alls  rcCr|r})rrKrrr rr=r=r>create_userbillinforrcCsx|jdkr:t|jd}i}|r3|}d|d<|j|d<|j|d<tjj |dj }||d<t |S|j }t |SdS) Nr{r~zsuccesfully registeredrwemailusernamerTrs) rrrKrrrrrrHrokeyerrorsr )r<rMrKaccountrsr=r=r> Register_users    rcCs|j}|jdkrtjjddd}t|dd}t|jS|jdkr9tjjddd}t|dd}t|jStjjd|dd}t|dd}t|jS) NZdavid ExpirationrrDTrEadmin)rrL)rGr.rHrIrJrr rK)r<rLZ radcheck_datarMr=r=r>ShowAlls        rcCrr)r'rHrPrJrr rK)r<Z payment_datarMr=r=r> Payment_lists  rcCr|r})rrKrrr rr=r=r> create_userrrcCr|r})rrKrrr rr=r=r>create_RadusergrouprrcC.tjjd|jdd}t|dd}t|jS)NTZPPP)acctstoptime__isnullcalledstationidframedprotocolrEr%rHrIrGget_short_namerr rKr<Z Radacct_datarMr=r=r> Radacct_All   rcCr)NTrr nasportidrrErrr=r=r>Radacct_HotspotrrcCst|jdkr5|jd}|jd}|jd}|jd}|jd}|jd}t||||||djd d td St|d S) Nr{ first_name last_name phone_numberrpasswordconfirm_password)rrrrrrrD)rJr@zauth-register.html)rr{r&rr r )r<rrrrrrr=r=r>Registers        rcCs|jdkr=|jd}|jd}z tjj|d}Wn"t|||d}|dur4t||tdYSt |tj dYt |dS) Nr{rrr)rrcustomerzpPlease enter the correct username and password for a staff account. Note that both fields may be case-sensitive.zauth-login.html) rr{ror&objectr*r+r rrrr )r<rrrGr=r=r>Login#s      rcCsvddl}tjd}tjj||jd}tjj|jd}tjj|jdd}ddl m }tjj|jtjdd }t jjd |j dd }t jjd |j d  |d d} t jjd |j d  |dd} gd} | fdd} | durd} | t| }n| t| }| durd}| t|}n| t| }t|||t|t|t|t|d}t|d|S)Nr%m)Zlastbill__monthrrBrrSum%Y-%m-%d)rZ nextbill__lteTr)rracctinputoctetsacctinputoctets__sumacctoutputoctetsZacctoutputoctets__sum))l z PB)lz TB)i@z GB)iz MB)iz KB)r)z bytez bytescSsV|D] \}}||kr nqt||}t|tr%|\}}|dkr#|}n|}t||S)Nr)int isinstancetuplestr)bytesunitsfactorsuffixamosingularmultipler=r=r> pretty_sizeFs    zcustomer..pretty_size) new_users packets_up packets_downVouchersinternet_plansrexpiredzdashboard.html) timedeltarnowstrftimer(rHrIrGr"django.db.modelsrr%r aggregaterorrqr )r<rmonthrrrrrruploadZdownload UNITS_MAPPINGrZdownload_traficrZ upload_traficrryr=r=r>r2s:  &&    rc Cs"ddlm}ddlm}m}m}m}tjd}t j j ||j d |dd}tjd}t j j ||j d  |dd} t j j tj|d d |j d  |dd} | durld} | || d } |durxd}| || d } | durd} | || d } n| || d } t|d| S)NrrAvgMaxMinr%dZcreationdate__dayrB billamountbillamount__sumrZcreationdate__monthrBdaysZcreationdate__gterB)ritoday last_7dayszdashboard-ecommerce.html)rrrrrrrrrr)rHrIrGrror ) r<rrrrrdayrrsumrryr=r=r> ecommercejs< $$4 rc CrS) NrrrTz"http://127.0.0.1:8000/hotspot_all/rUrVrWcSrYrZrarcr=r=r>rfrgz list_users..human_formatrhrjrrr=r=r> list_userss  rcCst|tdS)Nr@)r,r r<r=r=r> logoutUsersrc C|ddlm}|jj|jd}|D]+}|}d}dd|i}tj||d}|}t |} d| } || d } t | SdS) NrrrTzhttp://127.0.0.1:8000/payment/rUrVrW{:,}rhrj r<rrGrsrtrurvrwrKrxriryr=r=r> payments_list   r c Cs|jdkr|jd}|jd}|jd}|jd}|jd}d}d}|dkr=tj}d }tj|d } || } | d }|d krWtj}d }tj|d } || } | d }|dkrqtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkrtj}d}tj|d } || } | d }|dkr)tj}d}tj|d } || } | d }|dkrDtj}d}tj|d } || } | d }|d kr_tj}d!}tj|d } || } | d }|d"krztj}d#}tj|d } || } | d }|d$krtj}d%}tj|d } || } | d }|d&krtj}d'}tj|d } || } | d }|d(krtj}d)}tj|d } || } | d }|d*krtj}d+}tj|d } || } | d }|d,krtj}d-}tj|d } || } | d }|d.krtj}d/}tj|d } || } | d }|d0kr7tj}d1}tj|d } || } | d }|d2krRtj}d3}tj|d } || } | d }|d4krmtj}d5}tj|d } || } | d }|d4krtj}d6}tj|d } || } | d }|d7krtj}d8}tj|d } || } | d }|d9krtj}d:}tj|d } || } | d }|d;krtj}d<}tj|d } || } | d }|d=krtj}d>}tj|d } || } | d }|d?krtj}d@}tj|d } || } | d }|dAkr*tj}d1}tj|d } || } | d }|dBkrEtj}dC}tj|d } || } | d }|dDkr`tj}dE}tj|d } || } | d }|dFkr{tj}dG}tj|d } || } | d }|rtjdH||dIdJ|dKdL} |rtjdH||dMdJ|dKdL} |rtjdN||ddOdL} |dP} t|||dQ| | |dRdSdT |rt |t j dU|dVt dWSt|dXS)YNr{rLrrnextbillpackager[1hours%d %B %Y %H:%M:%S203H4`5x6789101112 13814P15h16171819202122(23@24X25p262728293031"http://127.0.0.1:8000/user-create/Cleartext-PasswordrrLrrrrrr#http://127.0.0.1:8000/Radusergroup/rrpriorityrr z(.Days))rrrrlastbillr billstatuszVoucher  added successfully!z list-userszdata-list-view.html)rr{rrrrrnrr(rrrrr r ) r<rLrrrrrrcurrent_date_and_time hours_addedfuture_date_and_timerwdater=r=r> hotspot_lists                                                                                                                                 " r_csDddl}ddl|jdfddtdD}d|i}t|S)Nrr[c3s|]}VqdS)N)choice).0ilettersrandomr=r> szvoucher_code..r)stringredigitsjoinranger0)r<rhrryr=rcr> voucher_codes rlc Cr ) NrrrTzhttp://127.0.0.1:8000/nas_all/rUrVrWr rhrjr r=r=r>nas_listr rmcC t|dS)Nznas.htmlrrr=r=r>nas roc CsR|jdkr|jd}|jd}|jd}|jd}|jd}|jd}|jd}|jd }|jd } tj} d } tj| d } | | } | d }|rWtjd||dd|dd}|rftjd||dd|dd}|rstjd||ddd}| d}| d}tjd||||d||| |||d d}|rt |tj d|dt dSt |dS)Nr{rLrrrrphonelocationrpayment_methodrNrrrQrRrrSrrrTrrUrz*http://127.0.0.1:8000/create_userbillinfo/rW) rrr contactpersonrq paymentmethodhotspotlocationrXruser rZ pppoe_listzpppoe_list.html) rr{rrrrrnrrrrr r )r<rLrrrrrqrrrrsr[rr\r]rrwr^rr=r=r>pppoesl                     ryc Cr ) NrrrTz"http://127.0.0.1:8000/userbillinforUrVrWr rhrjr r=r=r>userbillinfo_list r rzcCstj}d}tj|d}||}|d}|d}|d}|j}tj} tj} t jj dd} t jj |d} | D]} | j }| D]}|j }| D] }|j |krX|j| jkrXt| jd| D]}|j|jkrWt||jkr|j}|j}|d}|d}tjd ||t|d d d d d d}t|t|j}|dkrd}tjj | jdj|dqftjj | jdj|dtd|jt jj |jdj|dt jj |jdj||dqft||jkrWt|t|j}|dkr d}tjj | jdj|dqf|j}|j}|d}|d}tjd ||t|d d d d |dd}tjj | jdj|dtd|jt jj |jdj|dt jj |jdj||dqfqNqFq>t|dS)NrPrrrrrrTruez%http://127.0.0.1:8000/BillingHistory/zRefill Session Timez Helios RadiusZMpesa)rrBr billaction billperformer billreasonrurrpk)amountzuser activated succesfullyr)rXr)rrBrr|r}r~ru creationdatez test.html)rrrrrGr'rHrPr"r.rIr(rrrqnotesprintrrrrnrrLr6r )r<r[rr\r]rr^rrLZusers_paymentsZ userbillingusersZbillinfoZall_users_listrZuserbilling_listZ plannamesrPZradgrouprrwbalance new_balancer=r=r>pppoe_paymentss                      :rcCr|r})rrKrrr rr=r=r> Make_paymentfrrcCr|r})rrKrrr rr=r=r>BillingHistory_createnrrcCs(tjj|jd}t|dd}t|jS)NrTrE)r)rHrIrGrr rK)r<ZBillingHistory_datarMr=r=r>BillingHistory_Allvs  rcCsddlm}m}m}m}tjj|jd |d d}|r2d t |}d|dd i}t |Sd}d t |}d|dd i}t |S) Nrrrrrr rirWrrrrrrr)rHrIrGrrormrr0)r<rrrrrriryr=r=r>sum_list{s"   rc Csddlm}m}m}m}tjd}tj j ||j d |d d}|r=dt|}|dd }d |i} t| Sd}dt|}|dd }d |i} t| S) Nrrrrrrr rWrrirrrrrrrrr)rHrIrGrrormrr0) r<rrrrrrrirKryr=r=r> today_lists$   rc Csddlm}m}m}m}tjd}tj j ||j d |d d}|}i}|rAdt|}|dd } d | i}t|Sd}dt|}|dd } d | i}t|S) Nrrrrrrr rWrrir) r<rrrrrrriryrKr=r=r> month_lists"$   rc Csddlm}m}m}m}tjd}tj j ||j d |d d}tjd}tj j ||j d |d d}|} i} |dur`d}d t|} | d d } | |d } t| Sd t|} | d d } d | i} t| S)Nrrrrrrrrr rWr)yxrir) r<rrrrrrrrriryrKr=r=r> sales_lists($$   rc Csddlm}m}m}m}tjj|jd |d d}i}|dur>d}|dd}d t |}d |d d i}t |S|dd}d t |}d |d d i}t |S Nrrrrrdr rirWrr) r<rrrrrry commissionrir=r=r>rs"    rc Csddlm}ddlm}m}m}m}tjj tj |dd|j d |d d}i}|durGd}d t|}d |d d i}t|Sd t|}d |d d i}t|S) Nrrrrrrrrr rrWr)rrrrrrrr)rHrIrrGrrormrr0) r<rrrrrrryrir=r=r> last_dayss 4  rc Csddlm}m}m}m}tjj|jd |d d}|dur@d}|dd}||}d t |}d |d d i} t | S|dd}||}d t |}d |d d i} t | Srr) r<rrrrrrprofitriryr=r=r>rs "    rc Cr ) NrrrTzhttp://127.0.0.1:8000/RadacctrUrVrWr rhrjr r=r=r> json_list   rc Cr ) NrrrTz&http://127.0.0.1:8000/Radacct_Hotspot/rUrVrWr rhrjr r=r=r>hotspot_activerrc Cr ) NrrrTz(http://127.0.0.1:8000/BillingHistory_AllrUrVrWr rhrjr r=r=r> billing_list"rrcCrn)Nzonline_users.htmlrrr=r=r> online_users3rprcCs|jdkr7|jd}tjj|dtjj|dtjj|d|r3t |tj d|dt dSt dt |dS) Nr{rGrrwz has deleted successfully!rxerror delete.html)rr{r(rHrIdeleter.rrrrr rr r<rr=r=r>r5s   rcCsT|jdkr!|jd}tjj|d|rt|tjdt dSt dt |dS)Nr{rG)rLzPackage deleted successfully!plansrr) rr{r"rHrIrrrrr rr rr=r=r>delete_packageCs   rcCrn)Nz billing.htmlrrr=r=r>billing_historyOrprcCs<ddl}ddlm}tjjdd|dd}t|dS)NrrT)rrrr) rrrr%rHrIrror )r<rrrr=r=r>active_recordsRs  rc Cr ) NrrrTz"http://127.0.0.1:8000/InvoiceItem/rUrVrWr rhrjr r=r=r>rQWr rQcCrn)Nzpage-invoice.htmlrrr=r=r>invoicejrprcCsL|jdkr!|jd}|jd}|jd}|jd}|jd}|jd}|jd}|jd }d } d } |d krLtj} d } tj| d } | | } | d} |dkrftj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |dkrtj} d} tj| d} | | } | d} |d kr9tj} d!} tj| d} | | } | d} |d"krTtj} d#} tj| d} | | } | d} |d$krotj} d%} tj| d} | | } | d} |d&krtj} d'} tj| d} | | } | d} |d(krtj} d)} tj| d} | | } | d} |d*krtj} d+} tj| d} | | } | d} |d,krtj} d-} tj| d} | | } | d} |d.krtj} d/} tj| d} | | } | d} |d0krtj} d1} tj| d} | | } | d} |d2kr,tj} d3} tj| d} | | } | d} |d4krGtj} d5} tj| d} | | } | d} |d6krbtj} d7} tj| d} | | } | d} |d8kr}tj} d9} tj| d} | | } | d} |d:krtj} d;} tj| d} | | } | d} |d:krtj} d<} tj| d} | | } | d} |d=krtj} d>} tj| d} | | } | d} |d?krtj} d@} tj| d} | | } | d} |dAkrtj} dB} tj| d} | | } | d} |dCkrtj} dD} tj| d} | | } | d} |dEkr:tj} dF} tj| d} | | } | d} |dGkrUtj} d7} tj| d} | | } | d} |dHkrptj} dI} tj| d} | | } | d} |dJkrtj} dK} tj| d} | | } | d} |dLkrtj} dM} tj| d} | | } | d} |rtjj|dNj |dN| rtjj|dOdPj | dQ|rt jj|dNj ||dR|r|dSkrt jj|dTj |||||dUn$tj} tj| d} | | } | dV}t jj|dTj ||||||dW|rt |t jdX|dYtdZSt|d[S)\Nr{rLrrZcontactrqrrrrr[Now )secondsrZ Tommorrowrrrrrrrrrrrrrr r!r"r#r$r%r&r'r(r)r*r+r,r-r.r/r0r1r2r3r4r5r6r7r8r9r:r;r<r=r>r?r@rArBrCrDrErFrGrHrIrJrKrLrMrNrOrPrr)rrr)rrSelectr)rrrtrqrvr)rrrtrqrvrrwz has edited successfully!rxz update.html)rr{rrrrr.rHrIr6rr(rrrr r )r<rLrrrtrqrrrrrrr[r\r]r=r=r> update_pppoels                                                                                                                                             rcCrn)Nzwifi_online.htmlrrr=r=r> wifi_onlineYrprc Cs|jdkrA|jd}|jd}|jd}|jd}|jd}|jd}|jd}tj}t||j|j|||j|d t|d S) Nr{statustyperrrr taxamount) tax_amount invoice_idplan_idrtotal creationbyrr) rr{rrr rGrrr ) r<rrrrrrrr^r=r=r>create_invoice\s         ( r) itertoolsrZ reportlabio django.httprZreportlab.pdfgenrdjango.views.decorators.csrfrdjango.contribrrdjango.shortcutsr r rest_framework.responser Zrest_framework.permissionsr rkrZrest_framework.decoratorsrrrMrrrrrrrrrrrrZcustomer.modelsrr r!r"r#r$r%r&r'r(r)django.contrib.authr*r+r,django.contrib.auth.decoratorsr-rprn threadingmodelsr.asyncioaiohttposplatformurllib.requesturllibbase64rest_frameworkr/r0environr?rNrRrzr;rrrrrrrrrrrrrrrrrrrrrr r_rlrmroryrzrrrrrrrrrrrrrrrrrrrrQrrrrr=r=r=r>sL                                                   "                7 $   q = J             m