o '[Çd<ã@sÌddlTddlmZmZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZdd lmZdd lmZGd d „d eeƒZGd d„deeƒZGdd„deeƒZGdd„deeƒZdd„ZdS)é)Ú*)ÚredirectÚrender)ÚLoginRequiredMixin)ÚView)Úmessages)ÚQ)ÚDRIVE_IMAGE_PATH)Údatetime)Ú Paginator)Úget_company_datac@óeZdZdd„ZdS)Ú Userlocationc Csüg}|j dd¡}|j dd¡}|j dd¡}gd¢}|dkr6tj d¡ dd d d d d ddddd¡  |d¡ntj d¡ dd d d d d ddddd¡  d|›d¡}t|ƒ|vrY|}nd}t||ƒ} |j dd¡} |   | ¡} |t d| | t ƒ||dœ} t |d| ƒS)NÚ page_countrÚorder_byÚidÚ sort_orderÚasc©é éé2édiôÚuserÚuser__first_nameÚuser__last_nameÚuser__usernameÚuser__groups__nameÚstate_id__nameÚdistrict_id__nameÚsubdistrict_id__nameÚ city_id__nameÚ area_id__nameÚsubarea_id__namez-idú-rÚpageéz User Location)Úimagesr ÚtitleÚpage_objÚ paginatorÚ company_datarrz/menu/master/user_location/userlocationlist.html) ÚGETÚgetÚ UserLocationÚobjectsÚselect_relatedÚvaluesrÚintr Úget_pager r r) ÚselfÚrequestÚimg_listÚpagesrrÚ page_listr'Ú page_passedr*Ú page_numberr)Úcontext©r<ú//var/www/html/prime-uav/Admin/Location/views.pyr-s@ý  þ  þú   ø zUserlocation.getN©Ú__name__Ú __module__Ú __qualname__r-r<r<r<r=ró rc@óeZdZdd„Zdd„ZdS)ÚAddUserlocationcCsntjjdd dddd¡ d¡}tj ¡ dd¡ d¡}tj ¡ dd¡ d¡}|||dtƒd œ}t |d |ƒS) NF)Ú is_superuserÚ first_nameÚ last_namerÚ groups__nameÚnamezAdd User Location)ÚusersÚ countriesÚstatesr(r+ú/menu/master/user_location/adduser_location.html) ÚUserr/Úfilterr1rÚ CountryMasterÚallÚ StateMasterr r)r4r5rJrKrLr;r<r<r=r-9s  zAddUserlocation.getc Cs>|jdkr›|j d¡}tjj|d}|j d¡}tjj|d}|j d¡}|r/tjj|d}nd}|j d¡}|rAtjj|d} nd} |j d¡} | rStjj| d} nd} |j d ¡} | ret jj| d} nd} |j d ¡}|rwt jj|d}nd}|d kr“|d kr“t jj |d ||| | | |d t dƒSt |d¡dSt dƒS)NÚPOSTÚusername©ÚpkÚ user_state©rÚ user_districtÚuser_subdistrictÚ user_cityÚ user_areaÚ user_subareaÚr&©rÚ country_idÚstate_idÚ district_idÚsubdistrict_idÚcity_idÚarea_idÚ subarea_idÚ userlocationúSome field is emptyrM)ÚmethodrSr-rNr/rRÚDistrictMasterÚSubDistrictMasterÚ CityMasterÚ AreaMasterÚ SubAreaMasterr.ÚcreaterrÚerror)r4r5rÚuser_idraÚstaterbÚdistrictrcÚ subdistrictrdÚcityreÚarearfÚsubarear<r<r=ÚpostGs<        zAddUserlocation.postN©r?r@rAr-rxr<r<r<r=rD8s rDc@rC)ÚUpdateUserlocationc Csi}tjj|d dddddddd d ¡ }|d d|d<|d d|d<|d d|d<|d d|d<|d d|d<|d d|d<|d d |d <tj ¡ d d ddd¡ d ¡}tjjdd dd¡ d¡}tt jj|d dd dd¡ƒ}|d ddkr—tt jj|d dd dd¡ d¡ƒ}nd}|d ddkr¶tt jj|d dd dd¡ d¡ƒ} nd} |d ddkrÓt jj|d dd dd¡ d¡} nd} |d ddkrðt jj|d dd dd¡ d¡} nd} ||||| | | |dttƒdœ } t|d| ƒS)NrXrrrarbrcrdrerfrrrFrGrTrHr&)r`rI©rar^©rb)rc©rd©rezEdit User Location) rJrLÚ districtsÚ subdistrictsÚcitiesÚareasÚsubareasÚ user_locationr(rr+rM)r.r/rOr1rNrQrrRÚlistrjrkrlrmrnrr r) r4r5ÚuseridÚlocationr„rJrLrr€rr‚Úsubaresr;r<r<r=r-{s4$"**&& zUpdateUserlocation.getc Csü|jdkrz|j d¡}tjj|d}|j d¡}|j d¡}|dkr$d}|j d¡}|dkr0d}|j d¡}|dkrr<r<r<r=rŠÐrBrŠc*Csptjj|jjd}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jd dd ¡ƒ}tj  ¡  d d ¡  d ¡}t j  ¡  d d ¡  d ¡} t j  ¡  d d ¡  d ¡} g} d } d} |j dd¡}|j dd¡}|j dd¡}|j dd¡}|j dd¡}|j dd¡}|j dd¡}|j dd¡}g}g}g}g}g}g}tƒ}tƒ}tƒ}tƒ}tƒ}tƒ}g}|rÖ|t|dM}|rß|t|dM}|rè|t|dM}|rñ|t|dM}|rú|t|dM}|r|t|dM}|r|t|dM}|r|t|dM}|jjs#tjj|jjd}| ¡dur"t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jddd ¡ƒ}t|jd dd ¡ƒ}|gkr‚|dgkr‚|t|dM}n ||vrŽ|t|dM}|gkr¡|dgkr¡|t|d M}n ||vr­|t|dM}|gkrÀ|dgkrÀ|t|d!M}n ||vrÌ|t|dM}|gkrß|dgkrß|t|d"M}n ||vrë|t|dM}|gkrþ|dgkrþ|t|d#M}n ||vr |t|dM}tj |¡  d ddddd dd$d%d&dd'd(¡   d ¡}ntj |¡  d ddddd dd$d%d&dd'd(¡   d ¡}|D]´}i}|d |d <t jj|dd)  d ¡}|d d |d*<tjj|dd)  d ¡} | d d |d+<tjj|dd)  d ¡}!|!d d |d,<tjj|dd)  d ¡}"|"d d |d-<tjj|d d)  d ¡}|d d |d<t jj|d'd)  d ¡}|d d |d<|d$|d$<|d%|d%<|d&|d&<|d|d<t t|dƒd.¡ ¡|d<|d(|d/<|  |¡q=t|ƒ} |j d0d ¡}#gd1¢}$t|#ƒ|$vr |#}%nd2}%t|ƒ} t| |%ƒ}&|j d3d4¡}'|&  |'¡}(|| | | t!d5|(|&| | |t"ƒd6œ })t#|d7|)ƒS)8N)rr`T)ÚflatrarbrdrerfrIrrrrWrYr[r\rwÚroundÚ image_dateÚstatusr{r|r}r~)rf)r)Ú status_id)rŽr^)Ú state_id__in)Údistrict_id__in)Ú city_id__in)Ú area_id__in)Úsubarea_id__inÚlatitudeÚ longitudeÚaltituderÚdrive_image_idrXrrrsrurvz%Y-%m-%dÚimage_idrrrr%r&zLocation Listing) rKrLÚstatusesr6r r(r)r*ÚcountÚ search_forrWr+z!menu/master/images/imagelist.html)$r.r/rOrrr…Ú values_listÚdistinctrPrQr1rrRÚ StatusMasterr,r-rrEÚfirstÚ ImageMasterrjrlrmrnr ÚstrptimeÚstrÚdateÚappendÚlenr2r r3r r r)*r5Úuser_locationsÚ country_listÚ state_listÚ district_listÚ city_listÚ area_listÚ subarea_listrKrLr›r6rœrrWrYr[r\rwrrŽrÚqueryÚ state_queryÚdistrict_queryÚ city_queryÚ area_queryÚ subarea_queryr'ÚimgÚ image_datarrrsrurvr7r8r9r*r:r)r;r<r<r=Ú viewimagelistÖsè      0€0          r·N)Údashboard.modelsÚdjango.shortcutsrrÚdjango.contrib.auth.mixinsrÚ django.viewsrÚdjango.contribrÚdjango.db.modelsrÚnazox.settingsr r Údjango.core.paginatorr Úsettings.viewsr rrDrzrŠr·r<r<r<r=Ús        *BV