Gecko [ myeducation.co.th ]

Name	Size	Permission
Booking.cpython-38.pyc	6.15 KB	-rwxr-xr-x
Booking.cpython-39.pyc	6.13 KB	-rw-r--r--
Booking_env_3.cpython-38.pyc	7.47 KB	-rwxr-xr-x
Booking_env_3.cpython-39.pyc	7.45 KB	-rw-r--r--
api_env_2_routes.cpython-38.py...	3.48 KB	-rwxr-xr-x
api_env_2_routes.cpython-39.py...	3.47 KB	-rw-r--r--
api_env_3_routes.cpython-38.py...	10.66 KB	-rwxr-xr-x
api_env_3_routes.cpython-39.py...	11.7 KB	-rw-r--r--
booking_delete.cpython-38.pyc	2.32 KB	-rwxr-xr-x
booking_delete.cpython-39.pyc	2.32 KB	-rw-r--r--
booking_delete_env_3.cpython-3...	2.33 KB	-rwxr-xr-x
booking_delete_env_3.cpython-3...	2.33 KB	-rw-r--r--
bookingdetail.cpython-38.pyc	10.67 KB	-rwxr-xr-x
bookingdetail.cpython-39.pyc	10.64 KB	-rw-r--r--
bookingdetail_env_3.cpython-38...	16.17 KB	-rwxr-xr-x
bookingdetail_env_3.cpython-39...	16.13 KB	-rw-r--r--
branch_env_3.cpython-38.pyc	4.72 KB	-rwxr-xr-x
branch_env_3.cpython-39.pyc	4.7 KB	-rw-r--r--
change_password.cpython-38.pyc	1.93 KB	-rwxr-xr-x
change_password.cpython-39.pyc	2 KB	-rw-r--r--
check.cpython-38.pyc	3.43 KB	-rwxr-xr-x
check.cpython-39.pyc	3.52 KB	-rw-r--r--
check_env_2.cpython-38.pyc	3.2 KB	-rwxr-xr-x
check_env_2.cpython-39.pyc	3.3 KB	-rw-r--r--
check_env_3.cpython-38.pyc	3.2 KB	-rwxr-xr-x
check_env_3.cpython-39.pyc	3.3 KB	-rw-r--r--
check_tel.cpython-38.pyc	3.41 KB	-rwxr-xr-x
check_tel.cpython-39.pyc	3.5 KB	-rw-r--r--
checkout.cpython-38.pyc	1.92 KB	-rwxr-xr-x
checkout.cpython-39.pyc	1.95 KB	-rw-r--r--
config.cpython-38.pyc	439 B	-rwxr-xr-x
config.cpython-39.pyc	430 B	-rw-r--r--
createkeysecret.cpython-38.pyc	485 B	-rwxr-xr-x
createkeysecret.cpython-39.pyc	478 B	-rw-r--r--
database.cpython-38.pyc	1.59 KB	-rwxr-xr-x
database.cpython-39.pyc	1.65 KB	-rw-r--r--
decorator.cpython-38.pyc	2.4 KB	-rwxr-xr-x
decorator.cpython-39.pyc	2.38 KB	-rw-r--r--
forgot.cpython-38.pyc	2.05 KB	-rwxr-xr-x
forgot.cpython-39.pyc	2.12 KB	-rw-r--r--
gen_uuid.cpython-38.pyc	2.98 KB	-rwxr-xr-x
gen_uuid.cpython-39.pyc	2.97 KB	-rw-r--r--
image_conn_data.cpython-38.pyc	1.65 KB	-rwxr-xr-x
image_conn_data.cpython-39.pyc	1.63 KB	-rw-r--r--
image_conn_data3.cpython-38.py...	1.84 KB	-rwxr-xr-x
image_conn_data3.cpython-39.py...	1.81 KB	-rw-r--r--
image_urls.cpython-38.pyc	5.24 KB	-rwxr-xr-x
image_urls.cpython-39.pyc	5.23 KB	-rw-r--r--
image_urls_env_3.cpython-38.py...	5.66 KB	-rwxr-xr-x
image_urls_env_3.cpython-39.py...	5.64 KB	-rw-r--r--
jangwat_thai.cpython-38.pyc	3.37 KB	-rwxr-xr-x
jangwat_thai.cpython-39.pyc	4.37 KB	-rw-r--r--
maracar.cpython-38.pyc	17.22 KB	-rwxr-xr-x
maracar.cpython-39.pyc	17.39 KB	-rw-r--r--
matching_user_env_2.cpython-38...	9.11 KB	-rwxr-xr-x
matching_user_env_2.cpython-39...	9.18 KB	-rw-r--r--
order_send_email_env_3.cpython...	5.63 KB	-rwxr-xr-x
order_send_email_env_3.cpython...	5.61 KB	-rw-r--r--
order_send_email_smtpgo.cpytho...	6.13 KB	-rw-r--r--
payments.cpython-38.pyc	5.77 KB	-rwxr-xr-x
payments.cpython-39.pyc	5.73 KB	-rw-r--r--
payments_env_3.cpython-38.pyc	8.2 KB	-rwxr-xr-x
payments_env_3.cpython-39.pyc	8.16 KB	-rw-r--r--
payments_payzen.cpython-38.pyc	11.12 KB	-rwxr-xr-x
payments_payzen.cpython-39.pyc	11.11 KB	-rw-r--r--
payments_test_env_3.cpython-38...	3.87 KB	-rwxr-xr-x
payments_test_env_3.cpython-39...	3.87 KB	-rw-r--r--
position_set.cpython-38.pyc	1.58 KB	-rwxr-xr-x
position_set.cpython-39.pyc	1.63 KB	-rw-r--r--
positions_list.cpython-38.pyc	1.02 KB	-rwxr-xr-x
positions_list.cpython-39.pyc	1.04 KB	-rw-r--r--
price_create.cpython-38.pyc	8.83 KB	-rwxr-xr-x
price_create.cpython-39.pyc	8.81 KB	-rw-r--r--
price_create3.cpython-38.pyc	12.77 KB	-rwxr-xr-x
price_create3.cpython-39.pyc	12.68 KB	-rw-r--r--
promotion_items.cpython-38.pyc	3.12 KB	-rwxr-xr-x
promotion_items.cpython-39.pyc	3.1 KB	-rw-r--r--
promotions.cpython-38.pyc	5.23 KB	-rwxr-xr-x
promotions.cpython-39.pyc	5.2 KB	-rw-r--r--
queues.cpython-38.pyc	5.85 KB	-rwxr-xr-x
queues.cpython-39.pyc	5.83 KB	-rw-r--r--
queues_env_3.cpython-38.pyc	8.45 KB	-rwxr-xr-x
queues_env_3.cpython-39.pyc	8.44 KB	-rw-r--r--
register.cpython-38.pyc	3.11 KB	-rwxr-xr-x
register.cpython-39.pyc	3.16 KB	-rw-r--r--
register_edit.cpython-38.pyc	2.5 KB	-rwxr-xr-x
register_edit.cpython-39.pyc	2.57 KB	-rw-r--r--
register_edit_env_2.cpython-38...	2.82 KB	-rwxr-xr-x
register_edit_env_2.cpython-39...	2.89 KB	-rw-r--r--
register_edit_env_3.cpython-38...	2.85 KB	-rwxr-xr-x
register_edit_env_3.cpython-39...	2.94 KB	-rw-r--r--
register_env_2.cpython-38.pyc	3.13 KB	-rwxr-xr-x
register_env_2.cpython-39.pyc	3.18 KB	-rw-r--r--
register_env_3.cpython-38.pyc	3.12 KB	-rwxr-xr-x
register_env_3.cpython-39.pyc	3.1 KB	-rw-r--r--
report_bookingoverview.cpython...	6.85 KB	-rwxr-xr-x
report_bookingoverview.cpython...	6.85 KB	-rw-r--r--
report_bookingoverview_env_3.c...	9 KB	-rwxr-xr-x
report_bookingoverview_env_3.c...	9 KB	-rw-r--r--
reviews.cpython-38.pyc	6.28 KB	-rwxr-xr-x
reviews.cpython-39.pyc	6.26 KB	-rw-r--r--
reviews_env_3.cpython-38.pyc	8.46 KB	-rwxr-xr-x
reviews_env_3.cpython-39.pyc	8.45 KB	-rw-r--r--
service.cpython-38.pyc	4.54 KB	-rwxr-xr-x
service.cpython-39.pyc	4.54 KB	-rw-r--r--
service3.cpython-38.pyc	6.15 KB	-rwxr-xr-x
service3.cpython-39.pyc	6.14 KB	-rw-r--r--
sms_octopush.cpython-38.pyc	1.62 KB	-rwxr-xr-x
sms_octopush.cpython-39.pyc	1.61 KB	-rw-r--r--
sms_thsms3.cpython-38.pyc	1.76 KB	-rwxr-xr-x
sms_thsms3.cpython-39.pyc	1.75 KB	-rw-r--r--
specificinsert_env_2.cpython-3...	3.12 KB	-rwxr-xr-x
specificinsert_env_2.cpython-3...	3.23 KB	-rw-r--r--
status_list.cpython-38.pyc	1.01 KB	-rwxr-xr-x
status_list.cpython-39.pyc	1023 B	-rw-r--r--
types_create.cpython-38.pyc	4.25 KB	-rwxr-xr-x
types_create.cpython-39.pyc	4.25 KB	-rw-r--r--
types_create3.cpython-38.pyc	6.78 KB	-rwxr-xr-x
types_create3.cpython-39.pyc	6.77 KB	-rw-r--r--
update_status.cpython-38.pyc	1.94 KB	-rwxr-xr-x
update_status.cpython-39.pyc	1.99 KB	-rw-r--r--
user.cpython-38.pyc	3.08 KB	-rwxr-xr-x
user.cpython-39.pyc	3.08 KB	-rw-r--r--
user3.cpython-38.pyc	3.09 KB	-rwxr-xr-x
user3.cpython-39.pyc	3.24 KB	-rw-r--r--
user_all.cpython-38.pyc	3.45 KB	-rwxr-xr-x
user_all.cpython-39.pyc	3.43 KB	-rw-r--r--
user_all_env_2.cpython-38.pyc	4.75 KB	-rwxr-xr-x
user_all_env_2.cpython-39.pyc	4.7 KB	-rw-r--r--
user_all_env_3.cpython-38.pyc	4.75 KB	-rwxr-xr-x
user_all_env_3.cpython-39.pyc	6.75 KB	-rw-r--r--
user_all_mlm.cpython-38.pyc	6.62 KB	-rwxr-xr-x
user_all_mlm.cpython-39.pyc	6.61 KB	-rw-r--r--
user_all_mlm_env_2.cpython-38....	6.74 KB	-rwxr-xr-x
user_all_mlm_env_2.cpython-39....	6.73 KB	-rw-r--r--
user_env_2.cpython-38.pyc	3.11 KB	-rwxr-xr-x
user_env_2.cpython-39.pyc	3.1 KB	-rw-r--r--
user_mlm.cpython-38.pyc	7.6 KB	-rwxr-xr-x
user_mlm.cpython-39.pyc	7.9 KB	-rw-r--r--
user_mlm_env_2.cpython-38.pyc	8.19 KB	-rwxr-xr-x
user_mlm_env_2.cpython-39.pyc	8.49 KB	-rw-r--r--
user_mlm_env_3.cpython-39.pyc	12.6 KB	-rw-r--r--
user_routes.cpython-38.pyc	1.61 KB	-rwxr-xr-x
user_routes.cpython-39.pyc	1.6 KB	-rw-r--r--

Code Editor : payments_env_3.cpython-38.pyc

�������fg2����������������������@���sF��d�dl�mZmZmZ�d�dlmZ�d�dlmZmZm	Z	�d�dl
mZ�d�dlm
Z
�d�dlmZmZ�d�dlZd�dlmZ�d�d	lmZ�d�dlZd�d
lmZ�d�dlmZ�ed��e�d
�Zee�Zeej
d<�eedddiid��ejddgd�dd���Zdd��Zejddgd�e
dd����Zejddgd�d d!���Z ed"k�rBej!d#d$d%d&��dS�)'�����)�Flask�request�jsonify)�CORS)�	modify_db�query_db�get_db_connection)�
SECRET_KEY)�token_required)�	timedelta�datetimeN)�exc)r���)�load_dotenv)�get_branch_by_userz1/var/www/website2024/py-maracar.afaa.website/.env�WEBSITE_ID3r	���z/*�origins�*)�	resourcesz/payments/api_env_3/create�POST)�methodsc������������������C���s����zDt�j}�t�j}t����d�}t|�t�s.|�g}�|�D��]�}|�d�}|�d�}t�	|�
dd���d�}|�d�}|�d�}|�d�}	|�d	�}
|�d
�}|�d�}|�d�}
|�d
�}|�d�}|�d�}|�d�}d�||||	|
|||||f
k�rtddi�df��W�S�d}t|||||||	|
|||
|||||t
f��q2tddi�dfW�S��tk
�r��}�z*tj�d|�����tddi�df�W�Y��S�d�}~X�Y�nX�d�S�)N�%Y-%m-%d %H:%M:%S�ReferenceNumber�TransactionDate�Zz+00:00�	BookingID�
ExpenseTypeID�
CustomerID�
EmployeeID�Amount�Currency�	Remaining�
PaymentMethod�
PaymentStatus�Status�Notes�errorzMissing required data���a���
            INSERT INTO PaymentTransactions (
                ReferenceNumber, TransactionDate, TransactionUpdate, BookingID, ExpenseTypeID,
                CustomerID, EmployeeID, Amount, Currency, Remaining, PaymentMethod,
                PaymentStatus, Status, Notes, Transaction_IP, websiteID
            ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
            �messagez)Payment transactions created successfully�����z$Payment transaction creation error: �Internal server error����)r����json�remote_addrr����now�strftime�
isinstance�list�get�
fromisoformat�replacer���r����
website_id�	Exception�app�loggerr%���)�payments�	client_ip�current_time�dataZreference_numberZiso_datetimeZmysql_datetime�
booking_id�expense_type_id�customer_id�employee_id�amount�currency�	remainingZpayment_method�payment_status�statusZnotes�query�e��rG����>/var/www/website2024/py-maracar.afaa.website/payments_env_3.py�create_payment3���s\����

��������������rI���c�����������������C���sR���t�j�d|���d���ddg}|�|g}dd�|��}t|t|��}dd��|D��}|S�)	zt
    Function to retry fetching payment details using a different query when no data is found with branch_user.
    z)No payment details found for branch_user z. Retrying with modified query.�pt.EmployeeID = %s�pt.websiteID = %sa���
    SELECT 
        pt.*, 
        ps.id AS StatusPayment, 
        ps.name AS StatusPaymentName, 
        ps.description AS StatusPaymentDescription,
        u.user_ID, 
        u.websiteID, 
        u.branch_ID, 
        u.first_name, 
        u.sur_name, 
        u.telephone, 
        u.email 
    FROM 
        PaymentTransactions pt 
    INNER JOIN 
        status ps ON pt.PaymentStatus = ps.id 
    INNER JOIN 
        `user` u ON pt.EmployeeID = u.user_ID 
    WHERE � AND c�����������������S���s���g�|�]}d�d��|����D���qS�)c�����������������S���s(���i�|�] \}}|t�|t�r t|�n|�qS�rG���)r/���r����str)�.0�k�vrG���rG���rH����
<dictcomp>v���s������z5retry_with_branch_user.<locals>.<listcomp>.<dictcomp>)�items)rN����detailrG���rG���rH����
<listcomp>u���s����z*retry_with_branch_user.<locals>.<listcomp>)r6���r7����info�joinr����tuple)�branch_userr4����
conditions�valuesrE���Zpayment_detailsZprocessed_payment_detailsrG���rG���rH����retry_with_branch_userM���s������r[���z/payments/api_env_3/view�GETc���������������
���C���s����z�t�j�d�}�t�j�d�}t�j�d�}t�j�d�}t�j�d�}t�j�d�}t�j�d�}t�j�d�}t�j�d	�}t�j�d
�}	t�j�d�}
t�j�d�}t�j�d
�}t�j�dd����}
dg}tg}|�r(t��}t|t|�}|����|�rd�dgt	|���}|�
d|��d���|�|��ntddi�dfW�S�|��rB|�
d��|�
|���|�r\|�
d��|�
|��|�rv|�
d��|�
|��|�r�|�
d��|�
|��|�r�t
�|d��d�}|�
d��|�
|��|�r�t
�|d��d�}|�
d��|�
|��|�r|�
d ��|�
|��|�r|�
d!��|�
|��|�r6|�
d"��|�
|��t�j�d#�}t�j�d$�}|�rh|�
d%��|�
|��|�r�|�
d&��|�
|��|	�r�|�
d'��|�
|	��|
�r�|�
d(��|�
|
��t�j�d)�}t�j�d*�}|�r�|�
d+��|�
|��|�r|�
d,��|�
|��d-}|�r"|��d.d/�|����}n|}|�rN|d0|��d1|
d2k�rDd2nd3���7�}t|t|��}|�sr|�rrt|t�}t|�r~|ndd4i�|�r�dnd5fW�S��tk
�r��}�z*tj�d6|�����td7d8i�d9f�W�Y��S�d�}~X�Y�nX�d�S�):Nr���r���r"���r���Z	StartDateZEndDater���r#���r���r���r ���rX���ZSortByZ	SortOrder�ascrK����, z%szu.branch_ID IN (�)r'���z'No data found for the given branch_user�����zpt.BookingID = %szpt.ExpenseTypeID = %szpt.PaymentStatus = %srJ���z%Y-%m-%dr���zpt.TransactionDate >= %szpt.TransactionDate <= %szpt.CustomerID = %szpt.Status = %szpt.Amount = %sZ
AmountGreaterZAmountLesserzpt.Amount >= %szpt.Amount <= %szpt.Currency = %szpt.Remaining = %sZRemainingGreaterZRemainingLesserzpt.Remaining >= %szpt.Remaining <= %sa
��SELECT 
            pt.*,
            ps.id AS StatusPayment,
            ps.name AS StatusPaymentName,
            ps.description AS StatusPaymentDescription,
            u.user_ID,
            u.websiteID,
            u.branch_ID,
            u.first_name,
            u.sur_name,
            u.telephone,
            u.email
        FROM 
            PaymentTransactions pt
        INNER JOIN 
            status ps ON pt.PaymentStatus = ps.id
        INNER JOIN 
            `user` u ON pt.EmployeeID = u.user_ID
        z WHERE rL���z
 ORDER BY pt.� �DESC�ASCzNo payment details foundi���zPayment view error: r%���r)���r*���)r����argsr1����upperr4���r���r����closerV����len�append�extendr���r����strptimer.���r���rW���r[���r5���r6���r7���r%���)r<���r=���rC���r?����
start_date�end_dater>���rD���Zexact_amountrA���Zexact_remainingrX����sort_by�
sort_orderZquery_conditionsrZ����conn�
branch_ids�branch_ids_placeholdersZstart_date_formattedZend_date_formattedZamount_greaterZ
amount_lesserZremaining_greaterZremaining_lesserZ
base_queryrE���Zpayment_datarF���rG���rG���rH����
view_payment3}���s�����

"
&rr���z/payments/api_env_3/update�PUTc������������
���
���C���st���z"t�j}�|��d�}|s*tddi�dfW�S�t�j}ddg}t����d�|g}|����D�]:\}}|dkrR|dkrR|d�k	rR|�	|��d	���|�	|��qRt
|�d
kr�tddi�dfW�S�dd
�|���d�}|�	|��|�	t��t
|t|��}|dkr�tddi�dfW�S�tj�d|t|�������tddi�dfW�S��tk
�rn�}	�z*tj�d|	�����tddi�df�W�Y��S�d�}	~	X�Y�nX�d�S�)N�
TransactionIDr%���z$TransactionID is required for updater&���zTransactionUpdate = %szTransaction_IP = %sr���)r"���r#���z = %s����zFNo data provided to update except TransactionUpdate and Transaction_IPz4
        UPDATE PaymentTransactions SET
            r^���z=
        WHERE TransactionID = %s AND websiteID = %s
        r���z4No record updated, check if the TransactionID existszExecuted SQL Query: r'���zPayment updated successfullyr`���z(Unexpected error during payment update: r)���r*���)r���r+���r1���r���r,���r���r-���r.���rR���rh���rg���rV���r4���r���rW���r6���r7���rU���r5���r%���)
r;����transaction_idr9���Z
update_fieldsrZ����key�valuerE����
affected_rowsrF���rG���rG���rH����update_payment3"��s6����
�

rz����__main__Tz0.0.0.0i���)�debug�host�port)"�flaskr���r���r����
flask_corsr����databaser���r���r����configr	����	decoratorr
���r���r����logging�
sqlalchemyr
����os�dotenvr����user_all_env_3r����getenvr4����__name__r6����routerI���r[���rr���rz����runrG���rG���rG���rH����<module>���s6���

00�$
1

${this.title}

Code Editor : payments_env_3.cpython-38.pyc