Beispiel #1
0
    static function wikiView($args)
    {
        global $tikilib, $headerlib;
        static $Feed_ForwardLink_PageLookup = 0;
        ++$Feed_ForwardLink_PageLookup;
        $wikiAttributes = Tracker_Query::tracker('Wiki Attributes')->byName()->excludeDetails()->filter(array('field' => 'Type', 'value' => 'ForwardLink'))->filter(array('field' => 'Page', 'value' => $args['object']))->render(false)->query();
        $forwardLinks = array();
        foreach ($wikiAttributes as $wikiAttribute) {
            $forwardLinks[] = $forwardLink = json_decode($wikiAttribute['Value']);
            $forwardLink->href = urldecode($forwardLink->href);
            if (isset($forwardLink->href)) {
                $result = Feed_ForwardLink_Send::send(array('page' => $args['object'], 'forwardLink' => $forwardLink, 'textlink' => array('body' => $args['data'], 'href' => $tikilib->tikiUrl() . 'tiki-index.php?page=' . $args['object'])));
            }
        }
        $forwardLinks = json_encode($forwardLinks);
        if (!empty($forwardLinks)) {
            $headerlib->add_jq_onready(<<<JQ
\t\t\tvar forwardLinks = {$forwardLinks};
\t\t\t\$.each(forwardLinks, function() {
\t\t\t\tif (this.href) {
\t\t\t\t\t\$('<a>*</a>')
\t\t\t\t\t\t.attr('href', unescape(this.href))
\t\t\t\t\t\t.appendTo('#page-data');
\t\t\t\t}
\t\t\t});
JQ
);
        }
    }
Beispiel #2
0
 static function findWikiRevision($phrase)
 {
     global $tikilib;
     $phrase = JisonParser_Phraser_Handler::superSanitize($phrase);
     // This query will *ALWAYS* fail if the destination page had been created/edited *PRIOR* to applying the 'Simple Wiki Attributes' profile!
     // Just recreate the destination page after having applied the profile in order to load it with the proper attributes.
     $query = Tracker_Query::tracker('Wiki Attributes')->byName()->filterFieldByValueLike('Value', $phrase)->render(false)->getLast();
     // TODO: consider adding a test on query failure in order to determine whether:
     //       1) the phrase isn't found, or
     //       2) the Simple Wiki Attributes profile wasn't in place at page-creation
     // ...then display a more meaningful error message
     if (empty($query)) {
         return false;
     }
     //couldn't find it
     $query = end($query);
     //query has a key of itemId, we just need it's details
     $version = $query['Attribute'];
     $page = $query['Page'];
     $data = $query['Value'];
     $date = $tikilib->getOne('SELECT lastModif FROM tiki_pages WHERE pageName = ? AND version = ?', array($page, $version));
     if (empty($date) == true) {
         $date = $tikilib->getOne('SELECT lastModif FROM tiki_history WHERE pageName = ? AND version = ?', array($page, $version));
     }
     return array('page' => $page, 'version' => $version, 'data' => $data, 'date' => $date, 'phrase' => $phrase);
 }
Beispiel #3
0
 static function wikiSave()
 {
     global $page;
     //We add these to a stack that needs to be sent, rather than just sending all with the view event
     $me = new self();
     foreach ($me->getItems() as $item) {
         Tracker_Query::tracker('Wiki Attributes')->byName()->replaceItem(array('Page' => $page, 'Attribute' => $item->textlink->text, 'Value' => 'true', 'Type' => 'TextLink Send'));
     }
 }
Beispiel #4
0
 static function wikiView($args)
 {
     return;
     global $tikilib, $headerlib;
     static $Feed_ForwardLink_PageLookup = 0;
     ++$Feed_ForwardLink_PageLookup;
     $wikiAttributes = Tracker_Query::tracker('Wiki Attributes')->byName()->excludeDetails()->filter(array('field' => 'Type', 'value' => 'ForwardLink'))->filter(array('field' => 'Page', 'value' => $args['object']))->render(false)->query();
     $forwardLinks = array();
     foreach ($wikiAttributes as $wikiAttribute) {
         $forwardLinks[] = $forwardLink = json_decode($wikiAttribute['Value']);
         if (isset($forwardLink->href)) {
             $forwardLink->href = urldecode($forwardLink->href);
             $result = Feed_ForwardLink_Send::send(array('forwardLink' => $forwardLink, 'textlink' => array('body' => $args['data'], 'href' => $tikilib->tikiUrl() . 'tiki-index.php?page=' . $args['object'])));
         }
     }
 }
Beispiel #5
0
 private function query($values = array())
 {
     $tracker = $values['tracker'];
     $qry = Tracker_Query::tracker($tracker['value'])->start($tracker['start']['value'])->end($tracker['end']['value'])->itemId($tracker['itemId']['value'])->excludeDetails();
     if (!empty($tracker['status'])) {
         $allStatus = '';
         foreach ($tracker['status'] as $status) {
             if (!empty($status['value'])) {
                 $allStatus .= $status['value'];
             }
         }
         $qry->status($allStatus);
     }
     if (!empty($tracker['search'])) {
         for ($i = 0, $count_tracker_search = count($tracker['search']); $i < $count_tracker_search; $i++) {
             if (!empty($tracker['search'][$i]['value']) && !empty($tracker['search'][$i + 1]['value'])) {
                 $qry->filter(array("field" => trim($tracker['search'][$i]['value']), "value" => trim($tracker['search'][$i + 1]['value'])));
             }
             $i++;
             //searches are in groups of 2
         }
     }
     if (!empty($tracker['limit']['value'])) {
         $qry->limit($tracker['limit']['value']);
     }
     $result = $qry->query();
     if (!empty($tracker['fields'])) {
         $newResult = array();
         foreach ($result as $itemKey => $item) {
             $newResult[$itemKey] = array();
             foreach ($tracker['fields'] as $field) {
                 $newResult[$itemKey][$field['value']] = $result[$itemKey][$field['value']];
             }
         }
         $result = $newResult;
         unset($newResult);
     }
     foreach ($tracker['join'] as $join) {
         $result = $this->innerJoin($result, $this->query($join), $join['left']['value'], $join['right']['value']);
     }
     return $result;
 }
Beispiel #6
0
        $trklib->remove_tracker_item($itemId);
    }
    //end delete
    header('Location: tiki-view_invoice.php?InvoiceId=' . $_REQUEST['InvoiceId']);
    die;
}
$invoiceItems = array();
if (!empty($_REQUEST['InvoiceId'])) {
    $invoice = Tracker_Query::tracker("Invoices")->byName()->equals($_REQUEST['InvoiceId'])->getOne();
    $invoice['Item Ids'] = implode(',', $invoice['Item Ids']);
    $smarty->assign("invoice", $invoice);
    $invoiceItems = Tracker_Query::tracker("Invoice Items")->byName()->fields(array("Invoice Id"))->search(array($_REQUEST['InvoiceId']))->query();
} else {
    $_REQUEST['InvoiceId'] = 0;
}
//give the user the last invoice number
$LastInvoice = Tracker_Query::tracker("Invoices")->byName()->limit(0)->offset(1)->desc(true)->excludeDetails()->getOne();
$NewInvoiceNumber = isset($LastInvoice["Invoice Number"]) ? $LastInvoice["Invoice Number"] + 1 : 1;
$smarty->assign("NewInvoiceNumber", $NewInvoiceNumber);
$smarty->assign("InvoiceId", $_REQUEST['InvoiceId']);
$smarty->assign("clients", Tracker_Query::tracker("Invoice Clients")->byName()->query());
$smarty->assign("setting", Tracker_Query::tracker("Invoice Settings")->byName()->getOne());
//we add an extra item to the end of invoiceItems, so we can duplicate it on the page
if (count($invoiceItems) < 1) {
    $invoiceItems[] = array("Quantity" => "", "Work Description" => "", "Taxable" => "", "Amount" => "");
}
$smarty->assign("invoiceItems", $invoiceItems);
$headerlib->add_jq_onready("function setupTotal() {\n\t\t\$('#InvoiceForm :input')\n\t\t\t.unbind('change')\n\t\t\t.change(function() {\n\t\t\t\tfindTotal();\n\t\t\t})\n\t\t\t.change();\n\t}\n\n\tfunction findTotal() {\n\t\tvar total = 0;\n\t\t\$('.InvoiceItem').each(function() {\n\t\t\tvar itemTotal = \$(this).find('.InvoiceQuantity').val() * \$(this).find('.InvoiceAmount').val();\n\t\t\ttotal += itemTotal;\n\t\t});\n\t\t\$('#Amount').text(total);\n\t}\n\n\tsetupTotal();\n\n\t\$('#InvoiceNewItem').click(function() {\n\t\tvar lastInvoiceItem = \$('.InvoiceItem:last');\n\t\tvar newInvoiceItem = lastInvoiceItem.clone();\n\n\t\tnewInvoiceItem.find(':input').not(':checkbox,:button').val('');\n\n\t\tnewInvoiceItem.insertAfter(lastInvoiceItem);\n\n\t\tsetupTotal();\n\t});\n\n\t\$('#InvoiceForm').click(function(e) {\n\t\tif (\$(e.target).hasClass('DeleteItem')) {\n\t\t\tif (\$('.InvoiceItem').length > 1) {\n\t\t\t\t\$(e.target).parent().parent().remove();\n\t\t\t}\n\t\t\treturn false;\n\t\t}\n\t});\n\n\t\$('#InvoiceForm').submit(function() {\n\t\t\$('.InvoiceTaxable').each(function() {\n\t\t\tvar InvoiceTaxable = \$(this);\n\t\t\tif (!InvoiceTaxable.is(':checked')) {\n\t\t\t\tInvoiceTaxable\n\t\t\t\t\t.val('n')\n\t\t\t\t\t.prop('checked', 'true');\n\t\t\t}\n\t\t});\n\n\t\t\$('.InvoiceItemId').each(function() {\n\t\t\tvar InvoiceItemId = \$(this);\n\t\t\tInvoiceItemId.val(InvoiceItemId.val() ? InvoiceItemId.val() : '0');\n\t\t});\n\n\t\tvar InvoiceId = \$('#InvoiceId');\n\t\tInvoiceId.val(InvoiceId.val() ? InvoiceId.val() : 0);\n\n\t\treturn false;\n\t});");
// Display the template
$smarty->assign('mid', 'tiki-edit_invoice.tpl');
$smarty->display("tiki.tpl");
Beispiel #7
0
require_once 'tiki-setup.php';
$access->check_feature(array('feature_time_sheet', 'feature_trackers'));
$access->check_permission_either(array('tiki_p_view_trackers', 'tiki_p_create_tracker_items'));
global $user, $prefs, $tiki_p_admin;
$auto_query_args = array('all', 'profile', 'page', 'list');
$trackerId = (int) TikiLib::lib('trk')->get_tracker_by_name('Time sheet');
$smarty->assign("tiki_p_admin", $tiki_p_admin);
$smarty->assign("timeSheetProfileLoaded", $trackerId > 0 ? true : false);
$projectList = Tracker_Query::tracker("Project list")->byName()->query();
if (isset($_REQUEST['all'])) {
    //all views all sheet items
    $smarty->assign("all", true);
    $timeSheet = Tracker_Query::tracker("Time sheet")->byName()->query();
} else {
    //views only your items
    $smarty->assign("all", false);
    $timeSheet = Tracker_Query::tracker("Time sheet")->byName()->filter(array("field" => "Done by", "value" => $user))->query();
}
if (isset($projectList)) {
    if (isset($_REQUEST['save'])) {
        echo json_encode($timeSheetNewInputs = Tracker_Query::tracker("Time sheet")->byName()->queryInput());
        die;
    }
    $smarty->assign("projectList", $projectList);
    $smarty->assign("timeSheet", $timeSheet);
}
TikiLib::lib("sheet")->setup_jquery_sheet();
$headerlib = TikiLib::lib("header")->add_cssfile("vendor/jquery/jtrack/css/jtrack.css")->add_jsfile("vendor/jquery/jtrack/js/domcached-0.1-jquery.js")->add_jsfile("vendor/jquery/jtrack/js/jtrack.js")->add_jq_onready("jTask.init();\n\n\t\$.timesheetSpreadsheet = function() {\n\t\tvar table = \$('<table title=/>').attr('title', tr('Local Cache (Not Committed)'));\n\t\ttable.append('<tr><td>Summary</td><td>Estimate</td><td>Time Spent</td></tr>');\n\n\t\tvar rowI = 1;\n\t\tfor (var namespace in \$.DOMCached.getStorage()) {\n\t\t\tvar row = \$('<tr />').appendTo(table);\n\n\t\t\trow.append('<td>' + namespace + '</td>');\n\t\t\trow.append('<td>' + \$.DOMCached.get('estimate', namespace) + '</td>');\n\t\t\trow.append('<td formula=\\'ROUND(' + (\$.DOMCached.get('timer', namespace) / 60) + ', 2)\\'></td>');\n\t\t\trowI++;\n\t\t}\n\t\tvar row = \$('<tr />').appendTo(table);\n\t\trow.append('<td>Totals</td>');\n\t\trow.append('<td formula=\\'ROUND(SUM(B2:B' + rowI + '), 2)\\'/>');\n\t\trow.append('<td formula=\\'=ROUND(SUM(C2:C' + rowI + '), 2)\\' />');\n\n\t\t\$('#timesheetSpreadsheet').siblings().remove();\n\n\t\tvar jS = \$('#timesheetSpreadsheet').getSheet();\n\t\tif (jS) {\n\t\t\t\$('#timesheetSpreadsheet')\n\t\t\t\t.unbind('visible')\n\t\t\t\t.visible(function() {\n\t\t\t\t\tjS.openSheet(table);\n\t\t\t\t});\n\t\t} else {\n\t\t\t\$('#timesheetSpreadsheet')\n\t\t\t\t.visible(function() {\n\t\t\t\t\t\$(this).sheet({\n\t\t\t\t\t\tbuildSheet: table,\n\t\t\t\t\t\teditable: false,\n\t\t\t\t\t\theight: \$('#jtrack-holder').height()\n\t\t\t\t\t});\n\t\t\t\t});\n\t\t}\n\t};\n\n\t\$('.jtrack-create,.jtrack-update,.jtrack-remove,.jtrack-remove-all,.jtrack-cancel,.jtrack-power,#jtrack-button-remove,#jtrack-button-remove-all,#jtrack-button-create,#jtrack-button-update').on('click', function() {\n\t\t\$.timesheetSpreadsheet();\n\t});\n\n\t\$.timesheetSpreadsheet();\n\n\t\$('#timeSheetSaved').visible(function() {\n\t\t\$(this).sheet({\n\t\t\tbuildSheet: true,\n\t\t\teditable: false,\n\t\t\theight: \$('#jtrack-holder').height()\n\t\t});\n\t});\n\n\t\$('#timeSheetCommit').click(function() {\n\t\t\$('#timeSheetTabs').tikiModal(tr('Committing...'));\n\t\tvar stack = [];\n\t\t\$.getJSON('tiki-timesheet.php?save', function(inputs) {\n\t\t\tfor (var namespace in \$.DOMCached.getStorage()) {\n\t\t\t\tvar summary = namespace + '',\n\t\t\t\ttime =  \$.DOMCached.get('timer', summary) / 60;\n\t\t\t\tstack.push(summary);\n\n\t\t\t\tvar form = \$('<form />').submit(function() {\n\t\t\t\t\tvar fields = '';\n\n\t\t\t\t\t\$.each(form.serializeArray(), function() {\n\t\t\t\t\t\tfields += '&fields[' + this.name + ']=' + this.value;\n\t\t\t\t\t});\n\n\t\t\t\t\t\$.post('tiki-ajax_services.php?controller=tracker&trackerId={$trackerId}&action=insert_item' + fields,function() {\n\t\t\t\t\t\t\$.DOMCached.deleteNamespace(namespace);\n\n\t\t\t\t\t\tstack.pop();\n\n\t\t\t\t\t\tif (stack.length == 0) {\n\t\t\t\t\t\t\tdocument.location = document.location + '';\n\t\t\t\t\t\t}\n\t\t\t\t\t})\n\t\t\t\t\t.error(function() {\n\t\t\t\t\t\t\$('#timeSheetTabs').tikiModal();\n\t\t\t\t\t\talert(tr('Could not save'));\n\t\t\t\t\t});\n\t\t\t\t\treturn false;\n\t\t\t\t});\n\n\t\t\t\tvar input = {\n\t\t\t\t\t'Summary': \$(inputs['Summary']),\n\t\t\t\t\t'Description': \$(inputs['Description']),\n\t\t\t\t\t'Amount of time spent': \$(inputs['Amount of time spent']),\n\t\t\t\t\t'Done by': \$(inputs['Done by'])\n\t\t\t\t};\n\n\t\t\t\tinput['Summary'].val(summary);\n\t\t\t\tinput['Amount of time spent'].val(time);\n\t\t\t\tinput['Done by'].val('" . addslashes($user) . "');\n\t\t\t\tform.append(input['Summary']);\n\t\t\t\tform.append(input['Description']);\n\t\t\t\tform.append(input['Amount of time spent']);\n\t\t\t\tform.append(input['Done by']);\n\t\t\t\tform.submit();\n\t\t\t}\n\t\t});\n\n\t\treturn false;\n\t});\n\n\t\$('#timeSheetTabs')\n\t\t.width(\$('#timeSheetTabs').parent().width())\n\t\t.tabs();");
$smarty->assign('mid', 'tiki-timesheet.tpl');
// use tiki_full to include include CSS and JavaScript
$smarty->display("tiki.tpl");
 static function wikiView($args)
 {
     global $prefs, $headerlib, $smarty, $_REQUEST, $user;
     $page = $args['object'];
     $version = $args['version'];
     $date = $args['lastModif'];
     if (isset($_REQUEST['itemId'])) {
         self::getQuestionInputs($page, $_REQUEST['itemId']);
     }
     //self::getTimeStamp();
     $phrase = !empty($_REQUEST['phrase']) ? addslashes(htmlspecialchars($_REQUEST['phrase'])) : '';
     self::goToPhraseExistence($phrase, $page, $version);
     self::restorePhrasesInWikiPage($page, $phrase);
     $questions = Tracker_Query::tracker('Wiki Attributes')->byName()->filter(array('field' => 'Type', 'value' => 'Question'))->filter(array('field' => 'Page', 'value' => $page))->query();
     self::editQuestionsInterface($page, $questions);
     self::createForwardLinksInterface($page, $questions, $date);
 }
Beispiel #9
0
 function _load(&$sheet)
 {
     $tikilib = TikiLib::lib('tiki');
     $i = 0;
     $trackerName = $this->info['name'];
     $tracker = Tracker_Query::tracker($trackerName)->byName()->excludeDetails()->render(false)->query();
     foreach ($tracker as $item) {
         $j = 0;
         foreach ($item as $key => $field) {
             $sheet->initCell($i, $j);
             if (!empty($field[0]) && $field[0] == '=') {
                 $sheet->setCalculation(substr($field, 1));
             }
             $sheet->setValue($i == 0 ? $key : $field);
             $sheet->setSize(1, 1);
             $j++;
         }
         $i++;
     }
     return true;
 }
Beispiel #10
0
// Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details.
// $Id: tiki-view_invoice.php 44444 2013-01-05 21:24:24Z changi67 $
require_once 'tiki-setup.php';
$trklib = TikiLib::lib('trk');
$access->check_feature('feature_invoice');
$access->check_permission('tiki_p_admin');
//check if profile is created
if ($trklib->get_tracker_by_name("Invoice Items") < 1) {
    $smarty->assign('msg', tra('You need to apply the "Invoice" profile'));
    $smarty->display("error.tpl");
    die;
}
(int) ($_REQUEST['InvoiceId'] = $_REQUEST['InvoiceId']);
$smarty->assign('InvoiceId', $_REQUEST['InvoiceId']);
$invoice = Tracker_Query::tracker("Invoices")->byName()->equals($_REQUEST['InvoiceId'])->getOne();
$amount = 0;
if (is_array($invoice["Item Amounts"])) {
    foreach ($invoice["Item Amounts"] as $key => $sum) {
        $amount += $invoice["Item Amounts"][$key] * $invoice["Item Quantities"][$key];
    }
} else {
    $amount = $invoice["Item Amounts"] * $invoice["Item Quantities"];
}
$smarty->assign("invoice", $invoice);
$smarty->assign("amount", $amount);
$smarty->assign("client", Tracker_Query::tracker("Invoice Clients")->fields(array("Client Id"))->equals(array($invoice['Client Id']))->byName()->getOne());
$smarty->assign("setting", Tracker_Query::tracker("Invoice Settings")->byName()->query());
$smarty->assign("invoiceItems", Tracker_Query::tracker("Invoice Items")->fields(array("Invoice Id"))->equals(array($_REQUEST['InvoiceId']))->byName()->query());
// Display the template
$smarty->assign('mid', 'tiki-view_invoice.tpl');
$smarty->display("tiki.tpl");
Beispiel #11
0
 function appendToContents(&$contents, $item)
 {
     global $prefs, $_REQUEST;
     if ($this->debug == true) {
         ini_set('error_reporting', E_ALL);
         ini_set('display_errors', 1);
     }
     $this->itemsAdded = false;
     foreach ($item->feed->entry as $i => $newEntry) {
         $this->verifications[$i] = array();
         $this->verifications[$i]["reason"] = array();
         //lets remove the new entry if it has already been accepted in the past
         foreach ($contents->entry as &$existingEntry) {
             if ($existingEntry->textlink->text == $newEntry->textlink->text && $existingEntry->textlink->href == $newEntry->textlink->href) {
                 $this->verifications[$i]['reason'][] = 'exists';
                 unset($item->feed->entry[$i]);
             }
         }
         $revision = Feed_ForwardLink_Search::findWikiRevision($newEntry->forwardlink->text);
         $this->verifications[$i]["hashBy"] = JisonParser_Phraser_Handler::superSanitize($newEntry->forwardlink->author . $newEntry->forwardlink->authorInstitution . $newEntry->forwardlink->authorProfession);
         $this->verifications[$i]['foundRevision'] = $revision;
         $this->verifications[$i]["metadataHere"] = $this->metadata->raw;
         $this->verifications[$i]["phraseThere"] = JisonParser_Phraser_Handler::superSanitize($newEntry->forwardlink->text);
         $this->verifications[$i]["hashHere"] = hash_hmac("md5", $this->verifications[$i]["hashBy"], $this->verifications[$i]["phraseThere"]);
         $this->verifications[$i]["hashThere"] = $newEntry->forwardlink->hash;
         $this->verifications[$i]['exists'] = JisonParser_Phraser_Handler::hasPhrase($revision['data'], $this->verifications[$i]["phraseThere"]);
         if ($this->verifications[$i]['hashHere'] != $this->verifications[$i]['hashThere']) {
             $this->verifications[$i]['reason'][] = 'hash_tampering';
             unset($item->feed->entry[$i]);
         }
         if ($newEntry->forwardlink->websiteTitle != $prefs['browsertitle']) {
             $this->verifications[$i]['reason'][] = 'title';
             unset($item->feed->entry[$i]);
         }
         if ($this->verifications[$i]['exists'] == false) {
             if (empty($this->verifications[$i]['reason'])) {
                 $this->verifications[$i]['reason'][] = 'no_existence_hash_pass';
             } else {
                 $this->verifications[$i]['reason'][] = 'no_existence';
             }
             unset($item->feed->entry[$i]);
         }
         foreach ($newEntry->forwardlink as $key => $value) {
             if (isset(Feed_ForwardLink_Metadata::$acceptableKeys[$key]) && Feed_ForwardLink_Metadata::$acceptableKeys[$key] == true) {
                 //all clear
             } else {
                 $this->verifications[$i]['reason'][] = 'metadata_tampering' . ($this->debug == true ? $key : '');
                 unset($item->feed->entry[$i]);
             }
         }
         foreach ($newEntry->textlink as $key => $value) {
             if (isset(Feed_ForwardLink_Metadata::$acceptableKeys[$key]) && Feed_ForwardLink_Metadata::$acceptableKeys[$key] == true) {
                 //all clear
             } else {
                 $this->verifications[$i]['reason'][] = 'metadata_tampering' . ($this->debug == true ? $key : '');
                 unset($item->feed->entry[$i]);
             }
         }
     }
     if (empty($item->feed->entry) == false) {
         $this->itemsAdded = true;
         foreach ($item->feed->entry as &$entry) {
             Tracker_Query::tracker('Wiki Attributes')->byName()->replaceItem(array('Page' => $this->page, 'Attribute' => '', 'Value' => $entry->forwardlink->text, 'Type' => 'ForwardLink Accepted'));
         }
         if (empty($contents->entry) == true) {
             $contents->entry = array();
         }
         $contents->entry = array_merge($contents->entry, $item->feed->entry);
     }
 }
function wikiplugin_trackeritemcopy( $data, $params )
{
	global $smarty;
	$trklib = TikiLib::lib("trk");
	
	if (!isset($params["trackerId"]) || !isset($params["copyFieldIds"])) {
		return tra('Missing mandatory parameters');
	} else {
		$trackerId = $params["trackerId"];
		if (is_array($trackerId) == false) $trackerId = array($trackerId);
		$copyFieldIds = $params["copyFieldIds"];
	}
	
	$smarty->assign('itemIdSet', 'n');
	$itemId = 0;
	
	if (isset($params["itemId"])) {
		$itemId = $params["itemId"];
		$smarty->assign('itemIdSet', 'y');
	} elseif (isset($_POST["itemIdToCopy"])) {
		$itemId = $_POST["itemIdToCopy"];
	} 

	if ($_SERVER['REQUEST_METHOD'] == 'POST') {
		
		function items_copy($trackerId, $updateFieldIds, $updateFieldValues, $copyFieldIds, $itemIds, $linkFieldId, $itemLinkId, $copies)
		{
			global $trklib, $_POST;
			
			if (is_array($itemIds) == false) $itemIds = array($itemIds);
			
			foreach ($itemIds as $itemId) {
				$tracker_fields_info = $trklib->list_tracker_fields($trackerId);
				
				$fieldTypes = array();
				$fieldOptionsArray = array();
				
				foreach ($tracker_fields_info['data'] as $t) {
					$fieldTypes[$t['fieldId']] = $t['type'];
					$fieldOptionsArray[$t['fieldId']] = $t['options_array'];
				}
				
				$ins_fields["data"] = array();
				
				if (isset($linkFieldId) && isset($itemLinkId)) {
					$updateFieldIds[] = $linkFieldId;
					$updateFieldValues[] = $itemLinkId;
				}
				
				//print_r(array($trackerId, $updateFieldIds, $updateFieldValues, $copyFieldIds, $itemIds, $linkFieldId, $itemLinkId, $copies));
				
				for ($i = 0, $count_updateFieldIds = count($updateFieldIds); $i < $count_updateFieldIds; $i++) {
					$ins_fields["data"][] = array(
						'options_array' => $fieldOptionsArray[$updateFieldIds[$i]], 
						'type' => $fieldTypes[$updateFieldIds[$i]], 
						'fieldId' => $updateFieldIds[$i], 
						'value' => $updateFieldValues[$i]
					);
				}
				
				// CUSTOM: this part is totally custom to store admin notes (how to generalize?)
				if (!empty($_POST['admin_notes_for_copy'])) {
					$ins_fields["data"][] = array(
						'type' => 'a',
						'fieldId' => 118,
						'value' => $_POST['admin_notes_for_copy']
					);
				}
				// end totally CUSTOM part
				
				$newitems = array();
				for ($i = 0; $i < $copies; $i++) {
					// Check for -randomstring- and f_xx
					$ins_fields_final["data"] = array();
					foreach ($ins_fields["data"] as $h) {
						if ($h["value"] == '-randomstring-') {
							$h["value"] = $trklib->genPass();
						} else if (substr($h["value"], 0, 2) == 'f_') {
							$sourceFieldId = (int) trim(substr($h["value"], 2));
							$h["value"] = $trklib->get_item_value($trackerId, $itemId, $sourceFieldId);
						}
						$ins_fields_final["data"][] = $h; 
					}
					$newitemsdata[] = $ins_fields_final["data"];
					$newitems[] = $trklib->replace_item($trackerId, 0, $ins_fields_final);		
				}
				
				foreach ($newitems as $n) {
					$trklib->copy_item($itemId, $n, null, $copyFieldIds);
					$newitemslist .= '  ' . $n;
				}
			}
			
			return array(
				"items" => $newitems,
				"data" => $newitemsdata,
				"list" => $newitemslist
			);
		}
		
		$return_array = array();
		$itemIds = array();
		
		foreach ($trackerId as $key => $trackerIdLeft) {
			//ensure that the fields are set and usable
			if (isset($params["updateFieldIds"]) || isset($params["updateFieldValues"])) {
				$updateFieldIds = $params["updateFieldIds"];
				$updateFieldValues = $params["updateFieldValues"];
				
				foreach ($updateFieldIds as $key => $updateFieldId) {
					if (count($updateFieldIds[$key]) != count($updateFieldValues[$key])) {
						return tra('Number of update fields do not match new values');
					}
				}
				
				$copyFieldIds[$key] = array_diff($copyFieldIds[$key], $updateFieldIds);
			}
			
			if ($_SERVER['REQUEST_METHOD'] == 'POST' && $itemId && isset($_POST['copytrackeritem']) && isset($_POST['numberofcopies'])) {
				$copies = (int) $_POST['numberofcopies'];
			} elseif (isset($params['copies_on_load'])) {
				$copies = (int) $params['copies_on_load']; 
			} else {
				$copies = 0;
			}
			
			if ($copies > 0) {
				
				if ($key > 0) {
					$qry = Tracker_Query::tracker($trackerIdLeft)
						->fields($params["linkFieldIds"][0])
						->equals(array($itemId));
						
					$itemIds = array();
					foreach ($qry as $linkedItemIds => $item) {
						$itemIds[] = $linkedItemIds;
					}
				}
				
				$return_array[] = items_copy(
								$trackerId[$key], 
								$updateFieldIds[$key], 
								$updateFieldValues[$key], 
								$copyFieldIds[$key], 
								(
									$key == 0 ? $itemId : $itemIds
								),
								(
									$key == 0 ? null : $params["linkFieldIds"][$key - 1]
								),
								(
									$key == 0 ? null : $return_array[0]['items'][0]
								),
								$copies
				);
			}

		}
		
		$smarty->assign('newitemslist', $return_array['list']);
		
		if ($params['return_array'] == 'y') {
			if (count($return_array) == 1) { //backward compatible
				return $return_array[0];
			} else {
				return $return_array;
			}
		}
	
	}
	
	return $smarty->fetch('wiki-plugins/wikiplugin_trackeritemcopy.tpl');
}
Beispiel #13
0
 public function minimumStatisticsNeeded($out = true)
 {
     if (empty($this->minimumStatisticsNeeded)) {
         $this->minimumStatisticsNeeded = Tracker_Query::tracker('Wiki Attributes')->byName()->filterFieldByValue('Type', 'Minimum Statistics Needed')->filterFieldByValue('Page', $this->page)->render(false)->query();
     }
     if ($out == true) {
         return $this->endValue($this->minimumStatisticsNeeded, true);
     }
     return $this->minimumStatisticsNeeded;
 }
        if ($key == 0) {
            $trackerPrimary = Tracker_Query::tracker($trackerId)->start($_REQUEST['start'][$key])->end($_REQUEST['end'][$key])->equals($_REQUEST['q'][$key])->search($_REQUEST['search'][$key])->fields($_REQUEST['fields'][$key])->status($_REQUEST['status'][$key])->query();
        } else {
            $joinVars = $_REQUEST['itemIdFields'][$key - 1];
            $joinVars = explode('|', $joinVars);
            $trackerPrimary = Tracker_Query::join_trackers($trackerPrimary, Tracker_Query::tracker($trackerId)->start($_REQUEST['start'][$key])->end($_REQUEST['end'][$key])->equals($_REQUEST['q'][$key])->search($_REQUEST['search'][$key])->fields($_REQUEST['fields'][$key])->status($_REQUEST['status'][$key])->query(), $joinVars[0], $joinVars[1]);
        }
        $i++;
    }
}
if (isset($_REQUEST['sortFieldIds']) == true) {
    Tracker_Query::arfsort($trackerPrimary, $_REQUEST['sortFieldIds']);
}
if (isset($_REQUEST['removeFieldIds']) == true || isset($_REQUEST['showFieldIds']) == true) {
    $trackerPrimary = Tracker_Query::filter_fields_from_tracker_query($trackerPrimary, $_REQUEST['removeFieldIds'], $_REQUEST['showFieldIds']);
}
if (isset($_REQUEST['dateFieldIds'])) {
    $trackerPrimary = dateFormat($_REQUEST['dateFieldIds'], $trackerPrimary);
}
$trackerPrimary = Tracker_Query::prepend_field_header($trackerPrimary, $_REQUEST['sortFieldNames']);
if (isset($_REQUEST['time']) == true) {
    $endtime = microtime();
    $endarray = explode(" ", $endtime);
    $endtime = $endarray[1] + $endarray[0];
    $totaltime = $endtime - $starttime;
    $totaltime = round($totaltime, 5);
    echo "This page loaded in {$totaltime} seconds.\n\n\n";
}
if ($_REQUEST['type'] == 'csv' && count($trackerPrimary) > 0) {
    print_r(Tracker_Query::to_csv($trackerPrimary));
}
    if (is_array($Invoice["Item Amounts"])) {
        foreach ($Invoice["Item Amounts"] as $Key => $sum) {
            $Amount += $Invoice["Item Amounts"][$Key] * $Invoice["Item Quantities"][$Key];
        }
    } else {
        $Amount = $Invoice["Item Amounts"] * $Invoice["Item Quantities"];
    }
    $Invoices[$I]["Amount"] = $Amount;
    if (is_array($Invoice["Amounts Paid"])) {
        foreach ($Invoice["Amounts Paid"] as $Sum) {
            $Paid += $Sum;
        }
    } else {
        $Paid = $Invoice["Amounts Paid"];
    }
    $Invoices[$I]["Paid"] = $Paid;
    if ($Amount == $Paid) {
        $Status = "Paid";
    } else {
        $Status = "Open";
    }
    $Invoices[$I]["Status"] = $Status;
}
$smarty->assign("Invoices", $Invoices);
$smarty->assign("Settings", Tracker_Query::tracker("Invoice Settings")->byName()->query());
$smarty->assign("Amount", $Amount);
$smarty->assign("Paid", $Paid);
$smarty->assign("Status", $Status);
// Display the template
$smarty->assign('mid', 'tiki-list_invoices.tpl');
$smarty->display("tiki.tpl");
Beispiel #16
0
 function action_get_item_inputs($input)
 {
     $trackerId = $input->trackerId->int();
     $trackerName = $input->trackerName->string();
     $itemId = $input->itemId->int();
     $byName = $input->byName->bool();
     $defaults = $input->defaults->array();
     $this->trackerNameAndId($trackerId, $trackerName);
     $definition = Tracker_Definition::get($trackerId);
     if (!$definition) {
         throw new Services_Exception_NotFound();
     }
     $itemObject = Tracker_Item::newItem($trackerId);
     if (!$itemObject->canModify()) {
         throw new Services_Exception_Denied();
     }
     $query = Tracker_Query::tracker($byName ? $trackerName : $trackerId)->itemId($itemId);
     if ($input > 0) {
         $query->byName();
     }
     if (!empty($defaults)) {
         $query->inputDefaults($defaults);
     }
     $inputs = $query->queryInput();
     return $inputs;
 }
} else {
	$amount = $invoice["Item Amounts"] * $invoice["Item Quantities"];
}

$smarty->assign("invoice", $invoice);
$smarty->assign("amount", $amount);
$smarty->assign(
				"client",
				Tracker_Query::tracker("Invoice Clients")
				->fields(array("Client Id"))->equals(array($invoice['Client Id']))
				->byName()
				->getOne()
);
$smarty->assign(
				"setting", 
				Tracker_Query::tracker("Invoice Settings")
				->byName()
				->query()
);
$smarty->assign(
				"invoiceItems", 
				Tracker_Query::tracker("Invoice Items")
				->fields(array("Invoice Id"))->equals(array($_REQUEST['InvoiceId']))
				->byName()
				->query()
);

// Display the template
$smarty->assign('mid', 'tiki-view_invoice.tpl');
$smarty->display("tiki.tpl");
function wikiplugin_trackerquerytemplate($data, $params)
{
    global $tikilib;
    $params = array_merge(array('tracker' => '', 'debug' => '', 'byname' => 'y', 'render' => 'y', 'likefilters' => '', 'andfilters' => '', 'getlast' => ''), $params);
    if (!empty($params['itemids'])) {
        $itemIds = $params['itemids'];
        unset($params['itemids']);
        $newData = '';
        foreach ($itemIds as $itemId) {
            if (!empty($itemId)) {
                $params['itemid'] = $itemId;
                $newData .= wikiplugin_trackerquerytemplate($data, $params);
            }
        }
        return $newData;
    }
    $handler = new dataToFieldHandler();
    foreach ($params as &$param) {
        //We parse the variables
        $param = $handler->parse($param);
    }
    $query = Tracker_Query::tracker($params['tracker'])->excludeDetails();
    $pattern = 'id';
    if (!empty($params['byname']) && $params['byname'] == 'y') {
        $query->byName();
        $pattern = 'name';
    }
    if (!empty($params['render']) && $params['render'] == 'n') {
        $query->render(false);
    }
    if (!empty($params['itemid']) || isset($_REQUEST['itemId'])) {
        if (isset($_REQUEST['itemId'])) {
            //itemId overrides parameters
            $query->itemId($_REQUEST['itemId']);
            unset($_REQUEST['itemId']);
            //we unset because nested plugins may need to have itemId set
        } else {
            $query->itemId($params['itemid']);
        }
    }
    if (!empty($params['likefilters'])) {
        $likefilters = explode(';', $params['likefilters']);
        foreach ($likefilters as $likefilter) {
            $filter = explode(':', $likefilter);
            $query->filterFieldByValueLike($filter[0], $filter[1]);
        }
    }
    if (!empty($params['andfilters'])) {
        $andfilters = explode(';', $params['andfilters']);
        foreach ($andfilters as $andfilter) {
            $filter = explode(':', $andfilter);
            $query->filterFieldByValue($filter[0], $filter[1]);
        }
    }
    if (!empty($params['orfilters'])) {
        $orfilters = explode(';', $params['orfilters']);
        foreach ($orfilters as $orfilter) {
            $filter = explode(':', $orfilter);
            $query->filterFieldByValueOr($filter[0], $filter[1]);
        }
    }
    if (!empty($params['debug']) && $params['debug'] == 'y') {
        $query->debug();
    }
    if (!empty($params['getlast']) && $params['getlast'] == 'y') {
        $items = $query->getLast();
    } else {
        $items = $query->query();
    }
    $newData = '';
    foreach ($items as $itemId => $fields) {
        $trackerId = $query->trackerId();
        $handler->set($pattern, $fields, $query->itemsRaw[$itemId], $itemId, $trackerId);
        $newData .= $handler->parse($data);
        $newData = "~np~" . $tikilib->parse_data($newData, array('is_html' => true)) . "~/np~";
        $handler->pop();
    }
    return $newData;
}
	$timeSheet = Tracker_Query::tracker("Time sheet")
		->byName()
		->query();
} else {//views only your items
	$smarty->assign("all", false);
	
	$timeSheet = Tracker_Query::tracker("Time sheet")
		->byName()
		->filter(array("field" => "Done by", "value" => $user))
		->query();
}

if (isset($projectList)) {
	if (isset($_REQUEST['save'])) {
		echo json_encode(
			$timeSheetNewInputs = Tracker_Query::tracker("Time sheet")
				->byName()
				->queryInput()
		);
		die;
	}

	$smarty->assign("projectList", $projectList);
	$smarty->assign("timeSheet", $timeSheet);
}

TikiLib::lib("sheet")->setup_jquery_sheet();

$headerlib = TikiLib::lib("header")
	->add_cssfile("lib/jquery/jtrack/css/jtrack.css")
	->add_jsfile("lib/jquery/jtrack/js/domcached-0.1-jquery.js")