PHP Class Table, spaghettiphp Code Examples

This page contains top rated real world PHP examples of class Table from package spaghettiphp extracted from open source projects. You can rate examples to help us improve the quality of examples
Example #1
Show file File: radiologi_spesimen.php Project: reekoheek/srmis
0
	function list_data_radio($hal = 0) {
		$_SESSION[setting_radiologi_spesimen][hal] = $hal;
		$objResponse = new xajaxResponse();
		$paging = new MyPagina;
		$paging->rows_on_page = 15;
		$paging->sql = "
			SELECT 
				rp.id as id,
				rp.nama as nama,
				rp.biaya_bhp as biaya_bhp,
				rpd.biaya_jasa as biaya_jasa,
				rpd.kelas as kelas
			FROM 
				radio_pemeriksaan rp
				JOIN radio_pemeriksaan_detil rpd ON (rpd.tingkat = rp.tingkat)			
			ORDER BY 
				rp.nama
			";
		
		$paging->hal = $hal;
		$paging->get_page_result();

		$data = $paging->data;
		$no = $paging->start_number();
		$navi = $paging->navi();

		$table = new Table;
		$table->tbody_height = 350;
		$table->addTh(
			"No", 
			"Nama", 
			"Biaya BHP", 
			"Biaya Jasa",
			"Kelas",
			"Hapus"
		);
		//$table->addExtraTh("style=\"width:50px;\"","style=\"width:200px;\"","","","");
		//$kon = new Konek;
		for($i=0;$i<sizeof($data);$i++) {
			$table->addRow(
				($no+$i), 
				$data[$i][nama],
				$data[$i][biaya_bhp], 
				$data[$i][biaya_jasa],
				$data[$i][kelas], 
				"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_kamar('".$data[$i][id]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>"
			);
			$table->addOnclickTd(
				"xajax_get_info('".$data[$i][id]."')", 
				"xajax_get_info('".$data[$i][id]."')", 
				"xajax_get_info('".$data[$i][id]."')", 
				"xajax_get_info('".$data[$i][id]."')", 
				"xajax_get_info('".$data[$i][id]."')"
			);
		}
		$buka = $table->build();
		$objResponse->addAssign("list_data_radio", "innerHTML", $buka);
		$objResponse->addAssign("navi", "innerHTML", $navi);
		return $objResponse;
	}
Example #2
Show file File: Column.php Project: gitter-badger/tabulate-1
0
 public function __construct(Database $database, Table $table, $info)
 {
     // Table
     $this->table = $table;
     // Name
     $this->name = $info->Field;
     // Type
     $this->parse_type($info->Type);
     // Default
     $this->default_value = $info->Default;
     // Primary key
     if (strtoupper($info->Key) == 'PRI') {
         $this->is_primary_key = true;
         if ($info->Extra == 'auto_increment') {
             $this->is_auto_increment = true;
         }
     }
     // Unique key
     if (strtoupper($info->Key) == 'UNI') {
         $this->is_unique = true;
     }
     // Comment
     $this->comment = $info->Comment;
     // Collation
     $this->collation = $info->Collation;
     // NULL?
     $this->nullable = $info->Null == 'YES';
     // Is this a foreign key?
     if (in_array($this->name, $table->get_foreign_key_names())) {
         $referencedTables = $table->get_referenced_tables(false);
         $this->references = $referencedTables[$this->name];
     }
 }
Example #3
Show file File: MssqlPlatform.php Project: kalaspuffar/php-orm-benchmark
0
 public function getPrimaryKeyDDL(Table $table)
 {
     if ($table->hasPrimaryKey()) {
         $pattern = 'CONSTRAINT %s PRIMARY KEY (%s)';
         return sprintf($pattern, $this->quoteIdentifier($this->getPrimaryKeyName($table)), $this->getColumnListDDL($table->getPrimaryKey()));
     }
 }
Example #4
Show file File: TableTest.php Project: raphhh/pumpkin
0
 /**
  * Tests toPhpUnitTable.
  */
 public function testToPhpUnitTable()
 {
     $table = new Table(new Test(new ReflectionMethod(__CLASS__, __FUNCTION__)), 'dbName', 'tableName');
     $result = $table->toPhpUnitTable();
     $this->assertInstanceOf('PHPUnit_Extensions_Database_DataSet_ITable', $result);
     $this->assertSame('dbName.tableName', $result->getTableMetaData()->getTableName());
 }
Example #5
Show file File: HodnoteniaCallback.php Project: BGCX067/fajr-svn-to-git
0
 public function getHtml()
 {
     $trace = $this->trace->addChild("HodnoteniaCallback");
     $hodnotenia = $this->app->getHodnotenia($trace);
     $hodnoteniaTable = new Table(TableDefinitions::hodnotenia());
     $priemeryCalculator = new PriemeryCalculator();
     foreach (Sorter::sort($hodnotenia->getData(), array("semester" => -1, "nazov" => 1)) as $row) {
         if ($row['semester'] == 'L') {
             $class = 'leto';
             $priemeryCalculator->add(PriemeryCalculator::SEMESTER_LETNY, $row['znamka'], $row['kredit']);
         } else {
             $class = 'zima';
             $priemeryCalculator->add(PriemeryCalculator::SEMESTER_ZIMNY, $row['znamka'], $row['kredit']);
         }
         $hodnoteniaTable->addRow($row, array('class' => $class));
     }
     $hodnoteniaCollapsible = new Collapsible(new HtmlHeader('Hodnotenia'), $hodnoteniaTable);
     $priemery = $this->app->getPriemery($trace);
     $priemeryTable = new Table(TableDefinitions::priemery());
     $priemeryTable->addRows($priemery->getData());
     $priemeryContainer = new Container();
     $priemeryContainer->addChild(new Label('Nasledovné priemery sú prebraté z AISu, čiže to (ne)funguje presne rovnako:'));
     $priemeryContainer->addChild($priemeryTable);
     if ($priemeryCalculator->hasPriemer()) {
         $priemeryFajrText = '<p><br />Nasledovné vážené študijné priemery sú počítané Fajrom priebežne z tabuľky Hodnotenia, <strong>preto nemôžu byť považované ako oficiálne</strong>:<br /><br />';
         $priemeryFajrText .= $priemeryCalculator->getHtml();
         $priemeryFajrText .= '</p>';
         $priemeryContainer->addChild(new Label($priemeryFajrText));
     }
     $priemeryCollapsible = new Collapsible(new HtmlHeader('Priemery'), $priemeryContainer);
     return $hodnoteniaCollapsible->getHtml() . $priemeryCollapsible->getHtml();
 }
Example #6
Show file File: translationeditor.php Project: srueegger/1zu12bB
0
 public function display()
 {
     $form = new Form(2);
     $form->submit();
     $GLOBALS['editinglanguage'] = new Language($_GET['language']);
     $table = new Table();
     $token = new TableColumn("token", "Token");
     $translation = new TableFunctionColumn("token", Language::DirectTranslate("TRANSLATION"));
     $translation->functionName = "TranslationEditor_GetString";
     $translation->autoWidth = true;
     $languagetoken = new TableColumn("'" . DataBase::Current()->EscapeString($_GET['language']) . "' as language", "Language");
     $languagetoken->value = $_GET['language'];
     $languagetoken->visible = false;
     $table->columns->add($token);
     $table->columns->add($translation);
     $table->columns->add($languagetoken);
     $table->name = "{'dbprefix'}language_tokens";
     $table->actions = "translation_tokens";
     $table->orderBy = "token";
     $table->size = -1;
     $table->display();
     $newModule = Language::DirectTranslateHtml("NEW_MODULE");
     echo "<h2>" . $newModule . "</h2>";
     $form->display();
 }
Example #7
Show file File: Table.php Project: pagekit/pagekit
0
 /**
  * @param string $columnName
  * @param string $typeName
  * @param array $options
  *
  * @return Column
  */
 public function addColumn($columnName, $typeName, array $options = array())
 {
     if ($this->connection->getDatabasePlatform()->getName() === 'sqlite' && in_array($typeName, ['string', 'text'])) {
         $options['customSchemaOptions']['collation'] = 'NOCASE';
     }
     return $this->table->addColumn($columnName, $typeName, $options);
 }
Example #8
Show file File: tindakan.php Project: reekoheek/srmis
0
	function list_data($hal = 0) {
		$_SESSION[hal] = $hal;
		$objResponse = new xajaxResponse();
		$paging = new MyPagina;
		$paging->rows_on_page = 20;
		$paging->sql = "SELECT 
				i.id as icid, 
				i.kode as kode, 
				i.nama as nama, 
				id.id as idid,
				id.*
		FROM 
			icopim i 
			LEFT JOIN icopim_detil id ON (id.tingkat = i.tingkat) 
		GROUP BY i.id, id.kelas
		ORDER BY i.nama, id.kelas
		";
		$paging->hal = $hal;
		$paging->get_page_result();

		$data = $paging->data;
		$no = $paging->start_number();
		$navi = $paging->navi();

		$tabel = new Table;
		$tabel->tbody_height = 400;
		$tabel->addTh(
			"No", 
			"Kode", 
			"Tindakan", 
			"Tingkat", 
			"Kelas", 
			"Biaya",		
			"Hapus"
		);

		for($i=0;$i<sizeof($data);$i++) {
			$tabel->addRow(
				($no+$i), 
				$data[$i][kode], 
				$data[$i][nama], 
				$data[$i][tingkat], 
				$data[$i][kelas], 
				$data[$i][biaya],			 
				"<a href=\"javascript:void(0)\" title=\"Hapus\" onclick=\"hapus_tindakan('".$data[$i][icid]."', '".$data[$i][idid]."', this)\" class=\"tombol_hapus\"><img src=\"".IMAGES_URL."remove.png\" alt=\"Hapus\" border=\"0\" /></a>");
			$tabel->addOnclickTd(
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')", 
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')", 
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')", 
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')", 
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')", 
				"xajax_get_tindakan('".$data[$i][icid]."', '".$data[$i][tingkat]."', '".$data[$i][kelas]."')"				
			);
		}

		$buka = $tabel->build();
		$objResponse->addAssign("list_data", "innerHTML", $buka);
		$objResponse->addAssign("navi", "innerHTML", $navi);
		return $objResponse;
	}
Example #9
Show file File: connect.php Project: kxopa/WebSite-PHP
0
 public function Load()
 {
     require_once dirname(__FILE__) . "/includes/utils-unset-var.inc.php";
     if (!$this->isAjaxPage()) {
         unsetWspAdminVariables();
     }
     parent::$PAGE_TITLE = __(CONNECT_PAGE_TITLE);
     $this->setUserRights("");
     // Welcome message
     $this->render = new Table();
     $this->render->setWidth("100%");
     $connect_box = new RoundBox(RoundBox::STYLE_SECOND, "connect_box", 420, 150);
     $connect_box->setShadow(true);
     $connect_box->setValign(RoundBox::VALIGN_CENTER);
     $connect_table = new Table();
     $connect_table->setWidth("100%")->setDefaultAlign(RowTable::ALIGN_LEFT);
     $admin_pic = new Picture("img/wsp-admin/admin_128.png", 128, 128);
     $this->auth_obj = new Authentication($this, "connect");
     $this->auth_obj->setTableWidth(265);
     $connect_table->addRowColumns($admin_pic, $this->auth_obj);
     $connect_box->setContent($connect_table);
     $this->render->addRow("<br/><br/><br/><br/><br/>");
     $this->obj_br_before = new Object();
     $this->obj_br_before->setId("divBrBefore");
     $this->render->addRow($this->obj_br_before);
     $this->mod_obj = new Object();
     $this->mod_obj->setId("divConfigRecommandation")->setWidth(400);
     $this->render->addRow($this->mod_obj);
     $this->render->addRow("");
     $this->render->addRow($connect_box, RowTable::ALIGN_CENTER, RowTable::VALIGN_CENTER);
     $this->render->addRow("<br/>");
 }
Example #10
Show file File: rolelist.php Project: srueegger/1zu12bB
0
 public function display()
 {
     $rolelist = new Template();
     $rolelist->load("role_list");
     $actions = ActionList::get("rolelist");
     if (isset($_POST['insert'])) {
         $role = new Role();
         $role->name = $_POST['insert'];
         $role->insert();
     }
     if (isset($_GET['delete'])) {
         $role = new Role();
         $role->ID = $_GET['delete'];
         $role->delete();
     }
     $table = new Table();
     $id = new TableColumn("id", Language::DirectTranslate("ID"));
     $id->autoWidth = true;
     $name = new TableColumn("name", Language::DirectTranslate("NAME"));
     $table->columns->add($id);
     $table->columns->add($name);
     $table->name = "{'dbprefix'}roles";
     $table->actions = "rolelist";
     $table->orderBy = "name";
     $table->cacheName = "rolelist";
     $rolelist->assign_var("TABLE", $table->getCode());
     $rolelist->output();
 }
Example #11
Show file File: comment.form.php Project: rasarpmultimedia/ezCMSv1.1.2
0
function commentform($pageid)
{
    //global $session;
    $process = new ProcessForm();
    $validate = $process::validate();
    $postcomment = new Table("Comments");
    //Process Page Form
    if ($process->submitForm()) {
        /*@setting validation rules*/
        $required = array("name", "comment");
        $process->errorinfo = array_merge($process->errorinfo, $validate->check_requiredFields($required));
        $massage = $process->message("Comment has been successfully submmited.");
        //$sucessmsg = $_REQUEST["msg"]=$massage;
        if ($process->successflag) {
            //put database table here
            $postcomment::$tablefields = array("Name" => $process->post("name"), "Comment" => $process->post("comment"), "Pageid" => $pageid);
            /*saved to database*/
            $postcomment->save();
            //echo "new recored was added with id=".$postcomment->lastInsertedId();
            //echo "<br> success happened and all fields are sent to database, Thank you ! :)";
        }
    }
    $form = new Form("commentform", filter_var($_SERVER['PHP_SELF']) . "?" . filter_var($_SERVER['QUERY_STRING']), "post");
    //Company;
    $form->startForm();
    $form->setFormField("", $form->addFormInfo("<h2>Comment Form</h2>"));
    //Page Title
    $form->setFormField($form->inputLabel("name", "*Name"), $form->inputField("text", "name", $process->post("name")), $validate->displayErrorField($process->errorinfo, "name"));
    // Page Content
    $form->setFormField($form->inputLabel("comment", "*Comment (HTML is not allowed)"), $form->textAreaField("comment", $process->post("comment"), 10, 45, 'placeholder="Type comment here"'), $validate->displayErrorField($process->errorinfo, "comment"));
    //Submit Form
    $form->setFormField(null, $form->inputField("hidden", "userid", $process->post("userid", $authorid = "")) . $form->inputField("submit", "submit", "Add Comment"));
    $form->endForm();
    return $form->DisplayFields($GLOBALS["form_labling"], $process->message);
}
Example #12
Show file File: payment.php Project: saydulk/a2billing
0
 public function payment($module = '')
 {
     global $payment, $language, $PHP_SELF;
     $instance_sub_table = new Table("cc_payment_methods", "payment_filename");
     $DBHandle = DbConnect();
     $return = null;
     $return = $instance_sub_table->Get_list($DBHandle, $QUERY, 0);
     $this->modules = array();
     if (is_array($return)) {
         foreach ($return as $value) {
             array_push($this->modules, $value["payment_filename"]);
         }
     }
     $include_modules = array();
     if (!empty($module) && in_array($module . '.' . substr($PHP_SELF, strrpos($PHP_SELF, '.') + 1), $this->modules)) {
         $this->selected_module = $module;
         $include_modules[] = array('class' => $module, 'file' => $module . '.php');
     } else {
         reset($this->modules);
         while (list(, $value) = each($this->modules)) {
             $class = substr($value, 0, strrpos($value, '.'));
             $include_modules[] = array('class' => $class, 'file' => $value);
         }
     }
     for ($i = 0, $n = sizeof($include_modules); $i < $n; $i++) {
         include dirname(__FILE__) . '/../methods/' . $include_modules[$i]['file'];
         $GLOBALS[$include_modules[$i]['class']] = new $include_modules[$i]['class']();
     }
     if (!is_null($module) && in_array($module, $this->modules) && isset($GLOBALS[$module]->form_action_url)) {
         $this->form_action_url = $GLOBALS[$module]->form_action_url;
     }
     $actived_module = $this->selection();
     $payment = $actived_module[0]['id'];
 }
Example #13
Show file File: soa.php Project: neoclust/mmc
0
    function createUiContainers(){
	$t = new Table();
	$t->add($this->_createNameElement(_T("Zone name"),false),
		array("value" => $this->hostname, "required" => True));
	$t->add(new TrFormElement(	_T("Name server"), 
					new InputTpl($this->pn("dnsserver")), 
					$this->_dnRulesTooltip(AllowedDn::RELATIVE|AllowedDn::FQDN)
					),
		array("value" => $this->values["dnsserver"], "required" => True));
	$t->add(new TrFormElement(	_T("Responsible person e-mail"), 
					new InputTpl($this->pn("mail")),
					$this->_dnRulesTooltip(AllowedDn::RELATIVE|AllowedDn::FQDN)
					),
		array("value"=>$this->values["mail"], "required" => True));
	$t->add(new TrFormElement(_T("Time interval before the zone should be refreshed"), new BindRemainingTimeTpl($this->pn("refresh"))),
		array("value"=>BindRemainingTimeTpl::valueFromBindTimeString($this->values["refresh"])));
	$t->add(new TrFormElement(_T("Time interval that should elapse before a failed refresh should be retried"), new BindRemainingTimeTpl($this->pn("retry"))),
		array("value"=>BindRemainingTimeTpl::valueFromBindTimeString($this->values["retry"])));
	$t->add(new TrFormElement(_T("Expiry time"), new BindRemainingTimeTpl($this->pn("expiry"))),
		array("value"=>BindRemainingTimeTpl::valueFromBindTimeString($this->values["expiry"])));
	$t->add(new TrFormElement(_T("Minimum TTL"), new BindRemainingTimeTpl($this->pn("minttl"))),
		array("value"=>BindRemainingTimeTpl::valueFromBindTimeString($this->values["minttl"])));
	$t->add(new TrFormElement(_T("Serial number"), new HiddenTpl($this->pn("serial"))),
		array("value"=>$this->values["serial"], "required" => True));
	return array($this->stackedUi($t));
    }
Example #14
Show file File: TransactionAlmsController.php Project: abhinay100/forma_app
0
 public function mod()
 {
     $id_trans = Get::req('id_trans', DOTY_INT, 0);
     if (isset($_POST['undo'])) {
         Util::jump_to('index.php?r=alms/transaction/show');
     }
     if (isset($_POST['save']) || isset($_POST['not_paid'])) {
         $product_to_activate = Get::req('product', DOTY_MIXED, array());
         $id_user = Get::req('id_user', DOTY_MIXED, 0);
         if ($this->model->saveTransaction($product_to_activate, $id_trans, $id_user)) {
             $this->model->controlActivation($id_trans, isset($_POST['not_paid']));
             Util::jump_to('index.php?r=alms/transaction/show&res=ok');
         }
         Util::jump_to('index.php?r=alms/transaction/show&res=err');
     }
     $transaction_info = $this->model->getTransactionInfo($id_trans);
     $user_info = $this->acl_man->getUser($transaction_info['id_user'], false);
     $user_info[ACL_INFO_USERID] = $this->acl_man->relativeId($user_info[ACL_INFO_USERID]);
     require_once _base_ . '/lib/lib.table.php';
     $tb = new Table(false, Lang::t('_DETAILS', 'transaction'), Lang::t('_DETAILS', 'transaction'));
     $ts = array('', '', 'min-cell', 'image');
     $th = array(Lang::t('_CODE', 'transaction'), Lang::t('_NAME', 'transaction'), Lang::t('_PRICE', 'transaction'), Lang::t('_MARK_AS_PAID', 'transaction'));
     $tb->setColsStyle($ts);
     $tb->addHead($th);
     foreach ($transaction_info['product'] as $product_info) {
         $tb->addBody(array($product_info['code'], $product_info['name'], $product_info['price'], Form::getInputCheckbox('product_' . $product_info['id_course'] . '_' . $product_info['id_date'] . '_' . $product_info['id_edition'], 'product[' . $product_info['id_course'] . '_' . $product_info['id_date'] . '_' . $product_info['id_edition'] . ']', 1, $product_info['activated'], $product_info['activated'] ? ' disabled="disabled"' : '')));
     }
     $this->render('mod', array('transaction_info' => $transaction_info, 'user_info' => $user_info, 'tb' => $tb, 'id_trans' => $id_trans));
 }
Example #15
Show file File: Column.php Project: rsky/phroonga
0
 public function __construct(Table $table, $name, array $options = array())
 {
     $columnTypes = array(self::TYPE_COLUMN_FIX_SIZE, self::TYPE_COLUMN_VAR_SIZE, self::TYPE_COLUMN_INDEX);
     if ($this->isObjectResource($name, $columnTypes)) {
         parent::__construct($name);
         return;
     }
     $ctx = $table->getContext();
     $path = null;
     $flags = 0;
     $type = null;
     foreach (array('path', 'flags', 'type') as $option) {
         if (isset($options[$option])) {
             if ($option === 'type') {
                 ${$option} = $this->fetchResource($options[$option], $ctx);
             } else {
                 ${$option} = $options[$option];
             }
         }
     }
     $previous = ini_set('track_errors', '1');
     $column = @grn_column_open_or_create($table->getResource(), $name, $path, $flags, $type);
     ini_set('track_errors', $previous);
     if (!$column) {
         throw new Exception($php_errormsg);
     }
     parent::__construct($column);
 }
Example #16
Show file File: ogrschema.php Project: pkorduan/xmi2db
0
 function createEnumerationTable($enumeration, $dbSchema)
 {
     if ($this->is_table_filtered($enumeration['name'])) {
         $this->logger->log("<br>Ignoriere Enumeration: {$enumeration['name']}");
     }
     $this->logger->log('<br><b>Create Enumeration Tables: ' . $enumeration['name'] . '</b> (' . $enumeration['xmi_id'] . ')');
     $table = new Table($enumeration['name']);
     # read Values
     $enumType = new EnumType($enumeration['name'], $this->logger);
     $enumType->setSchemas($this->umlSchema, $dbSchema);
     $enumType->setId($enumeration['id']);
     $table->values = $enumType->getValues($enumeration);
     # definiere Attribute
     $wert_type = empty($enumType) ? 'chacacter varying' : $enumType->getWertType();
     $attribute = new Attribute('wert', $wert_type);
     $table->addAttribute($attribute);
     $attribute = new Attribute('beschreibung', 'character varying');
     $table->addAttribute($attribute);
     # definiere Primärschlüssel
     $table->primaryKey = 'wert';
     $this->logger->log($table->values->asTable($table->attributes));
     #		if (
     #			$table->values->rows[0][0] != $table->values->rows[0][1] AND
     #			$table->values->rows[0][1] != 'NULL'
     #		)
     # definiere Commentare
     $table->addComment('UML-Typ: Enumeration');
     $sql .= $table->asSql();
     $this->enumerations[$enumType->name] = $enumType;
     $this->logger->log('<pre>' . $tableSql . '</pre>');
     return $sql;
 }
Example #17
Show file File: configure-banned-visitors.php Project: kxopa/WebSite-PHP
0
 public function Load()
 {
     parent::$PAGE_TITLE = __(CONFIGURE_BANNED_VISITORS);
     if (!defined('MAX_BAD_URL_BEFORE_BANNED')) {
         define("MAX_BAD_URL_BEFORE_BANNED", 4);
     }
     $this->array_wsp_banned_users = WspBannedVisitors::getBannedVisitors();
     $this->table_ban = new Table();
     $this->table_ban->setId("table_ban")->activateAdvanceTable()->activatePagination()->activateSort(2, "desc")->setWidth(500);
     $this->table_ban->addRowColumns("IP", __(LAST_ACCESS), __(DURATION), __(AUTHORIZE))->setHeaderClass(0);
     $ban_vistors_obj = new Object("<br/><br/>", $this->table_ban, "<br/><br/>");
     $ban_ip_table = new Table();
     $form = new Form($this);
     $this->ip_edt = new TextBox($form);
     $validation = new LiveValidation();
     $validation->addValidatePresence();
     $this->ip_edt->setLiveValidation($validation);
     $this->duration_edt = new TextBox($form);
     $this->duration_edt->setValue(0);
     $validation = new LiveValidation();
     $validation->addValidatePresence()->addValidateNumericality(true);
     $this->duration_edt->setLiveValidation($validation);
     $ip_btn = new Button($form);
     $ip_btn->setValue(__(BAN_IP))->onClick("onBannedIP")->setAjaxEvent();
     $ban_ip_table->addRowColumns("IP : ", $this->ip_edt);
     $ban_ip_table->addRowColumns(__(DURATION) . " : ", $this->duration_edt);
     $form->setContent(new Object($ban_ip_table, $ip_btn));
     $ban_vistors_obj->add($form, "<br/><br/>");
     $this->render = new AdminTemplateForm($this, $ban_vistors_obj);
 }
Example #18
Show file File: change-passwd.php Project: kxopa/WebSite-PHP
0
 public function Load()
 {
     parent::$PAGE_TITLE = __(CHANGE_PASSWD);
     $form = new Form($this, "Form_change_passwd");
     if (extension_loaded('openssl')) {
         //$form->setEncryptObject(new EncryptDataWspObject("change wsp password", 2048));
     }
     $table = new Table();
     $table->addRow();
     $this->edt_old_passwd = new Password($form, "wsp_old_password");
     $this->edt_old_passwd->setFocus();
     $live_validation = new LiveValidation();
     $live_validation->addValidatePresence()->setFieldName(__(OLD_PASSWD));
     $table->addRowColumns(__(OLD_PASSWD) . " :&nbsp;", $this->edt_old_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
     $this->edt_new_passwd = new Password($form, "wsp_new_password");
     $live_validation = new LiveValidation();
     $live_validation->addValidatePresence()->setFieldName(__(NEW_PASSWD));
     $table->addRowColumns(__(NEW_PASSWD) . " :&nbsp;", $this->edt_new_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
     $this->edt_confirm_passwd = new Password($form, "wsp_confirm_password");
     $live_validation = new LiveValidation();
     $live_validation->addValidatePresence()->setFieldName(__(CONFIRM_PASSWD));
     $live_validation->addValidateConfirmation("wsp_new_password");
     $table->addRowColumns(__(CONFIRM_PASSWD) . " :&nbsp;", $this->edt_confirm_passwd->setLiveValidation($live_validation))->setStyle("color:black;");
     $table->addRow();
     $this->validate_btn = new Button($form);
     $this->validate_btn->setValue(__(CHANGE_PASSWD))->onClick("onChangePasswd")->setAjaxEvent();
     $table->addRow($this->validate_btn)->setColspan(2)->setAlign(RowTable::ALIGN_CENTER);
     $table->addRow();
     $form->setContent($table);
     $table = new Table();
     $table->setWidth("100%");
     $table->addRow($form, RowTable::ALIGN_CENTER);
     $this->render = $table;
 }
Example #19
Show file File: aaaa.php Project: sebastiendu/mmc
0
 function createUiContainers($editMode = false)
 {
     $t = new Table();
     $t->add($this->_createNameElement(_T("Host name")), array("value" => $this->hostname, "required" => True));
     $t->add(new TrFormElement(_T("IPv6 address"), new IPv6InputTpl($this->pn("ip"))), array("value" => $this->values["ip"], "required" => true));
     return array($this->stackedUi($t));
 }
Example #20
Show file File: TableTest.php Project: aainc/Scruit
0
 public function testUpdate()
 {
     $result = $this->target->createUpdate();
     $this->assertSame('UPDATE tableName SET col1 = ?, col2 = ? WHERE id = ?', $result['SQL']);
     $this->assertSame('sdi', $result['marker']);
     $this->assertSame(array('col1', 'col2', 'id'), $result['columns']);
 }
Example #21
Show file File: Datatype.php Project: HaldunA/phpwebsite
0
 /**
  * Creates a Datatype object for insertion into the passed table. The table's
  * database engine type is checked first. This allows database specific data
  * type instructions to be used.
  *
  * @param \Database\Table $table
  * @param string $name Name of column/data type
  * @param string $type Data type
  * @param string $value Default value for column
  * @return \Database\Datatype Returns an extension of Datatype
  * @throws \Exception
  */
 public static function factory(Table $table, $name, $type, $value = null)
 {
     $engine = $table->db->getDatabaseType();
     $alltypes = $table->getDatatypeList();
     $type = strtolower($type);
     if (empty($type)) {
         throw new \Exception(\t('Data type was empty'));
     }
     if (!isset($alltypes[$type])) {
         throw new \Exception(\t('Unknown data type "%s"', $type));
     }
     $class_name = ucwords($alltypes[$type]);
     $class_file = PHPWS_SOURCE_DIR . "Global/Database/Datatype/{$class_name}.php";
     $engine_file = PHPWS_SOURCE_DIR . "Global/Database/Engine/{$engine}/Datatype/{$class_name}.php";
     if (is_file($engine_file)) {
         $datatype_name = "\\Database\\Engine\\{$engine}\\Datatype\\{$class_name}";
     } elseif (is_file($class_file)) {
         $datatype_name = "\\Database\\Datatype\\{$class_name}";
     } else {
         throw new \Exception(\t('Unknown class name "%s"', $class_name));
     }
     $object = new $datatype_name($table, $name);
     if ($object->default instanceof \Variable) {
         $object->setDefault($value);
     }
     return $object;
 }
Example #22
Show file File: ZapisanePredmetyCallback.php Project: BGCX067/fajr-svn-to-git
0
 public function getHtml()
 {
     $predmetyZapisnehoListu = $this->skusky->getPredmetyZapisnehoListu();
     $predmetyZapisnehoListuTable = new Table(TableDefinitions::predmetyZapisnehoListu());
     $predmetyZapisnehoListuCollapsible = new Collapsible('Predmety zápisného listu', $predmetyZapisnehoListuTable);
     $kreditovCelkomLeto = 0;
     $kreditovCelkomZima = 0;
     $pocetPredmetovLeto = 0;
     $pocetPredmetovZima = 0;
     foreach (Sorter::sort($predmetyZapisnehoListu->getData(), array("semester" => -1, "nazov" => 1)) as $row) {
         if ($row['semester'] == 'L') {
             $pocetPredmetovLeto += 1;
             $kreditovCelkomLeto += $row['kredit'];
             $class = 'leto';
         } else {
             $pocetPredmetovZima += 1;
             $kreditovCelkomZima += $row['kredit'];
             $class = 'zima';
         }
         $predmetyZapisnehoListuTable->addRow($row, array('class' => $class));
     }
     $pocetPredmetovText = 'Celkom ';
     $pocetPredmetovText .= FajrUtils::formatPlural($pocetPredmetovLeto + $pocetPredmetovZima, '0 predmetov', '1 predmet', '%d predmety', '%d predmetov');
     if ($pocetPredmetovLeto > 0 && $pocetPredmetovZima > 0) {
         $pocetPredmetovText .= sprintf(' (%d v zime, %d v lete)', $pocetPredmetovZima, $pocetPredmetovLeto);
     }
     $kreditovCelkomText = '' . ($kreditovCelkomLeto + $kreditovCelkomZima);
     if ($kreditovCelkomLeto > 0 && $kreditovCelkomZima > 0) {
         $kreditovCelkomText .= sprintf(' (%d+%d)', $kreditovCelkomZima, $kreditovCelkomLeto);
     }
     $predmetyZapisnehoListuTable->addFooter(array('nazov' => $pocetPredmetovText, 'kredit' => $kreditovCelkomText), array());
     $predmetyZapisnehoListuTable->setUrlParams(array('studium' => Input::get('studium'), 'list' => Input::get('list')));
     return $predmetyZapisnehoListuTable->getHtml();
 }
Example #23
Show file File: ptr.php Project: sebastiendu/mmc
0
 function createUiContainers()
 {
     $t = new Table();
     $t->add($this->_createNameElement(_T("Name")), array("value" => $this->hostname, "required" => True));
     $t->add(new TrFormElement(_T("Canonical name"), new InputTpl($this->pn("cname")), $this->_dnRulesTooltip(AllowedDn::RELATIVE)), array("value" => $this->values["cname"], "extra" => "." . $this->zone, "required" => True));
     return array($this->stackedUi($t));
 }
Example #24
Show file File: utils.inc.php Project: kxopa/WebSite-PHP
0
function createTableFirstPagePic64($array_link)
{
    $ind = 0;
    $row_table = null;
    $table = new Table(10, 10);
    for ($i = 0; $i < sizeof($array_link); $i++) {
        if ($array_link[$i]->getUserHaveRights()) {
            if ($ind % 5 == 0) {
                if ($row_table != null) {
                    $table->addRow($row_table);
                }
                $row_width = 20;
                if (sizeof($array_link) < 5) {
                    $row_width = 100 / sizeof($array_link);
                }
                $row_table = new RowTable(RowTable::ALIGN_CENTER, $row_width . "%");
            }
            $row_table->add($array_link[$i]);
            $ind++;
        }
    }
    if ($row_table != null) {
        $table->addRow($row_table);
    }
    return $table;
}
Example #25
Show file File: menu.plugin.php Project: rowena-altastratus/altastratus
0
 /**
  * Get menu
  *
  * @param string $category Category name
  */
 public static function get($category = '')
 {
     // Get menu table
     $menu = new Table('menu');
     // Display view
     View::factory('box/menu/views/frontend/index')->assign('items', $menu->select('[category="' . $category . '"]', 'all', null, array('id', 'name', 'link', 'target', 'order', 'category'), 'order', 'ASC'))->assign('uri', Uri::segments())->assign('defpage', Option::get('defaultpage'))->display();
 }
Example #26
Show file File: afsdb.php Project: sebastiendu/mmc
0
 function createUiContainers()
 {
     $subtypesMap = $this->subtypes();
     $subtypes = array_values($subtypesMap);
     if (isset($subtypesMap[$this->values["subtype"]])) {
         $subtypeIndex = array_search($subtypesMap[$this->values["subtype"]], $subtypes);
         $customSubtype = "";
     } else {
         $subtypeIndex = count($subtypes) - 1;
         $customSubtype = $this->values["subtype"];
     }
     $isCustomSubtype = $subtypeIndex == count($subtypes) - 1 ? "checked" : "";
     $subtypeComboBox = new ExtendedSelectItem($this->pn("subtype"));
     $subtypeComboBox->setAdditionalParams("onkeyup=\"this.blur();this.focus();\" onchange=\"var state = (this.selectedIndex == this.length - 1) ? 'inline' : 'none'; changeObjectDisplay('" . $this->pn("subtypediv") . "',state);\"");
     $subtypeComboBox->setElements(array_values($subtypes));
     $subtypeComboBox->setElementsVal(array_keys($subtypes));
     $t1 = new Table();
     $t1->add($this->_createNameElement(_T("Owner name"), true, "/(@|[a-z0-9][a-z0-9-_.]*[a-z0-9]\$)/"), array("value" => $this->hostname, "required" => True));
     $t1->add(new TrFormElement(_T("Subtype"), $subtypeComboBox), array("value" => $subtypeIndex));
     $subtypeDiv = new Div(array("id" => $this->pn("subtypediv")));
     $subtypeDiv->setVisibility($isCustomSubtype);
     $t2 = new Table();
     $t2->add(new TrFormElement(_T("Custom subtype"), new InputTpl($this->pn("customsubtype"), '/^([0-5]?\\d?\\d?\\d?\\d|6[0-4]\\d\\d\\d|65[0-4]\\d\\d|655[0-2]\\d|6553[0-5])$/'), array("tooltip" => _T("Custom subtype ranges from 0 to 65535"))), array("value" => $customSubtype));
     $t3 = new Table();
     $t3->add(new TrFormElement(_T("Domain name of a host that has a server for the cell named by the owner name"), new InputTpl($this->pn("ownernamehost")), $this->_dnRulesTooltip()), array("value" => $this->values["ownernamehost"], "required" => True));
     return array($this->stackedUi($t1), $this->stackedUi($subtypeDiv, 0), $this->stackedUi($t2, 2), $this->stackedUi($t3));
 }
Example #27
Show file File: RecordSetQueries.php Project: realsoc/mediawiki-extensions
0
function getTransactedSQL( QueryTransactionInformation $transactionInformation, array $selectFields, Table $table, array $restrictions, array $orderBy = array(), $count = - 1, $offset = 0 ) {
	$tableNames = array( $table->getIdentifier() );

	if ( $table->isVersioned ) {
		$restrictions[] = $transactionInformation->getRestriction( $table );
		$tableNames = array_merge( $tableNames, $transactionInformation->getTables() );
		$orderBy = array_merge( $orderBy, $transactionInformation->versioningOrderBy() );
		$groupBy = $transactionInformation->versioningGroupBy( $table );
		$selectFields = array_merge( $selectFields, $transactionInformation->versioningFields( $table->getIdentifier() ) );
	}
	else {
		$groupBy = array();
	}
	
	$query =
		"SELECT " . implode( ", ", $selectFields ) .
		" FROM " . implode( ", ", $tableNames );

	if ( count( $restrictions ) > 0 ) {
		$query .= " WHERE " . implode( ' AND ', $restrictions );
	}
	if ( count( $groupBy ) > 0 ) {
		$query .= " GROUP BY " . implode( ', ', $groupBy );
	}
	if ( count( $orderBy ) > 0 ) {
		$query .= " ORDER BY " . implode( ', ', $orderBy );
	}
	if ( $count != - 1 ) {
		$query .= " LIMIT " . $offset . ", " . $count;
	}
	return $query;
}
Example #28
Show file File: Gruppen.php Project: BackupTheBerlios/rheinaufcms-svn
0
 function group_table()
 {
     $group_table = '';
     $this->images['edit'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/edit.png', 'Eigenschaften bearbeiten', array('title' => 'Eigenschaften bearbeiten'));
     $this->images['apply'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/apply.png', 'Speichern');
     $this->images['apply_path'] = '/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/apply.png';
     $this->images['checkbox_disabled_unchecked'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/checkbox_disabled_unchecked.png', 'Nicht erlaubt');
     $this->images['checkbox_disabled_checked'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/checkbox_disabled_checked.png', 'Erlaubt');
     $this->images['new_group'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/add_group.png', 'Gruppe hinzufügen', array('title' => 'Gruppe hinzufügen'));
     $this->images['delete_group'] = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/delete_group.png', 'Gruppe löschen', array('title' => 'Gruppe löschen'));
     $img_group = Html::img('/' . INSTALL_PATH . '/Classes/Admin/Icons/16x16/edit_group.png', 'Gruppe');
     $cols = count($this->rechte) + 3;
     $table = new Table($cols, array('id' => 'groups_table'));
     $form_tag = Form::form_tag('/Admin/Gruppen');
     $form_close = Form::close_form();
     $th = array(Html::bold('Gruppe'));
     foreach ($this->rechte as $recht) {
         $th[] = $recht['RechtName'];
     }
     $table->add_th($th);
     for ($i = 0; $i < count($this->existent_groups); $i++) {
         if (isset($_GET['editgroup']) && $_GET['editgroup'] == $i) {
             $td = array(Form::add_input('text', 'name', $this->existent_groups[$i]['Name']));
             for ($j = 0; $j < count($this->rechte); $j++) {
                 if (in_array($this->rechte[$j]['id'], $this->existent_groups[$i]['Rechte'])) {
                     $td[] = Form::add_input('checkbox', 'Recht[]', $this->rechte[$j]['id'], array('checked' => 'checked'));
                 } else {
                     $td[] = Form::add_input('checkbox', 'Recht[]', $this->rechte[$j]['id']);
                 }
             }
             $id = Form::add_input('hidden', 'group_id', $i);
             $new_rechte_submit = Form::add_input('image', 'submit_rechte', 'Speichern', array('src' => $this->images['apply_path'], 'alt' => 'Speichern'));
             $td[] = $id . $new_rechte_submit;
         } else {
             $td = array(Html::bold($this->existent_groups[$i]['Name']));
             for ($j = 0; $j < count($this->rechte); $j++) {
                 $td[] = in_array($this->rechte[$j]['id'], $this->existent_groups[$i]['Rechte']) ? $this->images['checkbox_disabled_checked'] : $this->images['checkbox_disabled_unchecked'];
             }
             $edit_button = Html::a('/Admin/Gruppen?editgroup=' . $i, $this->images['edit'], array('title' => 'Eigenschaften bearbeiten'));
             $delete_button = Html::a('/Admin/Gruppen?deletegroup=' . $i, $this->images['delete_group'], array('title' => 'Gruppe löschen', 'onclick' => "return confirm('Gruppe " . $this->existent_groups[$i]['Name'] . " löschen?')"));
             $td[] = $edit_button;
             $td[] = $delete_button;
         }
         $class = is_int($i / 2) ? 'abwechselnde_flaechen_1' : 'abwechselnde_flaechen_2';
         $table->add_td($td, array('class' => is_int($i / 2) ? 'abwechselnde_flaechen_1' : 'abwechselnde_flaechen_2'));
     }
     $new_group_button = Html::a('/Admin/Gruppen?newgroup', $this->images['new_group'] . ' Gruppe hinzufügen');
     if (isset($_GET['newgroup'])) {
         $td = array(Form::add_input('text', 'name', 'Name...'));
         for ($j = 0; $j < count($this->rechte); $j++) {
             $td[] = Form::add_input('checkbox', 'Recht[]', $this->rechte[$j]['id']);
         }
         $new_group_submit = Form::add_input('image', 'submit_newgroup', 'Speichern', array('src' => $this->images['apply_path'], 'alt' => 'Speichern'));
         $td[] = $id . $new_group_submit;
         $table->add_td($td);
     } else {
         $table->add_td(array(array(2 => $new_group_button)));
     }
     return $form_tag . $table->flush_table() . $form_close;
 }
Example #29
Show file File: ns.php Project: sebastiendu/mmc
0
 function createUiContainers()
 {
     $t = new Table();
     $t->add($this->_createNameElement(_T("Domain name")), array("value" => $this->hostname, "required" => True));
     $t->add(new TrFormElement(_T("Name server"), new InputTpl($this->pn("dnsserver")), $this->_dnRulesTooltip()), array("value" => $this->values["dnsserver"], "required" => True));
     return array($this->stackedUi($t));
 }
Example #30
Show file File: RecreateIndexes.php Project: realsoc/mediawiki-extensions
0
function recreateIndexesForTable( Table $table, $purpose ) {
	echo "Dropping indices from table " . $table->getIdentifier() . ".\n";
	dropAllIndicesFromTable( $table->getIdentifier() );

	echo "Creating new indices for table " . $table->getIdentifier() . ".\n";
	addIndexesForTable( $table, $purpose );
}
Frequently Used Methods