<?php
##############################################################
##In-portal													##
##############################################################
##					      In-portal							## 
##					Intechnic Corporation					##
##			   All Rights Reserved, 1998-2002				##
##															##	
##	No portion of this code may be copied, reproduced or	##	
##	   otherwise redistributed without proper written		##
##	  consent of Intechnic Corporation.  Violation will		##
##	   result in revocation of the license and support		##
##	 privileges along maximum prosecution allowed by law.	##
##############################################################
if( !(isset($pathtoroot) && $pathtoroot) )
{
  $path=dirname(realpath(__FILE__));
  if(strlen($path))
  {
    /* determine the OS type for path parsing */
    $pos = strpos($path,":");
    if ($pos === false)
    {
      $gOS_TYPE="unix";
      $pathchar = "/";
    }
    else
    {
      $gOS_TYPE="win";
      $pathchar="\\";
    }
    $p = $path.$pathchar;
    /*Start looking for the root flag file */
    if( !isset($pathtoroot) ) $pathtoroot = '';
    while(!strlen($pathtoroot) && strlen($p))
    {
      $sub = substr($p,strlen($pathchar)*-1);
      if($sub==$pathchar)
      {
        $filename = $p."root.flg";
      }
      else
        $filename = $p.$pathchar."root.flg";
      if(file_exists($filename))
      {
        $pathtoroot = $p;
      }
      else
      {
        $parent = realpath($p.$pathchar."..".$pathchar);
	if($parent!=$p)
	{
	  $p = $parent;
	}
	else
	  $p = "";
      }
    }
    if( !(isset($pathtoroot) && $pathtoroot) )
      $pathtoroot = ".".$pathchar;
  }
  else
  {
    $pathtoroot = ".".$pathchar;
  }
}

$sub = substr($pathtoroot,strlen($pathchar)*-1);
if($sub!=$pathchar)
{
  $pathtoroot = $pathtoroot.$pathchar;
}
//echo $pathtoroot;


require_once($pathtoroot."kernel/startup.php");
//admin only util
$rootURL="http://".ThisDomain().$objConfig->Get("Site_Path");
$admin = $objConfig->Get("AdminDirectory");
if(!strlen($admin))
    $admin = "admin";
$localURL=$rootURL."kernel/";
$adminURL = $rootURL.$admin;
$imagesURL = $adminURL."/images";

require_once ($pathtoroot.$admin."/include/elements.php"); 
require_once ($pathtoroot."kernel/admin/include/navmenu.php"); 
require_once($pathtoroot.$admin."/toolbar.php");
require_once($pathtoroot.$admin."/listview/listview.php");

unset($objEditItems);

$objEditItems = new clsPhraseList();
$objEditItems->SourceTable = $objSession->GetEditTable("Language");
$objEditItems->EnablePaging = FALSE;
//Multiedit init
$en = (int)$_GET["en"];
$objEditItems->Query_Item("SELECT * FROM ".$objEditItems->SourceTable);
$itemcount=$objEditItems->NumItems();

$c = $objEditItems->GetItemByIndex($en);

$name = $c->Get("PackName");
$LangId = $c->Get("LanguageId");

if($itemcount>1)
{    
	  if ($en+1 == $itemcount)
		$en_next = -1;
	  else
		$en_next = $en+1;
	
	  if ($en == 0)
		$en_prev = -1;
	  else
		$en_prev = $en-1;	
}
$action = "m_phrase_edit";

/* -------------------------------------- Section configuration ------------------------------------------- */
$envar = "env=" . BuildEnv() . "&en=$en";
$section = 'in-portal:lang_email';
$sec = $objSections->GetSection($section);

$SortFieldVar = "LangEmail_LV_SortField";
$SortOrderVar = "LangEmail_LV_SortOrder";
$DefaultSortField = "Description";
$PerPageVar = "Perpage_LangEmail";
$CurrentPageVar = "Page_LangEmail";
$CurrentFilterVar = "LangEmailEvent_View";

$ListForm = "language";
$CheckClass = "EmailChecks";

/* ------------------------------------- Configure the toolbar ------------------------------------------- */
$objListToolBar = new clsToolBar();
$objListToolBar->Add("img_save", "la_Save","#","swap('img_save','toolbar/tool_select_f2.gif');", "swap('img_save', 'toolbar/tool_select.gif');","do_edit_save('language','LangEditStatus','".$admin."/config/config_lang.php',1);",$imagesURL."/toolbar/tool_select.gif");
$objListToolBar->Add("img_cancel", "la_Cancel","#","swap('img_cancel','toolbar/tool_cancel_f2.gif');", "swap('img_cancel', 'toolbar/tool_cancel.gif');","edit_submit('language','LangEditStatus','".$admin."/config/config_lang.php',2);",$imagesURL."/toolbar/tool_cancel.gif");
$objListToolBar->Set("section",$section);
$objListToolBar->Set("load_menu_func","");
$objListToolBar->Set("CheckClass",$CheckClass);
$objListToolBar->Set("CheckForm",$ListForm);

if ( isset($en_prev) || isset($en_next) )
{	
  $objListToolBar->Add("divider");
  if($en_prev>-1)
  {
    $MouseOver="swap('moveleft','toolbar/tool_prev_f2.gif');";
    $MouseOut="swap('moveleft', 'toolbar/tool_prev.gif');";
    $onClick= $sec->Get("onclick");
    $var="?env=".BuildEnv()."&en=$en_prev";
    $link=$_SERVER["PHP_SELF"].$var;
    $objListToolBar->Add("moveleft",admin_language("la_ToolTip_Previous")." ".admin_language("la_Text_Theme"),$link,$MouseOver,$MouseOut,"","tool_prev.gif");
  }
  else
  {
    $MouseOver="";
    $MouseOut="";
    $onClick="";
    $link="#";
    $objListToolBar->Add("moveleft",admin_language("la_ToolTip_Previous")." ".admin_language("la_Text_Theme"),"#","","","","tool_prev_f3.gif");

  }  
  if($en_next>-1)
  {
    $MouseOver="swap('moveright','toolbar/tool_next_f2.gif');";
    $MouseOut="swap('moveright', 'toolbar/tool_next.gif');";
    $onClick=$sec->Get("onclick");
    $var="?env=".BuildEnv()."&en=$en_next";
    $link=$_SERVER["PHP_SELF"].$var;
    $objListToolBar->Add("moveright",admin_language("la_ToolTip_Next")." ".admin_language("la_Text_Theme"),$link,$MouseOver,$MouseOut,"","tool_next.gif");
  }
  else
  {
    $objListToolBar->Add("moveright",admin_language("la_ToolTip_Next")." ".admin_language("la_Text_Theme"),$link,$MouseOver,$MouseOut,"","tool_next_f3.gif");
  }

}
$objListToolBar->Add("divider");

$listImages = array();
                    //$img, $alt, $link, $onMouseOver, $onMouseOut, $onClick
$EditEnv = $envar."&Lang=".$c->Get("LanguageId");

$objListToolBar->Add("email_edit", "la_ToolTip_Edit","#","if (EmailChecks.itemChecked()) swap('email_edit','toolbar/tool_edit_f2.gif');",
                     "if (EmailChecks.itemChecked()) swap('email_edit', 'toolbar/tool_edit.gif');",
                     "if (EmailChecks.itemChecked()) EmailChecks.check_submit('email_edit', '');",
                     "tool_edit.gif",TRUE,TRUE);
$listImages[] = "EmailChecks.addImage('email_edit','$imagesURL/toolbar/tool_edit.gif','$imagesURL/toolbar/tool_edit_f3.gif',1); ";

/*
$objListToolBar->Add("email_user", "la_ToolTip_Email_UserSelect","#","if (EmailChecks.itemChecked()) swap('email_user','toolbar/tool_usertogroup_f2.gif');",
                    "if (EmailChecks.itemChecked()) swap('email_user', 'toolbar/tool_usertogroup.gif');",
                     "OpenUserSelector('$envar&Selector=radio&destform=userpopup&destfield=FromUserId&IdField=PortalUserId',$LangId);",
                     "tool_usertogroup.gif");

$listImages[] = "EmailChecks.addImage('email_user','$imagesURL/toolbar/tool_usertogroup.gif','$imagesURL/toolbar/tool_usertogroup_f3.gif',1); ";
*/
$objListToolBar->Add("divider");

$objListToolBar->Add("viewmenubutton", "la_ToolTip_View","#","swap('viewmenubutton','toolbar/tool_view_f2.gif'); ",
                    "swap('viewmenubutton', 'toolbar/tool_view.gif');",
                     "ShowViewMenu();","tool_view.gif");

$objListToolBar->AddToInitScript($listImages);
$objListToolBar->AddToInitScript("fwLoadMenus();");

/* ----------------------------------------- Set the View Filter ---------------------------------------- */

$ViewNormal=1;
$Bit_Disabled=2;
$Bit_Enabled=1;
$Bit_FrontOnly=4;
$Bit_All = 7;

$FilterLabels = array();

$FilterLabels[0] = admin_language("la_Text_Enabled");
$FilterLabels[1] = admin_language("la_Text_Disabled");
$FilterLabels[2] = admin_language("la_Text_FrontOnly");

/* determine current view menu settings */
$MsgView = $objConfig->Get($CurrentFilterVar);

if(!is_numeric($MsgView))
{   
   $MsgView = $Bit_All; //Set all bits ON
   $MsgFilter = "";
}

if($MsgView & $Bit_Disabled)
  $Status[] = 0;

if($MsgView & $Bit_Enabled)
  $Status[] = 1;
  
 if($MsgView & $Bit_FrontOnly)
  $Status[] = 2;

if(count($Status)>0)
{  
  $MsgFilter = "Enabled IN (".implode(",",$Status).")";
}
else
    $MsgFilter = "Enabled = -1";

/* ------------------------------------ Build the SQL statement to populate the list ---------------------------*/
    
$objEvents = new clsEventList();
$order = trim($objConfig->Get($SortFieldVar)." ".$objConfig->Get($SortOrderVar));

$SearchWords = $objSession->GetVariable("LangEmailEventSearchWord");
if(strlen($SearchWords))
{
	// remove u.Login from search fields in this case
	$i = 0; $field_count = count($objEvents->AdminSearchFields);
	while($i < $field_count)
	{
		if( $objEvents->AdminSearchFields[$i] == 'u.Login' )
		{
			array_splice($objEvents->AdminSearchFields,$i);
			break;
		}
		$i++;
	}
	$where = $objEvents->AdminSearchWhereClause($SearchWords);
}
else
{
	$where = "";
}
$UserTable = GetTablePrefix()."PortalUser";
$EventTable = GetTablePrefix()."Events";
$MessageTable = GetTablePrefix()."EmailMessage";

$sql = "SELECT e.Description as Description, e.Module as Module,  e.EventId as EventId, ";
$sql .="ELT(e.Enabled+1,'".admin_language("la_Text_Disabled")." ','".admin_language("la_Text_Enabled")." ', '".admin_language("la_Text_FrontOnly")." ') as EventStatus, ";
$sql .="ELT(e.Type+1,'".admin_language("la_Text_User")." ','".admin_language("la_Text_Admin")." ') as EventType, ";
$sql .="u.Login as FromUser FROM $EventTable as e LEFT JOIN $UserTable as u ON (e.FromUserId=u.PortalUserId) ";

$FullWhere = "";
if(strlen($where))
{
    $FullWhere = "WHERE $where ";
}
if(strlen($MsgFilter))
{
  if(!strlen($FullWhere))
  {
      $FullWhere = "WHERE $MsgFilter ";
  }
  else
      $FullWhere .= " AND ($MsgFilter) ";
}
$sql .= $FullWhere;

if(strlen($objConfig->Get($SortFieldVar)))
    $sql .= "ORDER BY ".$order." ";

if(isset($_GET["lpn"]))
    $objSession->SetVariable($CurrentPageVar,$_GET["lpn"]);

$sql .= GetLimitSQL($objSession->GetVariable($CurrentPageVar),$objConfig->Get($PerPageVar));
//echo $sql;
$objEvents->Query_Item($sql);
$itemcount = TableCount($objEvents->SourceTable, $where,0);

if($objSession->HasSystemPermission("DEBUG.LIST"))
   echo htmlentities($sql,ENT_NOQUOTES)."<br>\n";

   
/* ---------------------------------------- Configure the list view ---------------------------------------- */   
$objListView = new clsListView($objListToolBar,$objEvents);
$objListView->IdField = "EventId";

$order = $objConfig->Get("LangEmail_LV_SortField");

$objListView->ColumnHeaders->Add("Description",admin_language("la_prompt_Description"),1,0,$order,"width=\"50%\"","LangEmail_LV_SortField","LangEmail_LV_SortOrder","Description");
$objListView->ColumnHeaders->Add("Module",admin_language("la_prompt_Module"),1,0,$order,"width=\"15%\"","LangEmail_LV_SortField","LangEmail_LV_SortOrder","Module");
$objListView->ColumnHeaders->Add("EventType",admin_language("la_prompt_Type"),1,0,$order,"width=\"10%\"","LangEmail_LV_SortField","LangEmail_LV_SortOrder","EventType");
$objListView->ColumnHeaders->Add("EventStatus",admin_language("la_prompt_Status"),1,0,$order,"width=\"10%\"","LangEmail_LV_SortField","LangEmail_LV_SortOrder","EventStatus");
//$objListView->ColumnHeaders->Add("FromUser",admin_language("la_prompt_FromUser"),1,0,$order,"width=\"15%\"","Email_LV_SortField","Email_LV_SortOrder","FromUser");

$objListView->ColumnHeaders->SetSort($objConfig->Get($SortFieldVar), $objConfig->Get($SortOrderVar));

$objListView->PrintToolBar = FALSE;
$objListView->checkboxes = TRUE;

$objListView->CurrentPageVar = $CurrentPageVar;
$objListView->PerPageVar = $PerPageVar;
$objListView->CheckboxName = "itemlist[]"; 
$objListView->SearchBar = TRUE;
$objListView->SearchKeywords = $SearchWords;
$objListView->SearchAction="m_langemailevent_search";

$objListView->TotalItemCount = $itemcount;

  $objListView->ConfigureViewMenu($SortFieldVar,$SortOrderVar,$DefaultSortField,
  								  $CurrentFilterVar,$MsgView,$Bit_All);

  foreach($FilterLabels as $Bit=>$Label)
  {
  	$objListView->AddViewMenuFilter($Label,$Bit);
  }	
  
for($i=0;$i<count($objEvents->Items);$i++)
{     
  $e =& $objEvents->GetItemRefByIndex($i);
  $e->Set("Description",prompt_language($e->Get("Description")));
}


$filter = false; // always initialize variables before use
if($objSession->GetVariable("LangEmailEventSearchWord") != '') {
	$filter = true;
} 
else {
	if ($MsgView != $Bit_All) {
		$filter = true;
	}
}


$title = $title = GetTitle("la_Text_Pack", "la_tab_EmailEvents", $c->Get('LanguageId'), $c->Get('LocalName'));///prompt_language("la_Text_Configuration")." - '".$name."' ".prompt_language("la_Text_Pack")." - ".prompt_language("la_tab_EmailEvents");

$h = "\n\n<SCRIPT Language=\"JavaScript1.2\">\n".$objListView->GetViewMenu($imagesURL)."\n</SCRIPT>\n";
define('FORCE_CHARSET', $c->Get("Charset") );
int_header($objListToolBar,NULL, $title,NULL,$h);

if ($objSession->GetVariable("HasChanges") == 1) {
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
  <tr>
    <td valign="top">
      <?php int_hint_red(admin_language("la_Warning_Save_Item")); ?>
    </td>
  </tr>
</table>
<?php } ?> 
<?php if ($filter) { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="toolbar">
  <tr>
    <td valign="top">
      <?php int_hint_red(admin_language("la_Warning_Filter")); ?>
    </td>
  </tr>
</table>
<?php } ?> 
<form name="language" ID="language" action="<?php echo $_SERVER["PHP_SELF"]."?".$envar;?>" method=POST>
<table cellSpacing="0" cellPadding="2" width="100%" class="tableborder">
<tbody>
<?php
  print $objListView->PrintList();  
?>
    <input type="hidden" NAME="section" VALUE="<?php echo $section; ?>">
    <input type="hidden" name="Action" value="m_email_edit">
    <input type="hidden" name="LangEditStatus" VALUE="0">
</FORM>
<FORM>
<TR <?php int_table_color(); ?> >
    <td colspan="3">
 </td>
</tr>
</FORM>
</TABLE>

<!-- CODE FOR VIEW MENU -->
<form ID="viewmenu" method="post" action="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>" name="viewmenu">
<input type="hidden" name="fieldname" value="">
<input type="hidden" name="varvalue" value="">
<input type="hidden" name="varvalue2" value="">
<input type="hidden" name="Action" value="">
</form>
<FORM ID="ListSearchForm" NAME="ListSearchForm" method="POST" action="<?php echo $_SERVER["PHP_SELF"]."?env=".BuildEnv(); ?>">
   <INPUT TYPE="HIDDEN" NAME="Action" VALUE="">
   <INPUT TYPE="HIDDEN" NAME="list_search">
</FORM>

<FORM NAME="popup" METHOD="POST" ACTION="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>" ID="popup">
<INPUT TYPE="HIDDEN" NAME="MessageId" value="">
<INPUT TYPE="HIDDEN" NAME="LanguageId" value="">
<INPUT TYPE="HIDDEN" NAME="Enabled" value="">
<INPUT TYPE="HIDDEN" NAME="Template" value="">
<INPUT TYPE="HIDDEN" NAME="MessageType" value="">
<INPUT TYPE="HIDDEN" NAME="Subscribed" value="">
<INPUT TYPE="HIDDEN" NAME="Action" VALUE="m_emailevent_edit">
</FORM>

<FORM NAME="userpopup" METHOD="POST" ACTION="<?php echo $_SERVER["PHP_SELF"]."?".$envar; ?>" ID="userpopup">
<INPUT TYPE="HIDDEN" NAME="MessageId" value="">
<INPUT TYPE="HIDDEN" NAME="LanguageId" value="<?php echo $c->Get("LanguageId"); ?>">
<INPUT TYPE="HIDDEN" NAME="FromUserId" value="">
<INPUT TYPE="HIDDEN" NAME="Action" VALUE="m_emailevent_user">
</FORM>

<script src="<?php echo $adminURL; ?>/listview/listview.js"></script>
<script>
initSelectiorContainers();
<?php echo $objListToolBar->Get("CheckClass").".setImages();"; ?>
</script>
<?php int_footer(); ?>