
    !+iu                         d dl mZmZ d dlmZ d dlmZ d dlmZ d dl	m	Z	m
Z
mZ d dlZ ej                  ddg	      d
        Z ej                  ddg	      d        Zy)    )jsonifyrequest)api_bp)MeliApiService)SessionLocal)datetime	timedeltatimezoneNz/debug/orders-testGET)methodsc                     t               } 	 t        |       }t        |d      r|j                         nd }|sQddlm} | j                  |      j                  |j                  dk(        j                         }|r|j                  nd}t        t        d            }t        j                  |      }|j                  dddd	      }|j!                         }|j!                         }	t#        d
| d|	        |j%                  |||	      }
d}d}d}g }|
D ]  }|dz  }|j'                  d      dk(  r#|dz  }|t)        |j'                  dd            z  }|j+                  |j'                  d      |j'                  d      |j'                  d      |j'                  d      |j'                  d      d        t-        d||	dt/        |
      ||d|
D cg c]  }t1        |j'                  d             c}|d d d      | j3                          S c c}w # t4        $ r2}t-        dt1        |      i      dfcY d }~| j3                          S d }~ww xY w# | j3                          w xY w)N)
db_sessionget_seller_idr   )
OAuthTokenmercadolivreUnknownhourshourminutesecondmicrosecondzDEBUG: Fetching from z to )	date_fromdate_tog           statuspaidtotal_amountiddate_createddate_closed)r!   r   totaldater#   T)fromto)total_encontradopedidos_pagosvalor_total
   )debugperiodoapiResponseall_idsprimeiros_pedidoserrori  )r   r   hasattrr   app.models.oauth_tokenr   queryfilterproviderfirstuser_idr
   r	   r   nowreplace	isoformatprint
get_ordersgetfloatappendr   lenstrclose	Exception)dbservice	seller_idr   token	tz_offsetr9   start_of_day	start_isonow_isoordersr    total_orderspaid_ordersresultsoes                    E/var/www/hypershopcomercio.com.br/hyper-ai/app/api/endpoints/debug.pydebug_orders_testrT      sD   	BC B//6w/PG))+VZ	 :XXj)001D1D1VW]]_U*/YY YR01	ll9%{{!A1{M !**,	--/%i[WI>? ##IG#T 	AALuuX&(q aeeNA&> ?? NNeeDk%%/~.n- uu]3 	 !*';$'K!,+
 399QAEE$K(9!("

 
 	
 :  1#a&*+S00

1 	
sB   G
H !H7H H 	I"I9I:I II I)z/debug/timezonec                     t        j                         } t        t        d            }t        j                  |      }t	        | j                         |j                         t        j                  j                  dd      | j                  dddd      j                         |j                  dddd      j                         d      S )Nr   r   TZzNot Setr   r   )server_time_utc_naiveserver_local_brenv_tztoday_utc_starttoday_br_start)
r   r9   r
   r	   r   r;   osenvironr>   r:   )r9   tz_brnow_brs      rS   debug_timezoner`   P   s    
,,.CYR()E\\% F!$!++-**..y1;;AQaA;NXXZ ..aqa.PZZ\      )flaskr   r   app.apir   app.services.meli_apir   app.core.databaser   r   r	   r
   r\   routerT   r`    ra   rS   <module>rh      sc    "  0 * 2 2 	"UG4E 5EN %1 2ra   