3
FQa                 @   s    d dl mZ dd Zdd ZdS )    )
sqlConnectc              C   s   t j } d}| j|}d}| j|d }d}| j|d }d}| j|d }d}	| j|	}
d}| j|}| j  |d	 |||t|
d
 t|
d t|
d t|
d |
d |d d
}|S )Nz[SELECT FORMAT(COUNT(DISTINCT ncbi_taxon_id),0) species_num FROM mbodymap_species_to_sampleszWSELECT FORMAT(COUNT(DISTINCT ncbi_taxon_id),0) genus_num FROM mbodymap_genus_to_samples	genus_numz-SELECT COUNT(1) FROM mbodymap_phenotype_indexzCOUNT(1)z@SELECT COUNT(1) FROM mbodymap_phenotype_index WHERE valid_num!=0zSELECT SUM(run_num) run_num, SUM(loaded_run_num) loaded_run_num, SUM(QC_0_num) QC_0_num, SUM(QC_1_num) QC_1_num, COUNT(DISTINCT BodySite) site_num FROM mbodymap_introzCSELECT COUNT(DISTINCT project_id) project_num FROM mbodymap_samplesspecies_numrun_numloaded_run_numQC_0_numQC_1_numsite_numproject_num)
r   r   diseaseTotaldiseaseWithValidr   r   r   r   r	   r
   )r   MySQLConnectionZqueryOnecloseint)connectZsqlIntroZspeciesAndDiseaseNumZ	sql_genusr   Zsql_diseaseTotalr   Zsql_diseaseWithValidr   ZsqlTotaltotalZsqlProjectsr
   result r   9/var/www/html/mybodymap/server/service/homePageService.py	introData   s2    






r   c           	   C   s  t j } d } } } } } } }}dddg}	ddg}
g }d}| j|}xL|D ]B}|d }d	| }| j|}d }}x*|D ]"}|d
 dkr|d7 }q|d7 }qW ||	kr
||7 }||7 }||d 7 }|d7 }|t|	kr|jddj|dj||||d qT||
krl||7 }||7 }||d 7 }|d7 }|t|
kr|jddj|dj||||d qT|j|d dj|dj||||d d qTW |S )Nr   ZRectumZColonZCecumZIleumZDuodenumz,SELECT BodySite, run_num FROM mbodymap_introZBodySitez8SELECT disease FROM mbodymap_samples WHERE BodySite="%s"ZdiseaseZD006262   r   zLarge intestinez{:,})siteZnormalStringZabnormalStringnormalabnormalZrun_num_totalzSmall intestine)r   r   querylenappendformat)r   Z
largeTotalZ
smallTotalZlargeNZlargeAnZsmallNZsmallAnlsZlargeZsmallr   Z	sql_sitesZfindSiteitemr   Zsql_diseaseZfindDiseaser   r   itr   r   r   picAndTblData&   sd     






r"   N)utilsr   r   r"   r   r   r   r   <module>   s   "