<?php
define( '_JEXEC', 1 );
define('JPATH_BASE', dirname(dirname(dirname(__FILE__))));
define( 'DS', DIRECTORY_SEPARATOR );
require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
//error_reporting(0);
$mainframe =& JFactory::getApplication('site');

global $mainframe; 


/********************* CSF TYPE LS OPERATION START************************/
 
$db   = JFactory::getDBO();
$user = JFactory::getUser();
 
$sql = "select lender_lcf_percent from #__lending_settings";
$db->setQuery($sql);
$cs_sub_lender_percent = $db->loadResult();
 
unset($sql);
$sql = "SELECT a.rate, b.subscription_date
        FROM `#__cbsubs_plans` AS a, `#__cbsubs_subscriptions` AS b
        WHERE a.id =10 and b.plan_id = 10
        AND b.user_id = ".$user->id;
         
$db->setQuery($sql);
$result = $db->loadObject();
 
if($result){
 
    $cs_amount             = $result->rate * ($cs_sub_lender_percent/100);
    $subscription_date    = $result->subscription_date;
    $userid                = $user->id;
 
    unset($sql);
    $sql = "INSERT INTO #__lending_csf(userid, date, amount, csf_type) 
            VALUES($userid, '$subscription_date', '$cs_amount', 'LS')";
 
    $db->setQuery($sql);
    $db->query();
}
 
/********************* CSF TYPE LS OPERATION END************************/