o
    ŒFQaö  ã                   @   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   ú9/var/www/html/mybodymap/server/service/helpPageService.pyÚgetHelpData   s   ýr   c                  C   sÌ   t  ¡ } d}|  |¡}g d¢}g }g }g }g }|D ]	}| |d ¡ q|D ]}	| |	d ¡ | |	d ¡ | |	d |	d  ¡ q%|||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 10)zQualified runszFailed runszTo be processedÚBodySiteÚQC_1_numÚQC_0_numÚrun_numÚloaded_run_numr   ÚhÚ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	      sD   
ûûû
r	   N)Úservice.dataPageServicer   Úservice.homePageServicer   Úutilsr   r   r	   r   r   r   r   Ú<module>   s
    