<?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.	##
##############################################################

// new startup: begin
define('REL_PATH', 'in-bulletin/admin');
$relation_level = count( explode('/', REL_PATH) );
define('FULL_PATH', realpath(dirname(__FILE__) . str_repeat('/..', $relation_level) ) );
require_once FULL_PATH.'/kernel/startup.php';
// new startup: end

$pathtolocal = $pathtoroot."in-bulletin/";
require_once ($pathtoroot.$admin."/include/elements.php"); 
require_once ($pathtoroot."kernel/admin/include/navmenu.php"); 
require_once ($pathtolocal."admin/include/navmenu.php"); 
require_once($pathtoroot.$admin."/toolbar.php");
require_once($pathtoroot.$admin."/listview/listview.php");

 

unset($objEditItems);
$objEditItems = new clsTopicList();
$objEditItems->SourceTable = $objSession->GetEditTable("Topic");
$objEditItems->EnablePaging = FALSE;

$objReviewList = new clsItemReviewList();
$objReviewList->SourceTable = $objSession->GetEditTable("ItemReview");

$en = (int)GetVar('en');
$objEditItems->Query_Item("SELECT * FROM ".$objEditItems->SourceTable);
$itemcount=$objEditItems->NumItems();
$c = $objEditItems->GetItemByIndex($en);
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;	
}

//Set Section
$section = 'in-bulletin:edittopic_reviews'; 
$saveURL = $admin."/".$objSession->GetVariable('ReturnScript');
//Set Environment Variable
$envar = "env=" . BuildEnv() . "&en=$en"; 

$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('topic','".$saveURL."',1);","tool_select.gif");
$objListToolBar->Add("img_cancel", "la_Cancel","#","swap('img_cancel','toolbar/tool_cancel_f2.gif');", "swap('img_cancel', 'toolbar/tool_cancel.gif');","do_edit_save('topic','".$saveURL."',2);","tool_cancel.gif");
if($itemcount == 1) $objListToolBar->Add("divider");

$objListToolBar->Set("section",$section);
$objListToolBar->Set("load_menu_func","");
$objListToolBar->Set("CheckClass","RevChecks");
$objListToolBar->Set("CheckForm","topic");

//Display header
$sec = $objSections->GetSection($section);

if ( isset($en_prev) || isset($en_next) )
{
  $url = $RootUrl."in-bulletin/admin/addtopic_reviews.php"; 
  $StatusField = "TopicEditStatus";
  $form = "topic";
  MultiEditButtons($objListToolBar,$en_next,$en_prev,$form,$StatusField,$url,$sec->Get("OnClick"));  
  $objListToolBar->Add("divider");
}

$listImages = array();
                    //$img, $alt, $link, $onMouseOver, $onMouseOut, $onClick

$objListToolBar->Add("new_review", "la_ToolTip_New_Review",$rootURL."in-bulletin/admin/addreview.php?".$envar,"swap('new_review','toolbar/tool_new_review_f2.gif');",
                    "swap('new_review', 'toolbar/tool_new_review.gif');",
                     "","tool_new_review.gif");

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

$objListToolBar->Add("review_del","la_ToolTip_Delete","#", "if (RevChecks.itemChecked()) swap('review_del','toolbar/tool_delete_f2.gif');",
                    "if (RevChecks.itemChecked()) swap('review_del', 'toolbar/tool_delete.gif');","if (RevChecks.itemChecked()) RevChecks.check_submit('addtopic_reviews', 'm_review_delete');",
                    "tool_delete.gif");
$listImages[] = "RevChecks.addImage('review_del','$imagesURL/toolbar/tool_delete.gif','$imagesURL/toolbar/tool_delete_f3.gif',1); ";

$objListToolBar->Add("divider");

$objListToolBar->Add("rev_move_up","la_ToolTip_Move_Up","#", "if (RevChecks.itemChecked()) swap('rev_move_up','toolbar/tool_move_up_f2.gif');",
                    "if (RevChecks.itemChecked()) swap('rev_move_up', 'toolbar/tool_move_up.gif');","if (RevChecks.itemChecked()) RevChecks.check_submit('addtopic_reviews', 'm_review_move_up');",
                    "tool_move_up.gif");
$listImages[] = "RevChecks.addImage('rev_move_up','$imagesURL/toolbar/tool_move_up.gif','$imagesURL/toolbar/tool_move_up_f3.gif',1); ";

$objListToolBar->Add("rev_move_down","la_ToolTip_Move_Down","#", "if (RevChecks.itemChecked()) swap('rev_move_down','toolbar/tool_move_down_f2.gif');",
                    "if (RevChecks.itemChecked()) swap('rev_move_down', 'toolbar/tool_move_down.gif');","if (RevChecks.itemChecked()) RevChecks.check_submit('addtopic_reviews', 'm_review_move_down');",
                    "tool_move_down.gif");
$listImages[] = "RevChecks.addImage('rev_move_down','$imagesURL/toolbar/tool_move_down.gif','$imagesURL/toolbar/tool_move_down_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(); \n");

// For filter warning
$Bit_Pending=4;
$Bit_Disabled=2;
$Bit_Valid=1;
$Bit_All = 7;

/* determine current view menu settings */
$UserView = $objConfig->Get("TopicRev_View");

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

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

$title = prompt_language("la_Text_Editing")." ".prompt_language("la_Text_Topic")." '".$c->Get("TopicText")."' - ".prompt_language("la_tab_Reviews");

int_header($objListToolBar,NULL, $title);
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 } ?>
<table width="100%" border="0" cellspacing="0" cellpadding="4" class="tableborder">
<form ID ="topic" name="topic" action="" method=POST>	
<?php

$objReviewList->itemID=$c->Get("ResourceId");

$pre = GetTablePrefix();
$time = is12HourMode() ? '%r' : '%T';

$sql = "SELECT r.ReviewText as ReviewText, r.CreatedOn as CreatedOn,";
$sql .=" ELT(r.Status+1,'".admin_language("la_Text_Disabled")."','".admin_language("la_Text_Enabled")."','";
$sql .= admin_language("la_Text_Pending")."') as ReviewStatus, r.Priority as Priority, r.ReviewId as ReviewId, ";
$sql .= "FROM_UNIXTIME(r.CreatedOn,'%m-%d-%Y $time') as DatePosted, pu.Login as Reviewer, r.Status FROM ".$objReviewList->SourceTable." as r ";
$sql .= "LEFT JOIN ".$pre."PortalUser as pu ON (pu.PortalUserId = r.CreatedById) ";
$sql .= "WHERE r.ItemId=".$c->Get("ResourceId");

if(strlen($RevFilter))
{
    $sql .= " AND (".$RevFilter.")";
}

$SearchWords = $objSession->GetVariable("TopicRevSearchWord");

if(strlen($SearchWords))
{
    $where = $objReviewList->AdminSearchWhereClause($SearchWords);
}
else
  $where = "";

if(strlen($where))
    $sql .= " AND ($where) ";

if(strlen(trim($objConfig->Get("TopicReview_LV_Sortfield"))))
{
    $order = " ORDER BY Priority DESC, ".$objConfig->Get("TopicReview_LV_Sortfield")." ".$objConfig->Get("TopicReview_LV_Sortorder");
}
else
{
  $order = " ORDER BY Priority DESC, CreatedOn DESC";
}

$total_records = QueryCount('SELECT * FROM '.$objReviewList->SourceTable.' WHERE ItemId='.$c->Get('ResourceId') );
$objReviewList->RefreshPage('Page_Reviews', $total_records);

$sql .= $order." ".$objReviewList->GetLimitSQL();

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

$objListView = new clsListView($objListToolBar);
$objListView->CurrentPageVar = "Page_Reviews";
$objListView->PerPageVar = "Perpage_Reviews";

$objReviewList->Query_Item($sql); // , $objListView->GetLimitSQL() 

$SortOrder = $objConfig->Get("TopicReview_LV_Sortorder");
if(!strlen($SortOrder))
    $SortOrder = "desc";

$SortField = $objConfig->Get("TopicReview_LV_Sortfield");
if(!strlen($SortField))
    $SortField = "CreatedOn";

for($i=0;$i<count($objReviewList->Items);$i++)
{
  $rt = $objReviewList->Items[$i]->Get("ReviewText");
//  $rt = stripslashes($rt);
  if(strlen($rt)>100)
  {
      $rt = substr($rt,0,100);
      $rt .= " ...";          
  }
  $objReviewList->Items[$i]->Set("ReviewText",$rt);
  
  /* Do review Icons */
  $img = &$objReviewList->GetItemRefByIndex($i);  
  if(is_numeric($img->Get('Status')))
  {
  	$img_map=Array(0=>'icon16_review_disabled.gif',1=>'icon16_review.gif',2=>'icon16_review_pending.gif');
  	$img->Set('Icon',$rootURL.'admin/images/itemicons/'.$img_map[ $img->Get('Status') ]);
  }
  
}

$objListView->SetListItems(&$objReviewList);
$objListView->IdField = "ReviewId";
$objListView->PageLinkTemplate = $pathtoroot.$admin."/templates/user_page_link.tpl";

/* Initialize the Icons */
for($i=0;$i<count($objReviewList->Items);$i++)
{
    $img = &$objReviewList->GetItemRefByIndex($i);
    $objListView->RowIcons[] = $img->Get("Icon");
}  

$objListView->ColumnHeaders->Add("ReviewText",admin_language("la_prompt_ReviewText"),1,0,$order,"width=\"50%\"","TopicReview_LV_Sortfield","TopicReview_LV_Sortorder","ReviewText");
$objListView->ColumnHeaders->Add("Reviewer",admin_language("la_Prompt_ReviewedBy"),1,0,$order,"width=\"20%\"","TopicReview_LV_Sortfield","TopicReview_LV_Sortorder","Reviewer");
$objListView->ColumnHeaders->Add("DatePosted",admin_language("la_prompt_CreatedOn"),1,0,$order,"width=\"20%\"","TopicReview_LV_Sortfield","TopicReview_LV_Sortorder","CreatedOn");
$objListView->ColumnHeaders->Add("ReviewStatus",admin_language("la_prompt_Status"),1,0,$order,"width=\"10%\"","TopicReview_LV_Sortfield","TopicReview_LV_Sortorder","ReviewStatus");
$objListView->ColumnHeaders->SetSort($objConfig->Get("TopicReview_LV_Sortfield"), $objConfig->Get("TopicReview_LV_Sortorder"));

$objListView->PrintToolBar = FALSE;
$objListView->SearchBar = TRUE;
$objListView->SearchKeywords = $SearchWords;
$objListView->SearchAction="l_review_search";
$objListView->CheckboxName = "itemlist[]";
$objListView->TotalItemCount = $total_records;
$objListView->extra_env='en='.(int)GetVar('en');

  print $objListView->PrintList();

?>	 			
		<input type = "hidden" name="ResourceId" value="<?php echo $c->get("ResourceId"); ?>">
		<input type = "hidden" name="Action" value="update_reviews">
        <input type="hidden" name="TopicEditStatus" VALUE="0">

		</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">
   <input type="hidden" name="en" value="<?php echo GetVar('en'); ?>">
</FORM>

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