title = $aInt->lang('billableitems', 'title'); $aInt->sidebar = 'billing'; $aInt->icon = 'billableitems'; $aInt->requiredFiles(array( 'invoicefunctions', 'gatewayfunctions' )); if( $action == 'save' ) { check_token("WHMCS.admin.default"); $description = trim($whmcs->get_req_var('description')); if( !$userid ) { $aInt->gracefulExit($aInt->lang('billableitems', 'noclientsmsg')); } $duedate = toMySQLDate($duedate); getUsersLang($userid); if( $id ) { if( $hours != 0 ) { if( strpos($description, " " . $_LANG['billableitemshours'] . " @ ") !== false ) { $description = substr($description, 0, strrpos($description, " - ")) . " - " . $hours . " " . $_LANG['billableitemshours'] . " @ " . $amount . '/' . $_LANG['billableitemshour']; } $amount = $amount * $hours; } update_query('tblbillableitems', array( 'userid' => $userid, 'description' => $description, 'hours' => $hours, 'amount' => $amount, 'recur' => $recur, 'recurcycle' => $recurcycle, 'recurfor' => $recurfor, 'invoiceaction' => $invoiceaction, 'duedate' => $duedate, 'invoicecount' => $invoicecount ), array( 'id' => $id )); } else { if( $hours != 0 ) { $description .= " - " . $hours . " " . $_LANG['billableitemshours'] . " @ " . $amount . '/' . $_LANG['billableitemshour']; $amount = $amount * $hours; } $id = insert_query('tblbillableitems', array( 'userid' => $userid, 'description' => $description, 'hours' => $hours, 'amount' => $amount, 'recur' => $recur, 'recurcycle' => $recurcycle, 'recurfor' => $recurfor, 'invoiceaction' => $invoiceaction, 'duedate' => $duedate )); } redir(); } if( $action == 'delete' ) { check_token("WHMCS.admin.default"); delete_query('tblbillableitems', array( 'id' => $id )); redir(); } ob_start(); if( !$action ) { if( $invoice && is_array($bitem) ) { check_token("WHMCS.admin.default"); checkPermission("Manage Billable Items"); foreach( $bitem as $id => $v ) { update_query('tblbillableitems', array( 'invoiceaction' => '1' ), array( 'id' => $id )); } infoBox($aInt->lang('billableitems', 'invoiceitems'), $aInt->lang('billableitems', 'itemswillinvoice')); echo $infobox; } if( $delete && is_array($bitem) ) { check_token("WHMCS.admin.default"); checkPermission("Manage Billable Items"); foreach( $bitem as $id => $v ) { delete_query('tblbillableitems', array( 'id' => $id )); } infoBox($aInt->lang('billableitems', 'itemsdeleted'), $aInt->lang('billableitems', 'itemsdeleteddesc')); echo $infobox; } $aInt->deleteJSConfirm('doDelete', 'billableitems', 'itemsdeletequestion', "billableitems.php?userid=" . $userid . "&action=delete&id="); echo $aInt->Tabs(array( $aInt->lang('global', 'searchfilter') ), true); echo "\n
\n
\n\n
\n\n\n\n
"; echo $aInt->lang('fields', 'client'); echo ""; echo $aInt->clientsDropDown($userid, '', 'userid', true); echo ""; echo $aInt->lang('fields', 'amount'); echo "
"; echo $aInt->lang('fields', 'description'); echo ""; echo $aInt->lang('fields', 'status'); echo "
\n
\n
lang('global', 'searchfilter'); echo "\" class=\"button\">
\n\n
\n\n
\n
\n\n
\n\n"; $aInt->sortableTableInit('id', 'DESC'); $where = array( ); if( $status == 'Uninvoiced' ) { $where['invoicecount'] = 0; } else { if( $status == 'Invoiced' ) { $where['invoicecount'] = array( 'sqltype' => ">", 'value' => '0' ); } else { if( $status == 'Recurring' ) { $where['invoiceaction'] = 4; } else { if( $status == "Active Recurring" ) { $where['invoiceaction'] = 4; $where['invoicecount'] = array( 'sqltype' => "<", 'value' => 'recurfor' ); } else { if( $status == "Completed Recurring" ) { $where['invoiceaction'] = 4; $where['invoicecount'] = array( 'sqltype' => ">=", 'value' => 'recurfor' ); } } } } } if( $description ) { $where['description'] = array( 'sqltype' => 'LIKE', 'value' => $description ); } if( $amount ) { $where['amount'] = $amount; } if( $userid ) { $where['userid'] = $userid; } $result = select_query('tblbillableitems', "COUNT(*)", $where); $data = mysql_fetch_array($result); $numrows = $data[0]; $result = select_query('tblbillableitems', "tblbillableitems.*,tblclients.firstname,tblclients.lastname,tblclients.companyname,tblclients.groupid,tblclients.currency", $where, $orderby, $order, $page * $limit . ',' . $limit, "tblclients ON tblclients.id=tblbillableitems.userid"); while( $data = mysql_fetch_array($result) ) { $id = $data['id']; $userid = $data['userid']; $firstname = $data['firstname']; $lastname = $data['lastname']; $companyname = $data['companyname']; $groupid = $data['groupid']; $currency = $data['currency']; $description = $data['description']; $hours = $data['hours']; $amount = $data['amount']; $invoiceaction = $data['invoiceaction']; $invoicecount = $data['invoicecount']; $currency = getCurrency('', $currency); $amount = formatCurrency($amount); if( $invoiceaction == '0' ) { $invoiceaction = $aInt->lang('billableitems', 'dontinvoice'); } else { if( $invoiceaction == '1' ) { $invoiceaction = $aInt->lang('billableitems', 'nextcronrun'); } else { if( $invoiceaction == '2' ) { $invoiceaction = $aInt->lang('billableitems', 'nextinvoice'); } else { if( $invoiceaction == '3' ) { $invoiceaction = $aInt->lang('billableitems', 'invoiceduedate'); } else { if( $invoiceaction == '4' ) { $invoiceaction = $aInt->lang('billableitems', 'recurringcycle'); } } } } } if( $invoicecount ) { $invoiced = $aInt->lang('global', 'yes'); } else { $invoiced = $aInt->lang('global', 'no'); } $managelink = ""; $tabledata[] = array( "", $managelink . $id . "", $aInt->outputClientLink($userid, $firstname, $lastname, $companyname, $groupid), $managelink . $description . "", $hours, $amount, $invoiceaction, $invoiced, $managelink . "\""lang('global', 'edit') . "\">", "\""lang('global', 'delete') . "\">" ); } $tableformurl = $_SERVER['PHP_SELF'] . "?status=" . $status; $tableformbuttons = "lang('billableitems', 'invoicenextcronrun') . "\" onclick=\"return confirm('" . $aInt->lang('billableitems', 'invoicenextcronrunconfirm', '1') . "')\" /> lang('global', 'delete') . "\" class=\"btn-danger\" onclick=\"return confirm('" . $aInt->lang('global', 'deleteconfirm', '1') . "')\" />"; echo $aInt->sortableTable(array( 'checkall', array( 'id', $aInt->lang('fields', 'id') ), $aInt->lang('fields', 'clientname'), array( 'description', $aInt->lang('fields', 'description') ), array( 'hours', $aInt->lang('billableitems', 'hours') ), array( 'amount', $aInt->lang('fields', 'amount') ), array( 'invoiceaction', $aInt->lang('billableitems', 'invoiceaction') ), array( 'invoicecount', $aInt->lang('status', 'invoiced') ), '', '' ), $tabledata, $tableformurl, $tableformbuttons); } else { if( $action == 'manage' ) { $jquery = ''; if( $id ) { $pagetitle = $aInt->lang('billableitems', 'edititem'); $result = select_query('tblbillableitems', '', array( 'id' => $id )); $data = mysql_fetch_array($result); $id = $data['id']; $userid = $data['userid']; $description = $data['description']; $hours = $data['hours']; $amount = $data['amount']; if( $hours != 0 ) { $amount = format_as_currency($amount / $hours); } $recur = $data['recur']; $recurcycle = $data['recurcycle']; $recurfor = $data['recurfor']; $invoiceaction = $data['invoiceaction']; $invoicecount = $data['invoicecount']; $duedate = fromMySQLDate($data['duedate']); } else { $pagetitle = $aInt->lang('billableitems', 'additem'); $clientcheck = get_query_val('tblclients', 'id', ''); if( !$clientcheck ) { $aInt->gracefulExit($aInt->lang('billableitems', 'noclientsmsg')); } $invoiceaction = 0; $recur = 0; $duedate = getTodaysDate(); $hours = "0.0"; $amount = "0.00"; $invoicecount = 0; $options = ''; $products = new WHMCS_Product_Products(); $productsList = $products->getProducts(); foreach( $productsList as $data ) { $pid = $data['id']; $pname = $data['name']; $ptype = $data['groupname']; $options .= "