"; print_r($product); echo "

"; print_r($folderList); echo "

'700-1' AND mm.BEHAVIOR_ID <> '700-0' AND ii.solution_type_id <> 'ST10' GROUP BY b.`item` ) xx GROUP BY xx.`PAPER_ID` ORDER BY xx.orderby, FIELD(xx.paper_id,{$papers})"; } //if(islocal()) echo '

'.$sql.'

'; }elseif($range=='od'){ $_SESSION['ocnt'] = $ocnt; $sql = "SELECT * FROM ( SELECT * FROM ( SELECT COUNT(b.item) AS icnt,b.item,a.* FROM t_svc_paper a INNER JOIN `t_svc_result_item_log` b ON a.`PAPER_ID` = b.`paper` WHERE b.uid='{$_SESSION['uid']}' AND a.paper_id IN ({$papers}) AND a.paper_title NOT LIKE '%##%' and b.result='0' GROUP BY b.paper, b.item ) z WHERE z.icnt >= '{$ocnt}' ) m GROUP BY m.paper_id ORDER BY m.orderby, FIELD(m.paper_id,{$papers})"; /*$sql = "SELECT a.* FROM t_svc_paper a INNER JOIN `t_svc_incorrect_item` b ON a.`PAPER_ID` = b.`paper` WHERE b.uid='{$_SESSION['uid']}' AND a.paper_id IN ({$papers}) AND a.paper_title not like '%##%' GROUP BY b.paper ORDER BY orderby, FIELD(a.paper_id,{$papers})";*/ //if(islocal()) echo $sql; }else{ $_SESSION['ocnt'] = 0; $sql = "SELECT a.* FROM t_svc_paper a INNER JOIN `t_svc_bookmark_item` b ON a.`PAPER_ID` = b.`paper` WHERE b.uid='{$_SESSION['uid']}' AND a.paper_id IN ({$papers}) AND a.paper_title not like '%##%' GROUP BY b.paper ORDER BY orderby, FIELD(a.paper_id,{$papers})"; } //if(islocal()) echo $sql; $paperList = dbget_ASSOC($sql,$_TXTDB2); //print_r($paperList); $paperList = checkMatchPapers($matchPapers, 'paper', $paperList); ?>

문항이 없습니다.

'700-1' AND ORIGIN_TYPE_CODE='0' AND ITEM_ID IN ({$paper['ITEM_LIST']})",$_TXTDB2); $item_cnt = dbgetone("SELECT COUNT(*) FROM `t_xip_item_meta` a, `t_xip_item` b WHERE a.item_id=b.item_id and a.BEHAVIOR_ID <> '700-1' and a.BEHAVIOR_ID <> '700-0' and b.solution_type_id <> 'ST10' AND a.ITEM_ID IN ({$paper['ITEM_LIST']})",$_TXTDB2); $item_moon = dbgetone("SELECT group_concat(b.item_id) FROM `t_xip_item_meta` a, `t_xip_item` b WHERE a.item_id=b.item_id and a.BEHAVIOR_ID <> '700-1' and a.BEHAVIOR_ID <> '700-0' and b.solution_type_id <> 'ST10' AND a.ITEM_ID IN ({$paper['ITEM_LIST']})",$_TXTDB2); //echo $item_moon; $sql = "SELECT sum(result) as corr, max(regdate) as lastStudyDate, sum(scored) as marked FROM {$restbl} WHERE uid='{$_SESSION['uid']}' and item IN ({$item_moon}) /*AND uip IS NOT NULL*/"; $item_ret = dbgetline_ASSOC($sql,$_TXTDB2); //echo $sql; $cop_cnt = dbgetone("SELECT COUNT(*) FROM `t_xip_item_meta` a, `t_xip_item` b WHERE a.item_id=b.item_id and (a.behavior_id='700-1' or b.solution_type_id='ST10') AND a.ITEM_ID IN ({$paper['ITEM_LIST']})",$_TXTDB2); }else{ $item_cnt = 0; } /*if($paper['solved']>0){ $jindo = floor(($paper['solved']/$item_cnt)*100); $jumsoo = floor(($paper['corr']/$paper['solved'])*100);*/ if($paper['marked']>0){ $jindo = floor(($paper['marked']/$item_cnt)*100); $jumsoo = floor(($paper['corr']/$paper['marked'])*100); }else{ $jindo = 0; $jumsoo = 0; } foreach($defjum as $df){ if($jumsoo>=(int)$defjum[$ini]){ $hj = $hakjum[$ini]; break;} $ini++; } if(0 < $pi){ if(empty($_SESSION['dsID'])){ $paper['corr'] = 0; $jindo = 0; } } $dis_rm = ($psList['dsID'])?"y":"n"; // 싸부 배정 여부 $dis_has_ssabu = ($psList['has_ssabu']==1)?"y":"n"; // 시험지 페이지 $ppg = dbgetone("select page from textbook.t_svc_paper_book where paper='{$paper['PAPER_ID']}'",$_TXTDB2); $ppgn = $ppg?" - ".$ppg."p":""; ?>

'.$sql.'';?>

>>>> " . $range . " <<<<<
"; ?>

0)?'개념: '.$cop_cnt.'':'';?>0&&$item_cnt>0)?', ':'';?>0)?'문제: '. "{$item_ret['corr']}/{$item_cnt}" .'':'';?> , ({$paper['PAPER_ID']})"; }*/?>

=100){?>

0&&$jin==0) $jin=1; ?>

%

소단원 학습 진행률

0){ $dis_rm = ($psList['dsID'])?"y":"n"; // 싸부 배정 여부 $dis_has_ssabu = ($psList['has_ssabu']==1)?"y":"n"; ?>