'.$s;
mysql_query($s);
}
function entery2top_insert($nid,$id,$pos,$depth,$pt)
{
if($id<>0)
{
$s = "INSERT INTO level ";
$s .= "SET m_code='".$nid."'";
$s .= ",under='".$id."'";
$s .= ",side='".$pos."'";
$s .= ",depth='".$depth."'";
//$s .= ",ptype='".$pt."'";
$s .= ",date='".date('Y-m-d')."'";
// echo ''.$s;
if(@mysql_query($s))
return true;
else
return false;
}
}
function randomPrefix_new($length)
{
$random= "";
srand((double)microtime()*1000000);
//$data = "ABCDE123JKLMN67QRSTUVWXYZ";
$data = "123456789123456789123456789123456789";
//$data .= "0FGH45OP89";
for($i = 0; $i < $length; $i++)
{
$random .= substr($data, (rand()%(strlen($data))), 1);
}
return $random;
}
function menu_display($auth_key,$extra_ul='',$extra_ul2='',$path='')
{
print_menu('0',0,$extra_ul,$extra_ul2,SITE_PATH);
}
function shoppe_list($id)
{
?>
".$qr9;
$re9=mysql_query($qr9);
$ro = mysql_fetch_array($re9);
if($ro['code']>0)
{
return '1';
}
else
{
return '0';
}
}
function sponsor_details($id)
{
$sql2 = "Select * from customer where code='".$id."'";
$res2 = mysql_query($sql2);
$result2 = mysql_fetch_assoc($res2);
if($result2['code']>0)
return $result2['customer_code'].' ('.$result2['firstname'].' '.$result2['lastname'].')';
}
function unused_pins($p_type,$user,$where='')
{
$sql="SELECT count(*) as t FROM pin WHERE AND ptype = '".$p_type."' AND status='1' AND type='N' $where";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return (int)($temp['t']);
}
function used_pins($p_type,$user,$where='')
{
$sql="SELECT count(*) as t FROM pin WHERE ptype = '".$p_type."' AND status='1' AND not type='N' $where";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return (int)($temp['t']);
}
function first_date_policy_payment()
{
$qr9="select min(rec_date) as rec_date from consolidate_policy where paid =1 "; //='".$mcode."' ";
//echo " ".$qr9;
$re9=mysql_query($qr9);
$aa = array();
$ro = mysql_fetch_array($re9);
return $ro['rec_date'];
}
function wb($mcode)
{
$qr9="select wc_no from customer_booking where customer_code ='".$mcode."' ";
//echo " ".$qr9;
$re9=mysql_query($qr9);
$aa = array();
while($ro = mysql_fetch_array($re9))
{
$aa[] = $ro['wc_no'];
}
return implode(',',$aa);
}
function addOrdinalNumberSuffix($num) {
if (!in_array(($num % 100),array(11,12,13))){
switch ($num % 10) {
// Handle 1st, 2nd, 3rd
case 1: return $num.'st';
case 2: return $num.'nd';
case 3: return $num.'rd';
}
}
return $num.'th';
}
function print_menu($parent_code,$customer_code,$extra_ul='',$extra_ul2,$path='')
{
$sql = "Select * from pages_website_master where status='1' and display_in_menu='1' and parent_id='".$parent_code."' order by sort_id";
$r = mysql_query($sql);
$no = mysql_num_rows($r);
if($no>0)
{
echo '
';
}
}
function print_menu2($parent_code,$customer_code,$extra_ul='',$extra_ul2,$path='')
{
$sql = "Select * from pages_website_master where status='1' and display_in_menu='1' and parent_id='".$parent_code."' order by sort_id";
$r = mysql_query($sql);
$no = mysql_num_rows($r);
if($no>0)
{
echo '
';
}
}
function no_pages_allowed($cust)
{
$rows['no_pages'] =10;
$sql = "SELECT count(*) as n from pages_website_master ";
$result2 =mysql_query($sql);
$rows2 = mysql_fetch_assoc($result2);
if($rows2['n']<$rows['no_pages'])
return true;
else
return false;
}
function update_tests()
{
$test = array();
$sql = "Select * from create_test where end_date<'".date("Y-m-d")."' ";
$rr = mysql_query($sql);
while($row = mysql_fetch_assoc($rr))
$test[] = $row['code'];
if(count($test)>0)
{
$sql2 = "Select * from question_user_attempt_main where test_finished=0 and test_code IN (".implode(",",$test).")";
$rr2 = mysql_query($sql2);
while($row2 = mysql_fetch_assoc($rr2))
{
$sql ="Select * from create_test where is_deleted=0 and code='".$row2['test_code']."'";
$rr = mysql_query($sql);
$test = mysql_fetch_assoc($rr);
$log = array();
$sql_o = "select * from question_user_attempt where test_code='".$row2['test_code']."' and user_code='".$row2['user_code']."'";
$rr_o = mysql_query($sql_o);
while($row_o = mysql_fetch_assoc($rr_o))
{
$log[$row_o['test_question_code']] = array('action'=>$row_o['action_place'],'answer'=>$row_o['answer']);
}
$correct = 0;
$wrong = 0;
$not_answer = 0;
$wrong = 0;
$ss = "Select q.*,qt.code as qcode from questions_test qt,questions q where qt.test_code='".$row2['test_code']."' and q.code=qt.question_code and q.is_deleted =0 and qt.is_deleted=0 order by qt.code ";
$rr = mysql_query($ss);
while($rows = mysql_fetch_assoc($rr))
{
if($log[$rows['qcode']]['action']==1)
{
if($rows['correct_answer']==$log[$rows['qcode']]['answer'])
$correct+=1;
else
$wrong+=1;
$answer+=1;
}
else
$not_answer++;
}
$neg_mark = ($wrong*(.25));
$total_achieved = ($correct) - $neg_mark;
$total_mark = $test['no_questions'];
$s = "Select * from question_user_attempt_main where test_code='".$row2['test_code']."' AND user_code='".$row2['user_code']."'";
$r = mysql_query($s);
$ro = mysql_fetch_assoc($r);
if($ro['total_q']==0)
{
$s = "Update question_user_attempt_main SET ";
$s.=" test_finished='1'";
$s.=",total_q='".$total_mark."'";
$s.=",total_w='".$wrong."'";
$s.=",total_r='".$correct."'";
$s.=",total_marks='".$total_mark."'";
$s.=",total_marks_achived='".$total_achieved."'";
$s.=" WHERE user_code='".$row2['user_code']."' AND test_code='".$row2['test_code']."' ";
mysql_query($s);
}
}
}
}
function isdelete_sp($tb,$where='')
{
$sql = "SELECT * from $tb $where";
$result =mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows >=1)
return false;
else
return true;
}
function create_select($name,$feild,$tb,$index,$id,$class,$code="code",$first_value="Select",$order="NO",$js="",$type="",$client=1,$where='')
{
//echo ' WHERE '.$where;
//if($client==1)
// $or .= " AND ";
$a = "";
if($tb=='timezone')
$or .= ' GROUP BY timezone';
$or .= ' order by '.$feild;
$sql = "SELECT * FROM $tb where 1 ".$where." ".$or;
// echo $sql;
$qre=mysql_query($sql);
$out = '';
return $out;
}
function common_select($table,$fields,$matchField,$code,$class,$sel,$function,$id,$displayName,$value='code',$others='required',$name_first='--Select--',$order_by='')
{
if($matchField=="")
$qry = "SELECT ".$fields." FROM $table ".$order_by;
else
$qry = "SELECT ".$fields." FROM ".$table." WHERE ".$matchField."='".$code."' ".$order_by;
//echo $qry.' '.$sel;
$res=mysql_query($qry);
$out = '';
return $out;
}
function check_duplicate($tb,$co,$value,$old_id,$code="code",$other='')
{
$sql = "SELECT $co from $tb WHERE $co='".trim(mysql_real_escape_string($value))."' and $code != '".$old_id."' and is_deleted=0 ".$other."";
$result =mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows >=1)
return false;
else
return true;
}
function balance_points($id)
{
$sql="SELECT sum(points) as p FROM entry WHERE userid='".$id."'";
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['p']);
}
function total_sp($id)
{
$qry = "SELECT sum(points) as co FROM entry where userid='".$id."'";
//echo $qry;die();
$result=mysql_query($qry);
while($rows = mysql_fetch_assoc($result))
{
return (int)$rows['co'];
}
return 0;
}
function total_PTP($id)
{
$qry = "SELECT sum(amt) as co FROM ppt_consolidate where userid='".$id."'";
//echo $qry;die();
$result=mysql_query($qry);
while($rows = mysql_fetch_assoc($result))
{
return (int)$rows['co'];
}
return 0;
}
function count_members_vs_type($id,$side,$type=2)
{
$sql="SELECT * FROM members WHERE code='".$id."' AND member_type='2' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$rows =mysql_fetch_array($gateway);
if($rows['code']<=0)
return 0;
$date_payout_start = $rows['payout_start_date'];
$sql="SELECT count(l.code) as t FROM level l INNER JOIN members m ON m.code =l.m_code WHERE l.under='".$id."' AND l.side = '".$side."' and member_type='".$type."' AND payout_start_date>='".$date_payout_start."'";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['t']);
}
function total_count_members_vs_type($id,$side,$type=2)
{
$sql="SELECT count(l.code) as t FROM level l INNER JOIN members m ON m.code =l.m_code WHERE l.under='".$id."' AND l.side = '".$side."' and member_type='".$type."' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['t']);
}
function count_members_vs_type_yettoporcess($id,$side,$type=2)
{
$sql = "SELECT * FROM payout order by code desc limit 0,1";
$re = mysql_query($sql);
$payout = mysql_fetch_assoc($re);
$date_payout_start = $payout['payout_date'];
$sql="SELECT count(l.code) as t FROM level l INNER JOIN members m ON m.code =l.m_code WHERE l.under='".$id."' AND l.side = '".$side."' and member_type='".$type."' AND payout_start_date>='".$date_payout_start."'";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['t']);
}
function direct($member_code)
{
$sql="SELECT count(code) as t FROM members WHERE direct_code='".$member_code."' AND member_type = '2' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return $temp['t'];
}
function check_duplicate_fee($tb,$co,$value,$old_id,$code="code",$s_code)
{
$sql = "SELECT $co from $tb WHERE $co='".trim($value)."' and $code != '".$old_id."' and s_code='".$s_code."' and date_time > '".date("Y-m-d")."' and date_time < '".date("Y-m-".(date("d")+1))."' and is_deleted='0'";
$result =mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows >=1)
return false;
else
return true;
}
function check_checked($id,$user_type)
{
$sql = "SELECT * FROM menu_master_permission where menu_id='".$id."' and user_type='".$user_type."'";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
if($result['id']>0)
return true;
else
return false;
}
function check_menu_selection($se_id,$id)
{
if($se_id==$id)
return true;
$sql = "SELECT * FROM menu_master where code='".$se_id."'";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
if($result['parent_id']==$id)
return true;
else
return false;
}
function fetch_details($tb,$col,$code)
{
$sql = "SELECT * from $tb WHERE $col='".$code."'" ;
$result = mysql_query($sql);
$rows = mysql_fetch_assoc($result);
return $rows;
}
function fetch_details_assoc($tb,$col,$code)
{
$sql = "SELECT * from $tb WHERE $col='".$code."'" ;
$result = mysql_query($sql);
$r = array();
while($rows = mysql_fetch_assoc($result))
{
$r[] = $rows;
}
return $r;
}
function isdelete($tb,$col,$id,$where='')
{
$sql = "SELECT * from $tb WHERE $col='".trim($id)."' ".$where;
$result =mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows >=1)
return false;
else
return true;
}
function check_duplicate_where($tb,$co,$value,$old_id,$code="code",$where='')
{
$sql = "SELECT $co from $tb WHERE $co='".trim(mysql_real_escape_string($value))."' $where and $code != '".$old_id."'";
$result =mysql_query($sql);
$rows = mysql_num_rows($result);
if($rows >=1)
return false;
else
return true;
}
function check_issued($date)
{
$sql = "SELECT count(*) as c FROM consolidate WHERE date='".date("Y-m-d",strtotime($date))."' and type='PAID' and amt<0 and cheque_no='' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['c']);
}
function calculate_total_paid_y($mcode,$start_date,$end_date)
{
$sql = "SELECT sum(amt) as amount FROM consolidate c WHERE type='PAID' and amt<0 and m_code='".$mcode."' group by m_code";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['amount']);
}
function calculate_total_paid_tds($mcode,$start_date,$end_date)
{
$sql = "SELECT sum(amt) as amount FROM consolidate c WHERE type='TDS' and amt<0 and m_code='".$mcode."' group by m_code";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['amount']);
}
function total_lp($id)
{
$qry = "SELECT sum(amt) as co FROM consolidate_lp where m_code='".$id."'";
//echo $qry;
$result=mysql_query($qry);
while($rows = mysql_fetch_assoc($result))
{
return (int)$rows['co'];
}
return 0;
}
function total_lp_mobile($mobile)
{
$qry = "SELECT * FROM members where mobile='".$mobile."'";
$result=mysql_query($qry);
$rows = mysql_fetch_assoc($result);
$qry = "SELECT sum(amt) as co FROM consolidate_lp where m_code='".$rows['code']."'";
$result=mysql_query($qry);
while($rows = mysql_fetch_assoc($result))
{
return (int)$rows['co'];
}
return 0;
}
function parent_id($id)
{
$sql="SELECT * FROM level WHERE m_code='".$id."' AND depth = '1' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['under']);
}
function count_members($id,$side)
{
$sql="SELECT count(*) as t FROM level WHERE under='".$id."' AND side = '".$side."' ";
//echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp['t']);
}
function product_expense($start_date,$end_date)
{
$sql="SELECT sum(op.qty) as qty,op.product_id,p.product_name,lic_price FROM crm_order_products_details op LEFT JOIN product p ON op.product_id=p.product_id WHERE op.order_id IN (SELECT o.order_id FROM crm_order o INNER JOIN customer c ON o.customer_id=c.customer_id AND crm_client='".$_SESSION['client_id']."' WHERE o.status='1' AND (order_date >= '".$start_date."' AND order_date<= '".$end_date."')) Group By op.product_id";
//echo "
".$sql;
$gateway=mysql_query($sql);
$t = 0;
while($rows=mysql_fetch_array($gateway))
{
$t += $rows['qty'] * $rows['lic_price'];
}
return ($t);
}
function common_select_all($table,$fields,$matchField,$code,$class,$sel,$function,$id,$displayName,$value)
{
if($table=="departments")
{
if($matchField=="")
$qry = "SELECT ".$fields." FROM $table where is_deleted=0 ";
else
$qry = "SELECT ".$fields." FROM ".$table." WHERE is_deleted=0 and ".$matchField."='".$code."'";
}
else
{
if($matchField=="")
$qry = "SELECT ".$fields." FROM $table";
else
$qry = "SELECT ".$fields." FROM ".$table." WHERE ".$matchField."='".$code."'";
}
//echo $qry;
$res=mysql_query($qry);
$out = '';
return $out;
}
function number_select($start,$end,$index,$name,$class,$first_value="select",$extra_print="")
{
$out = '';
return $out;
}
function display_feild($table,$dispay_feild,$feild,$id)
{
$sql="SELECT $dispay_feild FROM $table WHERE $feild = '".$id."' ";
// echo "
".$sql;
$gateway=mysql_query($sql);
$temp=mysql_fetch_array($gateway);
return ($temp[$dispay_feild]);
}
function fetchfromtable_one($table,$code,$data)
{
$sql = "SELECT * FROM ".$table." WHERE ".$code."='".$data."'";
$res = mysql_query($sql);
$result = mysql_fetch_assoc($res);
return $result;
}
function show_ferchise($id)
{
$rows = fetchfromtable_one("members","code",$id);
?>
Member Details
M Code :
Name :
Student Details
S Code :
Name :
Phone :
Course :
';
$out .='';
$a = date("2015-01-01");
$b = date("Y-M-01");
while(strtotime($a)<=strtotime($b))
{
if(strtolower($a)==strtolower($sel))
$out .='';
else
$out .='';
$a = date("Y-m-01",strtotime("+1 Months",strtotime($a)));
}
$out .= '';
return $out;
}
/* #############################
# Used to calcuate the reedeme vouchers of scheme and show it in booking list
# Date : 20-05-22
###############################*/
function reedemed_vouchers($id)
{
$sql = "select sum(amt) as amt,count(*) as c from consolidate_policy_used where policy_code='".$id."' and paid=1";
$res = mysql_query($sql);
$result2 = mysql_fetch_assoc($res);
return $result2['amt'];
}
?>