U
    qc_r                     @   s   d dl Z d dlmZmZ d dlmZ d dlmZmZ d dlmZ d dl	Z	d dl
mZ d dlmZmZ d dlZd dlmZ d dlZd dlZd d	lmZ d d
lT d dlmZ d dlmZ d dlmZ G dd dejZdS )    N)copydeepcopy)Decimal)datetimetimezone)Logger)Path)DictIterator)cached_property)commit_all_ds)*)fields
cmf_import)
log_configc                       s  e Zd Zejjd ZdZeedddZ	dd Z
eddd	Z fd
dZdd Zdd Zdd Zed1ddZedd Zeejdd Zd2edddZdd Zeddd Zd!d" Zd#d$ Zd%d& Zeejddd'd(Zd)d* Z fd+d,Z  fd-d.Z!d/d0 Z"  Z#S )3	CmfImport)CSV_SETTING_NAMEcsv_import_settings_fieldsloggerZCSV)returnc                 C   s   t j|  dddS )uE    Журнал логирования процесса импорта    i@KL )ZbackupCountZmaxBytes)r   Z
get_loggerget_files_dirself r   ./common/models/cmf_import.pyr      s    zCmfImport.loggerc                 O   s8   |    tj }tjtj | s4| j	d |S )uK   
        Возвращает путь текущему файлу
        init)
r   r   LOG_NAMEospathexistsconfig
UPLOAD_DIRr   info)r   argskwargs	file_pathr   r   r   get_log_filename   s    zCmfImport.get_log_filenamec                 O   sx   |    tj }tjtj | s4| j	d g }t
tj|    D ]&}|tjrL||    |  qL|S )u   
        Список файлов после logrotate, чтобы можно было загрузить историю
        r   )r   r   r   r   r    r!   r"   r#   r   r$   listdir
startswithappend)r   r%   r&   r'   res	file_namer   r   r   get_log_filenames(   s    zCmfImport.get_log_filenamesc                    s$   | j s| jjdd| _ t   d S )NZOPENstatus_type)statusworkflowget_default_statussuper_calc_statusr   	__class__r   r   r5   5   s    zCmfImport._calc_statusc                 C   s  | j d rd S | jr(| j | j d< d S | jdkr6d S | j d dtj tjjd | j d dtj	 tj	jd | j d dtj
 tj
jd | j d dtj tjjd | j d dtj tjjd | j d d	tj tjjd d S )
NZmodels_fieldsexcelu   Поля контактов)Zcaptionr   iconu   Поля задачu   Поля заметокu   Поля проектовu"   Поля списков задачu   Поля групп)json_settingspluginZcalc_models_settingstyper+   models	CmfPersonZimport_shop_fieldsr9   CmfTaskZ
CmfComment
CmfProjectCmfListZCmfPersonGroupr   r   r   r   _calc_models_settings:   s>    

zCmfImport._calc_models_settingsc                 K   sH   |  ddddg | jd r d S | jj| d| jd< | j| _|   d S Nr:   attachmentsr<   r;   import_settingsr   )load_fieldsr:   r;   calc_import_settingssaver   r&   r   r   r   rG   U   s    
zCmfImport.calc_import_settingsc                 K   sH   |  ddddg | jd r d S | jj| d| jd< | j| _|   d S rC   )rF   r:   r;   tmplt_import_settingsrH   rI   r   r   r   rJ   _   s    
zCmfImport.tmplt_import_settings c                 C   s4   d|  d d} td|  d|  t|  d S )Nu1   Ошибка при импорте данных. .ue   . Проверьте загружаемый файл и повторите попытку снова.zCmfImportError: : )striploggingerrorZ	cmf_alert)msger   r   r   
_log_errorg   s    zCmfImport._log_errorc                 C   s:   |  dg | jd D ]}|d | jkr|d   S qg S )Nr:   rE   namer   )rF   r:   r   )r   settingsr   r   r   r   m   s
    z$CmfImport.csv_import_settings_fieldsc              
   O   s(  dt jd< t  t  tjj| dddgd}|j	d |j
jdd	d
|_|  t  | }|r|j	d |j
jdd|_|  n0|jjdkr|j	d |j
jdd|_|  |jjd jtjd}W 5 Q R X W 5 Q R X tjj|tjjj|jdttj dd| ddd dS )uJ   
        Запускаем в фоне импорт данных
        1importr2   r1   progressidr   u%   ***Запускаем импорт***ZIN_PROGRESSimport-started)r0   status_codeu2   ***Импорт успешно завершен***ZCLOSEDr/   u7   ***Импорт завершен с ошибками***import-errorr\   r   z/files/u+   Импорт данных завершен z%d.%m.%Y %H:%Mz
, <a href=u(   >Журнал логирования</a>T)objZ	person_idrT   rQ   Zis_notify_current_personN)!r   environcmfutildisable_acldisable_notifyr=   r   getr   r$   r2   r3   r1   rH   commit_with_eventprocess_importr0   ZhandlersZbaseFilenamereplacer"   r#   Z	CmfNotifyZplace_notifygZcurrent_personrZ   valuerT   r   nowr   utc)Z	import_id_args_kwargsr_   r,   Zlog_pathr   r   r   startu   s0    

,zCmfImport.startN)rowc              	   C   s4  d}|dkr|j }|sg }i }t| jD ]Z\}}|d r(|| r(|d d dd |jkr^q(|d d |kr(|| ||d d < q(|s|S || d}	tt|	d	}
|D ]}|j|}t	|tj
st	|tjr,d}| D ]8}|jd
dd|| gd	d|| ggdgd}|r qq|r,t|	|| qt	|tjr<qt|	|||  || }t	|tjr~t|d}t|tjj}t	|tjrq||d|g q| jd r|j|dgd}|s0|d	}|r|j|dgdd}|r|
|	_|j|	jdgd}|r$|	j dttjd|	_|	}|  |S )u  
        Импортируем объект

        :param list row: Строка из файла
        :param models.* model: Модель для создания объекта
        :param list _filter: Для фильтрации объекта
        :param str key: Ключевое имя для сопоставления модели

        :return: Новый или найденный объект
        :rtype: Optional[models.*]
        Nmodel_fieldfield_qualnamerL   r   verbose_name
field_namer   codeORrT   ==z**)filterr   ZRUunionT)rt   r   Zinclude_deleted)rT   r   _z%Y%m%d-%H%M%S)rr   	enumerater   split
class_namestrgetattrr   rd   
issubclassZCmfRelationZCmfGenericRelationZrelated_modelssetattrZ
CmfRelBaseZCmfPhonephonenumbersparseZformat_numberZPhoneNumberFormatZINTERNATIONALZ
CmfNumericr+   r:   rt   rT   r   rj   r   rk   rH   )r   ro   model_filterkeyresult_fieldsisettingZnew_objZnew_coders   ZfieldZrel_objZ	rel_modelvalZphonert   r   r   r   _process_obj   sp    

zCmfImport._process_objc              
   C   s   |  dddddg | jrz0t  | jj| dW  5 Q R  W S Q R X W n tk
r } zl| dt  }t| t	| dt
|jd	  }| j| || _| jjd
d| _|   W Y dS d}~X Y nX | jdkr|  S dS )u9   
        Импортируем файл в бд
        r8   rE   	first_rowr;   rD   r   rM   
r]   r^   FN)rF   r;   ra   Zenable_import_moderf   	Exception	traceback
format_excr   r}   	format_tb__traceback__r   	exception	error_msgr2   r3   r1   rH   r<   _process_import_excel)r   errerr_msg
error_textr   r   r   rf      s     
&
zCmfImport.process_importc           4      C   sf  ddl m} | jr| jd s dS d}zi }i }i }i }i }i }i }	|  }
t|
D ](\}}|dkrr| jd rrqTi }i }d}d}t| jD ],\}}|d r|| sq|d d d	d }||i }|d d
 d	}|d }|| }|dkr|}qn|dkr|}qt	|dkrP|dkr2|||d < q||i }|| ||d < nZ|dkrt|dkrt|
|| }n6|dkr||| }n|dkrd||| i}|||< |||< q|di }|dd}||d}|s|| tj|\}}|||d< || tj|\}}|di }|drD|d |d< |di }|r|	|}|s|dkrtjjddtjjddd}ntjjddtjjddd}||	|< ||d < ||d< ||d!< ||d"< d#d$d%|jgdd%|d gg}|| tj||\} }| j| |   | ||d < |rH||g }!|!|  |!||< |rt||d g }"|"| |"||d < |d&i d'd}#|#r|# d(|jj }$||$i }%||%d!< |#|%d'< |%d)g }&|&|  |&|%d)< |%||$< ||d}'|'sftjjd#d*d%|jgd'd%d+ggd,}(d#d*d%|(jgd'd%d-gg})d-||(d.d/}*|j| tj|*|)d0\}'}|'||d< || jtj|'| d1 qT|  D ]\}$}+tjjd#d*d%|+d! jgd'd%d2ggd,}(d#d*d%|(jgd'd%|+d' gdd3d4gg})tjj|)d,},|,stj|+d! |(|+d' tj!jd5dd6},|,  |+d) D ]} |,| _"| jd7d8 q"q|  D ]>\}}-||}.|.rH|-D ]}/|/j"#  |.|/_"|/  qdqH|  D ]N\}}0||}.|.r|0D ].}1||1}/|/r|/j"#  |.|/_"|/  qqW n~ t$k
r` }2 z^t%|2 d9| d:|2 d;t&'|2j(d<  }3| j)*|3 |3| _+| j,j-d=d>| _.|   W Y dS d?}2~2X Y nX d7S )@u   
        Запуск импорта из CSV

        :return: Истина в случае успешного импорта
        r   )CmfPluginImportMixinrE   Fr   rK   rp   rq   rL   rs   parent_taskZchild_tasks   	executorslogic_prefixr@   priorityr1   r0   zproject.agilert   r?   Z
cmf_authorZ	cmf_ownerzproject.basez
task.base%basert   )Z	cmf_modelprefixZactivityztask.agile:softdev%Zsoftdevr2   projectparentZANDZ	parent_idrv   rA   rT   ry   tasksZtree_parent_idZSprints)rw   u
   ДоскаZkanban)rT   r   tree_parentZ	list_type)r   r   
obj_fields
filter_obj)leftrightZEpics=z	task.epicztask.epic:default)r   r   rT   Z
logic_typeT)Z	only_datau   Строка rM   r   r   r]   r^   N)/Z%common.models.cmf_plugin_import_mixinr   rD   r:   Z	_get_filerz   r   r{   rd   lenZget_logic_prefixZget_priorityZget_status_type
setdefaultZprocess_any_table_fieldsr=   r@   r>   CmfWorkflowZcalc_workflowZCmfActivityrZ   r?   r   r+   rH   rt   ri   Z	CmfFolderrA   r   ZCmfListCmfTaskitemsZCmfLogicTyper   loadr   r   r   r   r   r   r   r   r2   r3   r1   )4r   r   Z
number_rowZall_parent_taskZall_child_tasksZall_epic_tasksZ	all_tasksZ
cash_boardZcash_projectZcash_workflow_taskZ	file_readro   executorr   Zparent_task_codeZchild_tasks_codeidxr   Z
model_nameZ_rowZfields_namers   ri   Zproject_fieldsr   r   ry   Zexecutor_objZtask_fieldsZvalue_statusr2   Zfilter_taskZtask_objZtmp_parent_tasksZtmp_child_tasksZ	epic_nameZepic_keyZtmp_dataZ	tmp_tasksZlist_objZparent_folderr   r   dataZepic_objr   r   Zsub_taskZ
tasks_codeZsub_task_coder   r   r   r   r   r      sL   








 



 




"zCmfImport._process_import_excelc                 C   s>  |  |tj}|r|sdS d}| jD ] }|d r$|d d dkr$|}q$|dg tjj|jt|d |j	jdgd}|stj|t|d |j	| d	}|
  |jjd
d t|jjD ]*}|jj| jkrq|  |jj| q| j |tjtjjdd|jgdd|jggd}|ddg ||_||_|jr:|
  |S )u;   
        Импорт товара в сделку
        Nrp   rq   zCmfProduct.pricescurrencyfile_valprice)
product_idr   Zcurrency_idr   )productr   r   r   T)forceZdeal_idrv   r   )r   r   r   Zsales_order)r   r=   Z
CmfProductr   rF   ZCmfPricerd   rZ   r   r   rH   Zpricesr   r   Z
deal_itemsri   r   deleteremoveZCmfDealItemsrr   dealr   
is_changed)r   ro   r   r   Zprice_settingrU   r   itemr   r   r   _process_product  s@    
 zCmfImport._process_productc           	      C   s  |s|r|j sd S d }| jD ] }|d r|d d dkr|}q|sFd S g }tjj|d d}|sxtj|d d}|  |dd|jg |r|dd|jg n|dd|j jg | |tj	|}|
d	d
g |j s|r||_ n|j |_ |js||_|jr
|  |S )Nrp   rq   zCmfDeal.pipeliner   )rT   Zpipeline_idrv   Z
company_idcompanypipeline)r   r   r=   ZCmfPipelinerd   rH   r+   rZ   r   ZCmfDealrF   r   r   )	r   ro   Zcontactr   Zpipeline_settingrU   r   r   r   r   r   r   _process_deal  s8    
zCmfImport._process_dealc                 C   s<   t jj| jdgd}|jjdkr8d|_|jr4|  dS dS )Nr1   rY   )import-cancelingimport-canceledr]   import-stoppingr   TF)r=   r   rd   rZ   r1   rt   r   rH   )r   r_   r   r   r   	is_cancel   s    zCmfImport.is_cancelc                  O   s0  t   t   tjj|d ddgd}|jjdkr|jjdkrf|jj	dd|_|
  t  td	D ]t}td
 tjj|jddgd}|jjdkr q|dkrnd|_|jj	dd|_|
   W 5 Q R  W 5 Q R  dS qnn|jj	dd|_|
  t  zzd}|jd |j  t|j}|rd| }|jD ]N}| j|7  _|
  t|tjrnqB|jd|  |  t  qB|jj	dd|_|jd W nX tk
r } z8|jd|  t| t||_|jj	dd|_W 5 d}~X Y nX W 5 |
  X W 5 Q R X W 5 Q R X dS )u/   
        Отменяем импорт
        rZ   r1   r2   rY   )r[   r   r[   r   r^   <   r   r   ;   u5   Не удалось остановить импортr]   Nu#   ***** Отменяем импортd   u   Удаляем r   u,   Успешно отменили импортu   Ошибка удаления )ra   rb   rc   r=   r   rd   r1   rt   r2   r3   rH   re   rangeZgeventsleeprZ   r   r   r$   Zimport_objectsr   r   rX   
isinstancer>   r   r   r   r   r}   )r%   r&   r_   r   ro   totalsteprR   r   r   r   cancel	  sV    





&zCmfImport.cancelc                 O   s    |  ddddg | jj| dS )uk   
        Предварительный просмотр получившихся объектов
        r:   rD   r<   r;   r   )rF   r;   preview)r   r%   r&   r   r   r   r   @  s    zCmfImport.previewc                    s   t   dddddg S )Nr:   rD   r<   r1   r;   )r4   save_preload_fieldsr   r6   r   r   r   G  s    zCmfImport.save_preload_fieldsc                    s   |    t jf |S )N)rB   r4   rH   rI   r6   r   r   rH   J  s    zCmfImport.savec                 C   s@   | j r
d S | jr,| jjdkr,tjjdd| _ tjjdd| _ d S )NZCmfPluginJirazimport.system.jira:defaultr   zimport.system:default)r2   r;   r|   r=   r   rd   r   r   r   r   _calc_workflowN  s
    zCmfImport._calc_workflow)rK   )NN)$__name__
__module____qualname__r   r   Zui_meta_skipr   r   r   r   r(   listr.   r5   rB   rG   rJ   staticmethodrS   r   Z
celery_appZtaskrn   r   rf   boolr   r   r   r   r   r   r   rH   r   __classcell__r   r   r6   r   r      s>   	

 N B!#	5r   )Zcsvr   r   Zdecimalr   r   r   rO   r   r   pathlibr   typingr	   r
   r   r   ZxlrdZopenpyxlZcmf.data_providers.baser   Zcmf.includeZcmfr   Zcommon.fieldsr   Zcmf.modules.logsr   r   r   r   r   r   <module>   s"   