B
    —]É`ö  ã               @   s8   d dl mZ d dlmZ d dlmZ dd„ Zdd„ ZdS )	é    )ÚgetDataIntro)Ú	introData)Ú
sqlConnectc              C   s*   t  ¡ } tƒ }tƒ }tƒ }|||dœ}|S )N)Údo_introÚbar_dataÚfeature_intro)r   ÚMySQLConnectionr   ÚgetSiteDatar   )Úconnectr   r   r   Úresult© r   úRC:\Users\Administrator\Desktop\mbodymap\mbodymap-server\service\helpPageService.pyÚgetHelpData   s    r   c              C   sÖ   t  ¡ } d}|  |¡}dddg}g }g }g }g }x|D ]}| |d ¡ q6W x>|D ]6}	| |	d ¡ | |	d ¡ | |	d |	d	  ¡ qRW |||d
 dddœ}
|||d dddœ}|||d dddœ}|
||g}|S )Nz;SELECT * FROM mbodymap_intro ORDER BY run_num DESC LIMIT 10zQualified runszFailed runszTo be processedÚBodySiteÚQC_1_numÚQC_0_numÚrun_numÚloaded_run_numr   ÚhZbar)ÚyÚxÚnameZorientationÚtypeé   é   )r   r   ÚqueryÚappend)r
   Ú	sql_introÚintroZ
trace_nameZx_dataZy_qZy_fZy_pZitem_xÚitemZtrace_1Ztrace_2Ztrace_3Z
intro_datar   r   r   r	      s>    




r	   N)Úservice.dataPageServicer   Úservice.homePageServicer   Úutilsr   r   r	   r   r   r   r   Ú<module>   s   