2. PHPRunner General questions
  3. [SOLVED]  Hiding Columns on List Page
This topic is locked
[SOLVED]

 Hiding Columns on List Page

 		10/12/2013 10:26:34 AM
PHPRunner General questions
C
 CWDATA author

Hi People....
I have read various solutions to this requirement in the forum but I just cant get any to work.
I have a Table called "tblworklistV2". I want to simply hide several of the columns in this table when displayed on a list page.
I have placed the following code in the "Before display" event.
if($_REQUEST["masterkey1"])

{

$sql="SELECT * from tblworklistV2 where ID = ".$_REQUEST["masterkey1"];

$rs = CustomQuery($sql);

$data = db_fetch_array($rs);
$xt->assign("Date_fieldheadercolumn",$data["FieldDate"] != '');

$xt->assign("Date_fieldcolumn",$data["FieldDate"] != '');
$xt->assign("ClientResponsibility_fieldheadercolumn",$data["FieldClientResponsibility"] != '');

$xt->assign("ClientResponsibility_ClientResponsibility",$data["FieldClientResponsibility"] != '');
$xt->assign("DueDate_fieldheadercolumn",$data["FieldDueDate"] != '');

$xt->assign("DueDate_fieldcolumn",$data["FieldDueDate"] != '');
$xt->assign("Catagory_fieldheadercolumn",$data["FieldCatagory"] != '');

$xt->assign("Catagory_fieldcolumn",$data["FieldCatagory"] != '');
$xt->assign("SupplierContactName_fieldheadercolumn",$data["FieldSupplierContactName"] != '');

$xt->assign("SupplierContactName_fieldcolumn",$data["FieldSupplierContactName"] != '');
$xt->assign("Site_fieldheadercolumn",$data["FieldSite"] != '');

$xt->assign("Site_fieldcolumn",$data["FieldSite"] != '');
$xt->assign("Broker_fieldheadercolumn",$data["FieldBroker"] != '');

$xt->assign("Broker_fieldcolumn",$data["FieldBroker"] != '');
$xt->assign("Task_fieldheadercolumn",$data["FieldTask"] != '');

$xt->assign("Task_fieldcolumn",$data["FieldTask"] != '');
$xt->assign("Completed_fieldheadercolumn",$data["FieldCompleted"] != '');

$xt->assign("Completed_fieldcolumn",$data["FieldCompleted"] != '');
}
The list page loads but still shows all the above columns.
Please can anyone advise?
Regards,

Carl.
C
 		cgphp 10/12/2013

A date field when is empty is populated with 0000-00-00 00:00:00 or something like 1970-01-01 00:00:00, so your condition check is always true.
C
 		CWDATA author 10/12/2013



A date field when is empty is populated with 0000-00-00 00:00:00 or something like 1970-01-01 00:00:00, so your condition check is always true.


Thanks very much for your very prompt reply.

Is there a way of auctioning my requirement ignoring the individual field content?
Cheers,

carl.
C
 		cgphp 10/12/2013

Check what is the default value for the date field and in your condition evaluate the expression against that value.
C
 		CWDATA author 10/12/2013



Check what is the default value for the date field and in your condition evaluate the expression against that value.



Thanks mate.

Would that apply to all columns?

i.e all defaults are NULL
so would I write code as follows for each of the columns?

$xt->assign("Date_fieldheadercolumn",$data["FieldDate"] != NULL);

$xt->assign("Date_fieldcolumn",$data["FieldDate"] != NULL);
Many thanks,
Carl.