title = "Configurable Option Groups";
$aInt->sidebar = 'config';
$aInt->icon = 'configoptions';
$aInt->helplink = "Configurable Options";
if( $manageoptions )
{
$result = select_query('tblcurrencies', '', '', 'code', 'ASC');
while( $data = mysql_fetch_array($result) )
{
$curr_id = $data['id'];
$curr_code = $data['code'];
$currenciesarray[$curr_id] = $curr_code;
}
$totalcurrencies = count($currenciesarray) * 2;
if( $save )
{
check_token("WHMCS.admin.default");
checkPermission("Edit Products/Services");
if( !$cid )
{
$cid = insert_query('tblproductconfigoptions', array( 'gid' => $gid, 'optionname' => $configoptionname ));
}
if( $optionname == '' )
{
$optionname = array( );
}
if( $addoptionname == '' )
{
$addoptionname = array( );
}
update_query('tblproductconfigoptions', array( 'optionname' => $configoptionname, 'optiontype' => $configoptiontype, 'qtyminimum' => $qtyminimum, 'qtymaximum' => $qtymaximum ), array( 'id' => $cid ));
foreach( $optionname as $key => $value )
{
update_query('tblproductconfigoptionssub', array( 'optionname' => $value, 'sortorder' => $sortorder[$key], 'hidden' => $hidden[$key] ), array( 'id' => $key ));
}
if( $price )
{
foreach( $price as $curr_id => $temp_values )
{
foreach( $temp_values as $optionid => $values )
{
update_query('tblpricing', array( 'msetupfee' => $values[1], 'qsetupfee' => $values[2], 'ssetupfee' => $values[3], 'asetupfee' => $values[4], 'bsetupfee' => $values[5], 'tsetupfee' => $values[11], 'monthly' => $values[6], 'quarterly' => $values[7], 'semiannually' => $values[8], 'annually' => $values[9], 'biennially' => $values[10], 'triennially' => $values[12] ), array( 'type' => 'configoptions', 'currency' => $curr_id, 'relid' => $optionid ));
}
}
}
if( $addoptionname )
{
insert_query('tblproductconfigoptionssub', array( 'configid' => $cid, 'optionname' => $addoptionname, 'sortorder' => $addsortorder, 'hidden' => $addhidden ));
}
redir("manageoptions=true&cid=" . $cid);
}
if( $deleteconfigoption )
{
check_token("WHMCS.admin.default");
checkPermission("Delete Products/Services");
delete_query('tblproductconfigoptionssub', array( 'id' => $confid ));
redir("manageoptions=true&cid=" . $cid);
}
$aInt->title = "Configurable Options";
$result = select_query('tblproductconfigoptions', '', array( 'id' => $cid ));
$data = mysql_fetch_array($result);
$cid = $data['id'];
$optionname = $data['optionname'];
$optiontype = $data['optiontype'];
$qtyminimum = $data['qtyminimum'];
$qtymaximum = $data['qtymaximum'];
$order = $data['order'];
ob_start();
echo "\n\n\n\n\n";
$content = ob_get_contents();
ob_end_clean();
$aInt->content = $content;
$aInt->displayPopUp();
exit();
}
if( $action == 'savegroup' )
{
check_token("WHMCS.admin.default");
checkPermission("Edit Products/Services");
if( $id )
{
update_query('tblproductconfiggroups', array( 'name' => $name, 'description' => $description ), array( 'id' => $id ));
$response = 'saved';
}
else
{
$id = insert_query('tblproductconfiggroups', array( 'name' => $name, 'description' => $description ));
$response = 'added';
}
delete_query('tblproductconfiglinks', array( 'gid' => $id ));
if( $productlinks )
{
foreach( $productlinks as $pid )
{
insert_query('tblproductconfiglinks', array( 'gid' => $id, 'pid' => $pid ));
}
}
if( $order )
{
foreach( $order as $configid => $sortorder )
{
update_query('tblproductconfigoptions', array( 'order' => $sortorder, 'hidden' => $hidden[$configid] ), array( 'id' => $configid ));
}
}
redir("action=managegroup&id=" . $id);
}
if( $action == 'duplicate' )
{
check_token("WHMCS.admin.default");
checkPermission("Create New Products/Services");
$result = select_query('tblproductconfiggroups', '', array( 'id' => $existinggroupid ));
$data = mysql_fetch_array($result);
$addstr = '';
foreach( $data as $key => $value )
{
if( is_numeric($key) )
{
if( $key == '0' )
{
$value = '';
}
if( $key == '1' )
{
$value = $newgroupname;
}
$addstr .= "'" . db_escape_string($value) . "',";
}
}
$addstr = substr($addstr, 0, 0 - 1);
full_query("INSERT INTO tblproductconfiggroups VALUES (" . $addstr . ")");
$newgroupid = mysql_insert_id();
$result = select_query('tblproductconfigoptions', '', array( 'gid' => $existinggroupid ));
while( $data = mysql_fetch_array($result) )
{
$configid = $data['id'];
$addstr = '';
foreach( $data as $key => $value )
{
if( is_numeric($key) )
{
if( $key == '0' )
{
$value = '';
}
if( $key == '1' )
{
$value = $newgroupid;
}
$addstr .= "'" . db_escape_string($value) . "',";
}
}
$addstr = substr($addstr, 0, 0 - 1);
full_query("INSERT INTO tblproductconfigoptions VALUES (" . $addstr . ")");
$newconfigid = mysql_insert_id();
$result2 = select_query('tblproductconfigoptionssub', '', array( 'configid' => $configid ));
while( $data = mysql_fetch_array($result2) )
{
$optionid = $data['id'];
$addstr = '';
foreach( $data as $key => $value )
{
if( is_numeric($key) )
{
if( $key == '0' )
{
$value = '';
}
if( $key == '1' )
{
$value = $newconfigid;
}
$addstr .= "'" . db_escape_string($value) . "',";
}
}
$addstr = substr($addstr, 0, 0 - 1);
full_query("INSERT INTO tblproductconfigoptionssub VALUES (" . $addstr . ")");
$newoptionid = mysql_insert_id();
$result3 = select_query('tblpricing', '', array( 'type' => 'configoptions', 'relid' => $optionid ));
while( $data = mysql_fetch_array($result3) )
{
$addstr = '';
foreach( $data as $key => $value )
{
if( is_numeric($key) )
{
if( $key == '0' )
{
$value = '';
}
if( $key == '3' )
{
$value = $newoptionid;
}
$addstr .= "'" . db_escape_string($value) . "',";
}
}
$addstr = substr($addstr, 0, 0 - 1);
full_query("INSERT INTO tblpricing VALUES (" . $addstr . ")");
}
}
}
redir("duplicated=true");
}
if( $action == 'deleteoption' )
{
check_token("WHMCS.admin.default");
checkPermission("Edit Products/Services");
delete_query('tblproductconfigoptions', array( 'id' => $opid ));
delete_query('tblproductconfigoptionssub', array( 'configid' => $opid ));
delete_query('tblhostingconfigoptions', array( 'configid' => $opid ));
redir("action=managegroup&id=" . $id);
}
if( $action == 'deletegroup' )
{
check_token("WHMCS.admin.default");
checkPermission("Delete Products/Services");
$result = select_query('tblproductconfigoptions', '', array( 'gid' => $id ));
while( $data = mysql_fetch_array($result) )
{
$opid = $data['id'];
delete_query('tblproductconfigoptions', array( 'id' => $opid ));
delete_query('tblproductconfigoptionssub', array( 'configid' => $opid ));
delete_query('tblhostingconfigoptions', array( 'configid' => $opid ));
}
delete_query('tblproductconfiggroups', array( 'id' => $id ));
delete_query('tblproductconfiglinks', array( 'gid' => $id ));
redir("deleted=true");
}
ob_start();
$jscode = "function doDelete(id) {\nif (confirm(\"Are you sure you want to delete this configurable option group?\")) {\nwindow.location='" . $_SERVER['PHP_SELF'] . "?action=deletegroup&id='+id+'" . generate_token('link') . "';\n}}";
if( $action == '' )
{
if( $deleted )
{
infoBox('Success', "The option group has been deleted successfully!");
}
if( $duplicated )
{
infoBox('Success', "The option group has been duplicated successfully!");
}
echo $infobox;
echo "\nConfigurable options allow you to offer addons and customisation options with your products. Options are assigned to groups and groups can then be applied to products.
\n\nOptions: Create a New Group | Duplicate a Group
\n\n";
$aInt->sortableTableInit('nopagination');
$result = select_query('tblproductconfiggroups', '', '', 'name', 'ASC');
while( $data = mysql_fetch_array($result) )
{
$id = $data['id'];
$name = $data['name'];
$description = $data['description'];
$tabledata[] = array( $name, $description, "![\"Edit\"](\"images/edit.gif\")
", "![\"Delete\"](\"images/delete.gif\")
" );
}
echo $aInt->sortableTable(array( "Group Name", 'Description', '', '' ), $tabledata);
}
else
{
if( $action == 'managegroup' )
{
if( $id )
{
$steptitle = "Manage Group";
$result = select_query('tblproductconfiggroups', '', array( 'id' => $id ));
$data = mysql_fetch_array($result);
$id = $data['id'];
$name = $data['name'];
$description = $data['description'];
$productlinks = array( );
$result = select_query('tblproductconfiglinks', '', array( 'gid' => $id ));
while( $data = mysql_fetch_array($result) )
{
$productlinks[] = $data['pid'];
}
}
else
{
checkPermission("Create New Products/Services");
$steptitle = "Create a New Group";
$id = '';
$productlinks = array( );
}
$jscode = "function manageconfigoptions(id) {\n window.open('" . $_SERVER['PHP_SELF'] . "?manageoptions=true&cid='+id,'configoptions','width=900,height=500,scrollbars=yes');\n}\nfunction addconfigoption() {\n window.open('" . $_SERVER['PHP_SELF'] . "?manageoptions=true&gid=" . $id . "','configoptions','width=800,height=500,scrollbars=yes');\n}\nfunction doDelete(id,opid) {\n if (confirm(\"Are you sure you want to delete this configurable option?\")) {\n window.location='" . $_SERVER['PHP_SELF'] . "?action=deleteoption&id='+id+'&opid='+opid+'" . generate_token('link') . "';\n }\n}";
echo "\n\n\n";
}
else
{
if( $action == 'duplicategroup' )
{
checkPermission("Create New Products/Services");
echo "\nDuplicate Group
\n\n\n\n";
}
}
}
$content = ob_get_contents();
ob_end_clean();
$aInt->content = $content;
$aInt->jquerycode = $jquerycode;
$aInt->jscode = $jscode;
$aInt->display();