o 'hP@sddlmZmZmZddlmZddlmZmZddl m Z m Z ddl m Z mZddlmZddlmZddlmZdd lmZdd lmZdd lZdd lZdd lmZdd lmZddlm Z ddl!m"Z"ddl#m$Z$m%Z%ddl&m'Z'm(Z(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/m0Z0m1Z1m2Z2m3Z3e4e5Z6ddZ7Gddde Z/eee7ddZ8eee7ddZ9eee7ddZ:eed geee7d!d"Z;Gd#d$d$e e e Zeee7d*d+Z?eee7d,d-Z@eee7d.d/ZAGd0d1d1e/e eZBeee7d2d3ZCeee7d4d5ZDeee7d6d7ZEeee7d8d9ZFeee7d:d;ZGeee7dd?ZIeee7d@dAZJd S)B)renderredirectget_object_or_404)messages)login_requireduser_passes_test)LoginRequiredMixinUserPassesTestMixin)ListView UpdateView) reverse_lazy) send_mail)settings) JsonResponse)QN) csrf_exempt)require_http_methods) Paginator)timezone)SystemSettingsCompanyProfile)CompanyProfileForm TestEmailFormSystemSettingsFormEmailLog) email_service)AdminRequiredMixinhas_admin_accesspermission_requiredhas_permissionget_user_permissionscCst|S)zCheck if user has admin access)r)userr$./var/www/html/optinet_system/settings/views.pyis_admin sr&c@seZdZddZdS)rcCs |jjjSN)requestr# is_superuserselfr$r$r% test_func%s zAdminRequiredMixin.test_funcN)__name__ __module__ __qualname__r,r$r$r$r%r$s rc Cs|jdkrW|jd}|dkrDgd}|D]#}|j|d}|r9|dkr+|dks9tjjd|||d vd d qt|d td)S|d kr|gd}|D]#}|j|d}|rq|dvrc|dksqtjjd|||dvd d qNt|dtd)S|dkrgd}|D]#}|j|d}|r|dkr|dkstjjd|||dvd d qt|dtd)S|dkr|jdd}|r|dkrtjjdd|dd d t|dtd)S|dkrSt jj dd\}}|jd d|_ |jdd|_ |jd!d|_ |jd"d|_|jd#d|_|jd$d|_|jd%d|_d&|jvr=|jd&|_d'|jvrI|jd'|_|t|d(td)Sd*d+} | d} | d} | d} | d,} | d}| d-}zt j}|st jjd.d/}Wnty}z t jjd.d/}WYd0}~nd0}~wwz0d1d2lm}|jjd3d4|jjd5d4|jjd6d4|jjd3t d7d8}Wnd0}Y| | | | ||||d9}t!|d:|S);zAMain settings dashboard with all configurations and POST handlingPOSTactionsave_email_settings)HOSTPORT HOST_USER HOST_PASSWORDUSE_TLSUSE_SSLDEFAULT_FROM_EMAILTIMEOUTr6••••••••email)r6)value is_sensitivecategorykeydefaultsu&✅ Email settings saved successfully!save_mpesa_settings) CONSUMER_KEYCONSUMER_SECRETBUSINESS_SHORT_CODE ENVIRONMENTPASSKEYCALLBACK_BASE_URL)rFrImpesau'✅ M-Pesa settings saved successfully!save_sms_settings)API_KEY API_SECRET SENDER_IDAPI_URLrNsms)rNu$✅ SMS settings saved successfully!save_maps_settingsrMmapsTu,✅ Google Maps settings saved successfully!save_company_settingsrid company_namephoneaddresswebsitetax_idbusiness_registration company_logofavicon)✅ Company profile updated successfully!settings:dashboardcSs,i}tjj|d}|D]}|j||j<q |S)z;Helper function to get settings for a specific API category)rA)robjectsfilterr>rB)rArcategory_settingssettingr$r$r%get_api_settings{s z,settings_dashboard..get_api_settingsmikrotikgeneralOptiNet Solutions)rWNrrsentstatusfailedpending)rk sent_at__date) total_sent total_failed total_pending today_sent)mpesa_settingsemail_settings sms_settingsmikrotik_settings maps_settingsgeneral_settingscompany_profile email_statszsettings/dashboard.html)"methodr0getstriprraupdate_or_creatersuccessr get_or_createrWr=rXrYrZr[r\FILESr]r^saverfirstcreate Exceptionnotifications.modelsrrbcountrnowdater)r(r1 email_fieldsfieldr> mpesa_fields sms_fieldsprofilecreatedrersrtrurvrwrxryerrzcontextr$r$r%settings_dashboard(s    >  1  $               rc Cs~|jdkr;|jd}|st|dtdSddddddd d dd ddd d dd dddd ddd ddd ddd dd dd ddd ddd dddddd ddddddd ddd ddd ddd ddd ddd dd d!d dd"d dd#d dd$ddd%d&d'ddid(d dd)d dd*d+}||vrt|d,|tdSd-}i}|d.krd/d0d1d2d3d4d5d6d7d8d9 }||D]a\}}|}|d.kr|D] \}} | |kr|}nq|j|d:} | sq| d;krqtj j ||| |d<|d=|d>kr|d?vnd d@dA\} } | s$| | _ |d<| _ |d=| _ | |dB7}qt||dC|dDtdStdS)Ez#Update API settings via modal formsr0api_typezInvalid API type specified.r`zM-Pesa Consumer KeyT) descriptionr?zM-Pesa Consumer SecretzM-Pesa Business Short CodeFzM-Pesa PasskeyzM-Pesa Initiator Namez%M-Pesa Initiator Password (encrypted)z'M-Pesa Environment (sandbox/production)zSTK Push Callback URLzC2B Validation URLzC2B Confirmation URL) consumer_keyconsumer_secretbusiness_short_codepasskeyinitiator_nameinitiator_password environmentstk_callback_urlc2b_validation_urlc2b_confirmation_urlz SMTP Hostz SMTP Portz SMTP Usernamez SMTP PasswordzUse TLS Encryption)r3r4r5r6r7z SMS API KeyzSMS Partner IDzSMS Short CodezSMS API Base URLzSMS API MethodzSMS Phone Parameter NamezSMS Message Parameter Name)rM PARTNER_ID SHORT_CODErPMETHODPHONE_PARAMETERMESSAGE_PARAMETERzMikroTik Router IPzMikroTik API PortzMikroTik UsernamezMikroTik Password)r3r4USERNAMEPASSWORDrMzGoogle Maps API KeyzSystem TimezonezDefault Currency)TIMEZONECURRENCY)rKr=rQrfrSrgzUnknown API type: rrKrrrrrrrrrr) rErFBUSINESS_SHORTCODErIINITIATOR_NAMEINITIATOR_PASSWORDrHSTK_CALLBACK_URLC2B_VALIDATION_URLC2B_CONFIRMATION_URLr;r<rr?rg)rEr3rM)r>rr? is_requiredr@rz% API settings updated successfully! (z settings saved))r{r0r|rerrorritemsr}rrarr>rr?rrupper) r(rapi_settings_mapsettings_updated field_mappingrBconfig form_fieldform_keydb_keyr>rdrr$r$r%update_api_settingss      ,      rcCsntjjdd\}}|jdkr*t|j|j|d}|r)|t |dt dSnt|d}t |dd|iS) zManage company profilerrUr0)instancer_r`settings/company_profile.htmlform) rrarr{rr0ris_validrrrrr)r(rrrr$r$r%ry0s   ryr0c Cs@zddl}||j}|d}tj}|stdddWS|dkrL|jrL|jj r=ddl }|j |jj r=| |jj d|_| tdd d WS|d kry|jry|jj rjddl }|j |jj rj| |jj d|_| tdd d WStdd |ddWSty}ztdt|dWYd}~Sd}~ww)zDelete company profile imagesrN image_typeFzCompany profile not foundrrlogoTzLogo deleted successfullyrmessager^zFavicon deleted successfullyzNo z to delete)jsonloadsbodyr|rrarrr]pathosexistsremoverr^rstr)r(rdatarrrrr$r$r% delete_imageAs8   rcs<eZdZeZdZdZdZddZddZ fdd Z Z S) EmailLogListViewsettings/email_logs.html email_logscCs t|jjSr')rr(r#r*r$r$r%r,os zEmailLogListView.test_funccCstjd}|jjd}|r|j|d}|jjd}|r&|j|d}|jjd}|rA|t|dt|dBt|d B}|S) N-sent_attype email_typerkrjsearchrecipient_email__icontainssubject__icontainsrecipient_name__icontains) rraallorder_byr(GETr|rbr)r+querysetrrkrr$r$r% get_querysetrs"  zEmailLogListView.get_querysetc srtjd i|}tj|d<tj|d<|jjdd|d<|jjdd|d<|jjdd|d <t |d <|S) N email_typesstatus_choicesrr; selected_typerkselected_statusr search_queryrzr$) superget_context_datarEMAIL_TYPE_CHOICESSTATUS_CHOICESr(rr|rget_email_statsr+kwargsr __class__r$r%rs   z!EmailLogListView.get_context_data) r-r.r/rmodel template_namecontext_object_name paginate_byr,rr __classcell__r$r$rr%risrcCstt|d}t|dd|iS)zView detailed email logrUzsettings/email_log_detail.html email_log)rrr)r(log_idrr$r$r%email_log_details rrc Cs|jjr t|jstdddSz|jjpd}tj||jd\}}t||r'|nd|dWStyU}zt d|tdd t |dWYd }~Sd }~ww) z0Simple test email endpoint for the navbar buttonFz Access deniedrzadmin@optinet.co.kerecipient_emailsent_byzError: rzError in test email endpoint: zUnexpected error: N) r#is_authenticatedrrr=rsend_test_emailrloggerrr)r(rrrrr$r$r%test_email_endpoints(    rc CsT|jdkrVt|j}|rU|jd}z$t}|j||jd\}}|r-t |d|dn t |d|Wn!t yT}zt |dt |WYd}~n d}~wwnt}i}zt jjd d d }|j|d <Wnt jy|ttd d|d <Ynwzt jjd dd } | j|d<Wnt jyttdd|d<Ynw||d} t|d| S)zLTest email configuration by sending a test email using the new email servicer0 test_emailru$✅ Test email sent successfully to z2! Please check your inbox (including spam folder).u❌ u'❌ Error testing email configuration: Nr=r3)rArBhost EMAIL_HOSTzNot configuredr5r#EMAIL_HOST_USER)rrtzsettings/test_email.html)r{rr0r cleaned_datarrr#rrrrrrrar|r> DoesNotExistgetattrrr) r(rremail_service_instancer error_msgremail_settings_display host_setting user_settingrr$r$r%test_email_settingssP     " r c Cs|jdkr|jdd}|jdd}|r|s%t|dtdSzddlm}|}|d r9|d sDt|d tdWSdd l m }|}| d r[d|dd}n| drg|dd}n| dro|}nd| d}|j |||jdd}|rt|d|dn3ddlm} | jj||jdd} d} | r| jrd| j} t|d|d| dWtdSWtdSty} zt|dt| WYd} ~ tdSd} ~ wwtdS)z,Test SMS configuration by sending a test SMSr0 test_phoner; test_messageu1❌ Please provide both phone number and message.r`r)get_sms_settingsapi_keyapi_urluG❌ SMS API is not properly configured. Please check your SMS settings.)NotificationService0254rNz+254+z Test User) phone_numberrrrecipient_nameu"✅ Test SMS sent successfully to !)SMSLog)recipient_phonerrz Error: u❌ Failed to send test SMS to .z% Please check your SMS configuration.u%❌ Error testing SMS configuration: )r{r0r|r}rrrsettings.utilsr notifications.servicesr startswithlstripsend_smsr#rrrrarbrr error_messagerr) r(r r r rurnotification_serviceformatted_phonerr last_sms_log error_detailrr$r$r%test_smssn               r$c Cs||jdkrztjjddid\}}|jdd|_|jdd|_|jdd|_ |jdd|_ |jd d|_ |jd d|_ |jd d|_ |jd d |_|jdd|_d|jvrr|jd|_d|jvr}|jd|_|jst|dtdWS|t|dWtdSty}zt|dt|WYd}~tdSd}~wwtdS)z,Update organization/company profile settingsr0rWrhrCr;r\r[rXr=rZrYdefault_currencyKESrzAfrica/Nairobir]r^zCompany name is required.r`z+Organization settings updated successfully!z&Error updating organization settings: N)r{rrarr0r|r}rWr\r[rXr=rZrYr&rrr]r^rrrrrrr)r(ryrrr$r$r%update_organization8s<         r(csFeZdZeZeZdZedZ d ddZ fddZ fdd Z Z S) CompanyProfileViewrr`NcCstjjddid\}}|S)NrWrhr%)rrar)r+rrrr$r$r% get_objectjs zCompanyProfileView.get_objectc s"tjdi|}||d<|S)Nrr$)rrr*rrr$r%rqs z#CompanyProfileView.get_context_datacst|jdt|S)Nz%Company profile updated successfully!)rrr(r form_valid)r+rrr$r%r+vs zCompanyProfileView.form_validr')r-r.r/rrr form_classrr success_urlr*rr+rr$r$rr%r)ds  r)c Cs|jdkrzddl}||j}|dd}|dd}|dd}|s2tdd d WS|s9|d }|s@|d }td |d|t }|drX|ds`tddd WSddl m }|}| ||} | ddkrt |d|ddtdd|d|d||dWS| d| dd} d| vrd} n| } t |d| tdd | d WSty} ztd!t| tdd"t| d WYd} ~ Sd} ~ wwdS)#zRegister M-Pesa paybill URLsr0rNbase_urlr;validation_urlconfirmation_urlFzPlease provide a base URL.rz/payments/paybill-validation/z/payments/paybill-confirmation/z&Registering M-Pesa URLs - Validation: z, Confirmation: rrIM-Pesa API is not properly configured. Please check your M-Pesa settings. MpesaService ResponseCoderuU✅ Paybill URLs registered successfully. Customers can now pay using paybill number z* with their customer ID as account number.Tz6Paybill URLs registered successfully. Paybill Number: )rrpaybill_numberr/r0 errorMessageResponseDescription Unknown errorzInvalid Access TokenaInvalid Access Token. This usually means: 1. Your M-Pesa app is not approved for production (if using production environment) 2. Your Consumer Key/Secret are incorrect 3. Your app credentials don't match the selected environment Please verify your credentials and environment settings.u%❌ Failed to register paybill URLs: z!Failed to register paybill URLs: z Error registering paybill URLs: zError registering URLs: )r{rrrr|r}rprintrget_mpesa_settingspayments.servicesr3register_c2b_urlsrrrrr) r(rrr.r/r0rsr3 mpesa_serviceresponserdetailed_messagerr$r$r%register_paybill_urlszsv          r@c Cszzddlm}WntytdddYWSw|jddd}g}|D]u}zT||jt |d d |j r@|j d nd |j rJ|j d ndt |d dt |d d|j r_d|j dnd|jrjd|jdnd|jrud|jdnd|j r{dndd Wq+ty}ztd|jdt|WYd}~q+d}~wwtd|t|dWSty}z,ddl}|}tdt|td|tddt|dddWYd}~Sd}~ww)z"Get M-Pesa balance inquiry historyrMpesaBalanceInquiryFzWMpesaBalanceInquiry model not found. Please ensure payments app is properly configured.rz -created_atN conversation_idzN/Az%Y-%m-%d %H:%M:%S result_code result_desczKSh z,.2f completedrm) rVrD created_at completed_atrErFworking_account_fundsutility_account_fundscharges_paid_fundsrkz!Error processing balance inquiry z: T)rbalance_historyrzError getting balance history: zFull traceback: irj)payments.modelsrB ImportErrorrrarrappendrVrrHstrftimerIrJrKrLrr9rlen traceback format_exc) r(rBbalance_inquiries balance_datainquiry item_errorrrS error_detailsr$r$r%mpesa_balance_historys`          rZc CsF|jdkrzoddlm}|}|dr|ds"tdddWS|dd }|dd }t|d ks>t|d krFtdd dWSdd lm }|}t d |dd| }|rmtdd|dddWStdddWSt y}zt dt |tddt |dWYd}~Sd}~wwtdddS)z9Test M-Pesa credentials by attempting to get access tokenr0rrrrFzIM-Pesa Consumer Key and Secret are required. Please configure them first.rr;rCzNConsumer Key and Secret appear to be too short. Please check your credentials.r2z,Testing M-Pesa credentials for environment: rsandboxTz4M-Pesa credentials are valid! Connection successful.)rrrzPFailed to authenticate with M-Pesa. Please check your credentials and try again.z"Error testing M-Pesa credentials: zError testing credentials: NInvalid request method)r{settings.modelsrr:r|rr}rRr;r3r9get_access_tokenrr) r(rrsrrr3r= access_tokenrr$r$r%test_mpesa_credentialssT        rac Cs(|jdkr zddl}||j}|dd}|dd}|r%|s-tddd WSzt|}|d ks:|d krCtdd d WWSWntyUtdd d YWSwddl m }| }|drj|dsrtddd WSd}|j j dd|dddddlm} | } | j|tt|dtddd} | ddkrt|d|d |d!td"d#|d$| d%d&WS| d'| d(d)} t|d*|d+| tdd,| d WSty } zt|d-t| tdd.t| d WYd} ~ Sd} ~ wwtdd/d S)0z"Test M-Pesa STK push functionalityr0rNrr;amountFz,Please provide both phone number and amount.rripz,Amount must be between KES 1 and KES 70,000.zInvalid amount format.r[rrr1z3https://system.optinet.co.ke/payments/stk-callback/rK callback_urlzSTK Push callback URL)r>rr@r2zTEST-z %Y%m%d%H%M%Sz'Test STK Push from Optinet Global Links)rrbaccount_referencetransaction_descr4ru'✅ Test STK Push sent successfully to z for KES z(. Customer should receive M-Pesa prompt.Tz#Test STK Push sent successfully to z). Check your phone for the M-Pesa prompt.CheckoutRequestID)rrcheckout_request_idr6r7r8u$❌ Failed to send test STK Push to z . Error: z Failed to send STK Push. Error: u❌ Error testing STK Push: zError testing STK Push: r])r{rrrr|r}rfloat ValueErrorr^rr:rar~r;r3stk_pushintrrrQrrrrr)r(rrrrb amount_floatrrsrcr3r=r>rrr$r$r% test_stk_push<s             rmc Csddlm}|}|}|}dD]}||r%dt||||<qt|||dd|dd|d d|d dd d S) z.Health check endpoint for M-Pesa configurationr)MpesaHealthCheck)rr*rr\rr;rr) stk_callbackc2b_validationc2b_confirmation) health_checkeffective_configr callback_urls)settings.health_checksrncheck_mpesa_settingsget_effective_mpesa_configcopyr|rRr)r(rnrsr safe_configrBr$r$r%mpesa_health_checks"      r{c Cs`|jdkrz|ddlm}|}|dr|ds"tdddWS|d s/tdd dWSdd lm}|}|}t d ||d dkrl|d}|d}ddl m }|j j ||d} tdd|ddWS|d|dd} tdd| |dWSty} zt dt| tddt| dWYd} ~ Sd} ~ wwtdddS) zCheck M-Pesa account balancer0rr[rrFzFM-Pesa is not configured. Please configure your M-Pesa settings first.rrz5Business Short Code is required for balance checking.r2zM-Pesa Balance Response: r4rConversationIDOriginatorConversationIDrA)rDoriginator_conversation_idTzRBalance inquiry initiated successfully. You will receive the results via callback.rm)rrrDrkr6r7r8zBalance inquiry failed: )rrr>zError checking M-Pesa balance: zError checking balance: Nr])r{r^rr:r|rr;r3check_account_balancer9rNrBrarrr) r(rrsr3r=r>rDr~rBbalance_inquiryrrr$r$r%check_mpesa_balancesd          rc Cstjd}|jd}|r|j|d}|jd}|r$|j|d}|jd}|r>|t|dt|dBt|d B}|tjtj |jdd |jdd |jdd d }t |d |S) zView email logsrrrrkrjrrrrr;)rrrrrrr) rrarrrr|rbrrrr)r(rrrkrrr$r$r%rs0         rcCstjjddd}|jd}|r|j|d}|jd}|r-|t|dt|dB}|tj|jdd |jdd d }t|d |S) zView password reset email logspassword_resetrrrkrjrrrr;)password_reset_logsrrrz!settings/password_reset_logs.html) rrarbrrr|rrr)r(rrkrrr$r$r%rs"      r)Kdjango.shortcutsrrrdjango.contribrdjango.contrib.auth.decoratorsrrdjango.contrib.auth.mixinsrr django.views.genericr r django.urlsr django.core.mailr django.confr django.httprdjango.db.modelsrrloggingdjango.views.decorators.csrfrdjango.views.decorators.httprdjango.core.paginatorr django.utilsrmodelsrrformsrrrrrnotifications.email_serviceraccounts.permissionsrrr r!r" getLoggerr-rr&rrryrrrrr r$r(r)r@rZrarmr{rrrr$r$r$r%s                z $+    1 H * R 3 7 \  @ !