select_data("select * from box where trash=0 order by box_number");
while($r=$db->fetch_data($rs))
echo "";
}
function get_box_name($box_number)
{
$db=new Database();
$rs=$db->select_data("select * from box where box_number='".$box_number."'");
$r=$db->fetch_data($rs);
return $r['box_name'];
}
function get_youtube_key($u)
{
$arr=explode("v=",$u);
return $arr[1];
}
function get_user_reward_point_balance($user_id)
{
$db=new Database();
$rs=$db->select_data("select sum(point) as point1 from user_reward where user_id='".$user_id."' and type='Credit'");
$r=$db->fetch_data($rs);
$rs2=$db->select_data("select sum(point) as point2 from user_reward where user_id='".$user_id."' and type='Debit'");
$r2=$db->fetch_data($rs2);
return $r[point1]-$r2[point2];
}
function get_cent_per_point()
{
$db=new Database();
$rs=$db->select_data("select * from rewardsetting where id=1");
$r=$db->fetch_data($rs);
return $r['cent_per_point'];
}
function get_website_setting($field_name)
{
$db=new Database();
$rs=$db->select_data("select * from website_setting");
$r=$db->fetch_data($rs);
return $r[$field_name];
}
function admin_authentication()
{
if(!isset($_SESSION['admin_id']))
{
Router::redirect('admin');
echo "";
}
}
function user_authentication()
{
if(!isset($_SESSION['user_id']))
{
Router::redirect('login');
echo "";
}
}
function get_logo()
{
$db=new Database();
$rs=$db->select_data("select * from logo where active=1 and trash=0");
$r=$db->fetch_data($rs);
return UPLOAD_PATH."logo/".$r[image];
}
function get_country_list($arr='null')
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from country where trash=0 order by name");
while($r=$db->fetch_data($rs))
{
$sel="";
if(in_array($r['id'], $rsCheckArray))$sel="selected";
echo "";
}
}
function get_state_list($country_id=0, $id)
{
$db=new Database();
$rs=$db->select_data("select * from state where country_id='".$country_id."' and trash=0 order by name");
while($r=$db->fetch_data($rs))
echo "";
}
function get_city_list($state_id=0, $id)
{
$db=new Database();
$rs=$db->select_data("select * from city where state_id='".$state_id."' and trash=0 order by name");
while($r=$db->fetch_data($rs))
echo "";
}
function get_data_name($table, $id)
{
$db=new Database();
$rs=$db->select_data("select * from $table where id='".$id."' and trash=0");
$r=$db->fetch_data($rs);
if($r[name]!=''){ return $r[name];}
if($r[title]!=''){return $r[title];}
}
function get_data_list($table, $display_fld, $value_fld, $order_by)
{
$db=new Database();
$rs=$db->select_data("select * from $table where trash=0 and active=1 $order_by");
while($r=$db->fetch_data($rs))
echo "";
}
function get_data_list_array($table,$arr)
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from $table where trash=0 and active=1 order by name");
while($r=$db->fetch_data($rs))
{
$sel="";
if(in_array($r['id'], $rsCheckArray))$sel="selected";
echo "";
}
}
function get_data_list_array2($table,$arr)
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from $table where trash=0 and active=1 order by name");
while($r=$db->fetch_data($rs))
{
if(in_array($r['id'], $rsCheckArray))
echo "";
}
}
function get_data_name_array($table, $arr)
{
$db=new Database();
$a=explode(",", $arr);
$str="";
for($i=0; $iselect_data("select * from $table where id='".$a[$i]."' and trash=0");
$r=$db->fetch_data($rs);
if($r[name]!=''){ $str=$str."".$r[name]." ";}
if($r[title]!=''){$str=$str."".$r[title]." ";}
}
echo substr($str,0,strlen($str)-1);
}
function get_category_list($type,$arr='null',$orderby='name')
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from category where type='".$type."' and trash=0 and active=1 order by $orderby");
while($r=$db->fetch_data($rs))
{
$sel="";
if(in_array($r['id'], $rsCheckArray))$sel="selected";
echo "";
}
}
function get_category_list_only($type,$arr='null',$orderby='name')
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from category where id in ($arr) and trash=0 and active=1 order by $orderby");
while($r=$db->fetch_data($rs))
echo "";
}
function get_category2_list($category_id)
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from category_2 where category_id='".$category_id."' and trash=0 and active=1 order by name");
while($r=$db->fetch_data($rs))
{
$sel="";
if(in_array($r['id'], $rsCheckArray))$sel="selected";
echo "";
}
}
function get_category3_list($category2_id)
{
$db=new Database();
if($arr!='null'){$rsCheckArray=explode(",",$arr);}
$rs=$db->select_data("select * from category_3 where category_2_id='".$category2_id."' and trash=0 and active=1 order by name");
while($r=$db->fetch_data($rs))
{
$sel="";
if(in_array($r['id'], $rsCheckArray))$sel="selected";
echo "";
}
}
function count_user_data($table, $user_id, $condition)
{
$db=new Database();
$rs=$db->select_data("select * from $table where user_id='".$user_id."' and $condition");
return $db->count_data($rs);
}
function get_currency_converter($amt)
{
$db=new Database();
$rsCurrency=$db->select_data("select * from currency where iso='".strtoupper($_SESSION['selected_currency'])."'");
$rCurrency=$db->fetch_data($rsCurrency);
if($rCurrency[decimal_code]!='')
$symbol=$rCurrency[decimal_code];
else
$symbol=$rCurrency[iso];
if(!isset($_SESSION['selected_currency'])){ return $symbol."".number_format($amt,2); }
else if($_SESSION['selected_currency']=='cad'){ return $symbol."".number_format($amt,2); }
else
{
$rsAmt=$db->select_data("select * from setup_currency_converter");
$rAmt=$db->fetch_data($rsAmt);
$amt2=number_format($rAmt[$_SESSION['selected_currency']]*$amt,2,'.', '');
return $symbol."".number_format($amt2,2);
}
}
function get_currency_converter2($amt)
{
$db=new Database();
if($_SESSION['selected_currency']=='cad'){ return $amt; }
else
{
$rsAmt=$db->select_data("select * from setup_currency_converter");
$rAmt=$db->fetch_data($rsAmt);
$amt2=number_format($rAmt[$_SESSION['selected_currency']]*$amt,2,'.', '');
return $amt2;
}
}
function get_currency_converter3($amt, $from)
{
$db=new Database();
if($from=='cad'){ return $amt; }
if($from!='cad')
{
$rsAmt=$db->select_data("select * from setup_currency_converter");
$rAmt=$db->fetch_data($rsAmt);
$a1=1/$rAmt[strtolower($from)];
$amt2=number_format($a1*$amt,2,'.', '');
return $amt2;
}
}
function get_user_total_revenue($user_id)
{
$db=new Database();
$rs=$db->select_data("select sum(amount) as total from user_revenue where user_id='".$user_id."' and trash=0");
$r=$db->fetch_data($rs);
return $r['total'];
}
function get_user_total_claim($user_id)
{
$db=new Database();
$rs=$db->select_data("select sum(amount) as total from user_claim where user_id='".$user_id."' and trash=0");
$r=$db->fetch_data($rs);
return $r['total'];
}
function total_user_claim_limit($user_id)
{
$db=new Database();
$rs=$db->select_data("select sum(amount) as total from user_revenue where user_id='".$user_id."' and trash=0");
$r=$db->fetch_data($rs);
$rs2=$db->select_data("select sum(amount) as total from user_claim where user_id='".$user_id."' and trash=0");
$r2=$db->fetch_data($rs2);
return ($r['total']-$r2['total']);
}
function goPaypal( $data)
{
define( 'SSL_URL', 'https://www.paypal.com/cgi-bin/webscr' );
define( 'SSL_SAND_URL', 'https://www.sandbox.paypal.com/cgi-bin/webscr' );
$action = '';
//Is this a test transaction?
$action = ($data['paypal_mode']) ? SSL_SAND_URL : SSL_URL;
$form = '';
$form .= '';
return $form;
}
}/// Class End
?>