Project Details Page

제품상세페이지

페이지 상단 부분

Sponsor Count

후원수

COUNT(DISTINCT tbl_payment.sys_user_id) 

SELECT ai_project_id 
        ,f_project_name
        ,COUNT(DISTINCT tbl_payment.sys_user_id) AS 후원자수  
        ,SUM(f_spon + f_invest) ,TRUNCATE((SUM(f_spon + f_invest)/f_donate_limit)*100,2) AS 펀딩퍼센트
        ,DATEDIFF(f_date_limit,CURDATE()) AS f_daysleft
        ,f_thumbnail_big 
FROM tbl_project
        LEFT JOIN tbl_payment 
                ON tbl_payment.sys_project_id = tbl_project.ai_project_id
        LEFT JOIN tbl_img 
                ON tbl_project.ai_project_id = tbl_img.sys_project_id
WHERE tbl_project.f_div = 'Y' AND tbl_project.ai_project_id = 82;

기업 소개하는 BAR..?

기업 가치 , 주당 가격

SELECT ai_project_id 
        ,f_etp_value 
        ,f_par_value
FROM tbl_enterprise
        LEFT JOIN tbl_project 
                ON tbl_project.ai_project_id = tbl_enterprise.sys_project_id

회사소개

SELECT ai_project_id 
        ,f_etp_name  
        ,f_etp_desc 
        ,f_etp_logo 
        ,f_etp_url
FROM tbl_enterprise
        LEFT JOIN tbl_project 
                ON tbl_project.ai_project_id = tbl_enterprise.sys_project_id

이 Project 의 Rewards

n명이 펀딩했어요!

sys_rewards_id 가 456 인걸 n명이 펀딩했다고 나옴

SELECT COUNT(DISTINCT sys_user_id) AS c_user				 
FROM tbl_payment	
WHERE tbl_payment.sys_rewards_id = 456

프로젝트의 보상 목록

project_id = 71

SELECT  ai_rewards,tbl_rewards.sys_project_id, f_reward_div,f_reward_cont, f_reward_desc, f_reward_money 
FROM tbl_rewards	
WHERE  tbl_rewards.sys_project_id = 71
ORDER BY f_reward_money

게임 설명

Storyline , Summary

SELECT f_storyline, f_summary 
FROM tbl_project
WHERE ai_project_id = 13

Storyline ' s Img , Summary 's Img

SELECT f_storyline_img , f_summary_img 
FROM tbl_img 
WHERE sys_project_id = 13;

페이지 하단 부분 프로젝트 추천

j_link.sys_category_id = 12

SELECT j_link.sys_project_id 
      ,j_link.sys_category_id
      ,j_category.f_category_name
      ,j_project_Sum.f_project_name
      ,j_project_Sum.f_projectTotal
      ,j_project_Sum.f_percent
     	,j_project_Sum.f_etp_name
     	,j_project_Sum.f_daysleft
     	,j_project_Sum.f_thum
     
      
  FROM tbl_pj_category as j_link
       Left join tbl_category AS j_category 
		 	 ON j_link.sys_category_id = j_category.ai_category
       LEFT JOIN (
       
		           SELECT j_project.ai_project_id
							      ,j_project.f_project_name
							      ,sum(j_payment.f_spon + j_payment.f_invest) AS f_projectTotal
							      ,TRUNCATE((sum(j_payment.f_spon + j_payment.f_invest)/j_project.f_donate_limit)*100,2) AS f_percent
							      ,j_etp.f_etp_name AS f_etp_name
							      ,DATEDIFF(f_date_limit,CURDATE()) AS f_daysleft
							      ,j_img.f_thumbnail AS f_thum
							      ,j_project.f_div
							  FROM tbl_project AS j_project 
							     LEFT JOIN tbl_payment AS j_payment 
									 	ON j_project.ai_project_id = j_payment.sys_project_id  
									 LEFT JOIN tbl_enterprise AS j_etp 
									 	ON j_project.ai_project_id = j_etp.sys_project_id
									 LEFT JOIN tbl_img AS j_img 
									 	ON j_project.ai_project_id = j_img.sys_project_id  	    
							 		 GROUP BY j_project.ai_project_id,j_project.f_project_name
								
							 		  
							 
					   ) AS j_project_Sum
				   ON j_project_Sum.ai_project_id = j_link.sys_project_id
		WHERE j_project_Sum.f_daysleft > 0 AND j_link.sys_category_id = 12
		ORDER BY j_project_Sum.f_percent DESC