'__Delete',
);
protected $Columns= array(
'Headers'=> array(
'cb' => '
'.esc_html__('Name').'
'.esc_html__('Edit.OfficialTitle','mFloorMap').'
'.esc_html__('Column.Published','mFloorMap').'
'.esc_html__('Column.Floor','mFloorMap').'
'.$this->RenderSelect('floor', $this->GetFloorsList(' -'), $this->ItemData['Floor'], 'item_floor').'
'.esc_html__('Column.LocationMark','mFloorMap').'
'.esc_html__('Edit.Logo','mFloorMap').'
'.esc_html__('Edit.ImageReplace','mFloorMap').'
'.esc_html__('Edit.Photo','mFloorMap').'
'.esc_html__('Edit.ImageReplace','mFloorMap').'
'.esc_html__('Edit.Description','mFloorMap').'
'.esc_html__('Edit.ContactInfo','mFloorMap').'
'.esc_html__('Edit.TimingInfo','mFloorMap').'
'.($this->Id === 0 ? '' :'
'.esc_html__('Edit.Tags','mFloorMap').'
'.implode("\n ", $this->RenderTagControls()).'
'.esc_html__('Edit.Mapping','mFloorMap').'
x1
x2
x4
'.esc_html__('Edit.UpdatePoly','mFloorMap').'
').'
';
}
protected function RenderTagControls() {
// find FacId
global $wpdb;
$SQL= "SELECT T2.FacId"
." FROM $this->Table AS T1"
." LEFT JOIN {$wpdb->prefix}mfloormap_floors AS T2 ON T2.Id=T1.FloId"
." WHERE T1.Id=$this->Id";
$Items= $wpdb->get_results($SQL, ARRAY_A);
$FacId= isset($Items[0]) ? intval($Items[0]['FacId']) : 0;
if (!$FacId) {
return array(); // item has not assigned to any facility, therefore it has no tags
}
// find all tags
global $wpdb;
$SQL= "SELECT Id, Title FROM {$wpdb->prefix}mfloormap_tags WHERE FacId=$FacId ORDER BY Ordering";
$AllTags= $wpdb->get_results($SQL, ARRAY_A);
// render
$Controls= array();
foreach($AllTags as $Tag) {
$Chk= in_array($Tag['Id'], $this->ItemData['Tags'], true) ? ' checked="checked"': '';
$CtrlId= 'item_tag'.$Tag['Id'];
$Control= ' '.$Control.' '.esc_html($Tag['Title']).' ';
}
return $Controls;
}
protected function Search($Where, $Order, $PerPage, $Page) {
global $wpdb;
$Offset= ($Page-1)*$PerPage;
$SQL= "SELECT T1.*, T2.Title AS FloorTitle, T3.Title AS FacTitle"
." FROM $this->Table AS T1"
." LEFT JOIN {$wpdb->prefix}mfloormap_floors AS T2 ON T2.Id=T1.FloId"
." LEFT JOIN {$wpdb->prefix}mfloormap_facilities AS T3 ON T3.Id=T2.FacId"
." ".$this->SearchJoins
." $Where ORDER BY $Order LIMIT $Offset,$PerPage";
$Items= $wpdb->get_results($SQL, ARRAY_A);
return $Items;
}
protected function GetSearchOrder() {
$Replace= array(
'T1.Floor'=> 'T2.Title',
);
$OrderBy= parent::GetSearchOrder();
return str_replace(array_keys($Replace), array_values($Replace), $OrderBy);
}
protected function GetSearchWhere() {
global $wpdb;
$Conditions= array();
// filter by floor
$FilterFloor= $this->Input('filter_floor', 'I');
if ($FilterFloor > 0) {
$Conditions[]= 'T1.FloId='.$FilterFloor;
}
// filter by tag
$FilterTag= $this->Input('filter_tag', 'I');
if ($FilterTag > 0) {
$Conditions[]= 'TT.TagId='.$FilterTag;
$this->SearchJoins .= ' LEFT JOIN '.$wpdb->prefix.'mfloormap_placetags AS TT ON TT.PlaceId=T1.Id';
}
// pack all conditions
return empty($Conditions)
? ''
: 'WHERE '.implode(' AND ', $Conditions);
}
/**
* Insert filtering controls next to the bulk actions.
*/
protected function extra_tablenav($which) {
if ($which <> 'top') {return;}
echo '
';
// filter by floor
echo ''.esc_html__('Column.Floor','mFloorMap').' ';
$List= $this->GetFloorsList(__('pl.Filter.AllFloors','mFloorMap'));
$Curr= $this->Input('filter_floor', 'I');
$Control= $this->RenderSelect('filter_floor', $List, $Curr, 'filter_floor');
echo $Control;
// filter by tag
echo ''.esc_html__('Edit.Tags','mFloorMap').' ';
$List= $this->GetTagsList(__('pl.Filter.AllTags','mFloorMap'));
$Curr= $this->Input('filter_tag', 'I');
$Control= $this->RenderSelect('filter_tag', $List, $Curr, 'filter_tag');
echo $Control;
// button
submit_button( __('Filter'), '', 'filter_action', false, array('id'=>'post-query-submit'));
echo '
';
}
/**
* Perform deleting specified item.
* Called by bulk operatations handler.
*/
protected function DeleteItem($Id) {
// find and delete existing images
global $wpdb;
$Results= $wpdb->get_results("SELECT * FROM $this->Table WHERE $this->PrimaryKey=$Id LIMIT 1", ARRAY_A);
$Logo= isset($Results[0]) ? $Results[0]['Logo'] : '';
if ($Logo) {
unlink("$this->UploadsDir/logos/$Logo");
}
$Photo= isset($Results[0]) ? $Results[0]['Photo'] : '';
if ($Photo) {
unlink("$this->UploadsDir/photos/$Photo");
}
// delete tag assignments
$wpdb->delete($wpdb->prefix.'mfloormap_placetags', array('PlaceId'=>$Id));
// call parent
parent::DeleteItem($Id);
}
//------------------------------------------------------------------------
// Column renderers
// -----------------------------------------------------------------------
/**
* Renderer of "facility" cell content.
*/
function column_floor($Item) {
$Title= $Item['FloorTitle'];
if ($Item['FacTitle']) {
$Title .= ' ('.$Item['FacTitle'].')';
}
return ($Title)
? $Title
: ' -';
}
//------------------------------------------------------------------------
// Actions
// -----------------------------------------------------------------------
/**
* Action: modify data.
*/
protected function Action_Update() {
global $wpdb;
// get para
$Id = $this->Input('id', 'I');
$Title = $this->Input('title', 'T');
$OfficialTitle= $this->Input('officialtitle', 'T');
$Published = $this->Input('published', 'I');
$Floor = $this->Input('floor', 'I');
$LocMark = $this->Input('locationmark', 'T');
$Description = $this->Input('description', 'T');
$ContactInfo = $this->Input('contactinfo', 'T');
$TimingInfo = $this->Input('timinginfo', 'T');
$Tags = $this->Input('tags', 'AI');
$Mapping = $this->Input('mapping', 'T');
// storing
$SQL= $Id === 0
? "INSERT INTO $this->Table (Id, Title, OfficialTitle, Published, FloId, LocationMark, Descr, ContactInfo, TimingInfo, Mapping)"
." VALUES(0, '%s', '%s', %d, %d, '%s', '%s', '%s', '%s', '%s')"
: "UPDATE $this->Table SET Title='%s', OfficialTitle='%s', Published=%d, FloId=%d, LocationMark='%s', Descr='%s', ContactInfo='%s', TimingInfo='%s', Mapping='%s'"
." WHERE $this->PrimaryKey=".intval($Id);
$Result= $wpdb->query($wpdb->prepare($SQL, $Title, $OfficialTitle, $Published, $Floor, $LocMark, $Description, $ContactInfo, $TimingInfo, $Mapping));
if (isset($Result['error']) && $Result['error']) {
$this->NotificationError($Result['error']);
}
// update current id after insertion
if ($Id === 0) {
$Id= intval($wpdb->insert_id);
}
// handle uploads
if (empty($this->Notifications['Error'])) {
$this->UploadImage('logo', 'Logo', 'logos', $Id);
$this->UploadImage('photo', 'Photo', 'photos', $Id);
}
// handle tags
$wpdb->delete($wpdb->prefix.'mfloormap_placetags', array('PlaceId'=>$Id));
if (!empty($Tags)) {
$Multi= array();
foreach(array_unique($Tags) as $Tag) {
$Multi[]= "($Id,$Tag)";
}
$SQL= "INSERT INTO {$wpdb->prefix}mfloormap_placetags (PlaceId, TagId) VALUES ".implode(', ',$Multi);
$Result= $wpdb->query($SQL); // all values are safe as integers, no need to "prepare" query
}
// disatch confirmation message
if (empty($this->Notifications['Error'])) {
$this->NotificationConfirmation(esc_html__($this->TDPrefix.'List.ConfirmItem'.($Id===0?'Created':'Updated'), $this->TextDomain));
}
// render form
$this->Id= $Id;
$this->DisplayForm();
}
}
?>