$formdata['c_q_first_name'] = array('type' => 'checkbox', 'parent_class' => 'multi_checkbox', 'settings' => array('data' => array('1' => v('CMT_FIRST_NAME'))), 'value' => 1); $formdata['c_q_last_name'] = array('type' => 'checkbox', 'parent_class' => 'multi_checkbox', 'settings' => array('data' => array('1' => v('CMT_LAST_NAME'))), 'value' => 1); $formdata['c_q_email'] = array('type' => 'checkbox', 'parent_class' => 'multi_checkbox', 'settings' => array('data' => array('1' => v('CMT_EMAIL'))), 'value' => 1); foreach ($formdata as $key => $val) { if (isset(${$key})) { $formdata[$key]['value'] = ${$key}; } } $filter_array['SEARCH'] = $formdata; $formdata = NULL; print "<div class='filter'>"; show_filter($filter_array); print "</div><!-- /.filter -->"; $head_array['TABLE'] = array("CMT_DATE" => "date", "CMT_USERNAME" => "username", "CMT_FIRST_NAME" => "first_name", "CMT_LAST_NAME" => "last_name"); $head_array['CONSTRUCT'] = array("add" => true); $data_array['TABLE'] = array("date" => "date", "username" => "default", "first_name" => "default", "last_name" => "default"); $data_array['CONSTRUCT'] = array("edit" => true, "copy" => true, "delete" => true, "activate" => true); if (!isset($order)) { $data_array['SORT'] = array("date" => $direction); } else { $data_array['SORT'] = array($order => $direction); } foreach ($head_array['CONSTRUCT'] as $key => $value) { if ($value === true) { print "<div class='engine-function'><a href='#' class='" . $key . "' data-content='" . $modul . "' ><i class='icon-" . $key . "'></i></a></div><!-- /.engine-function -->"; } } print "<div class='table'>"; thead($head_array); tbody($data_array); print "</div><!-- /.table -->";
/** * An easy way to make a paginated bootStrapTable * * @param String $sql * @param Array $buttons * @param String $hideColumns * @param String $toolbar * @param Integer $rowLimit * @param Integer $selected_page * @param Array $customFields * @param String $name * @param String $class * @param Boolean $paginate * @param Boolean $searchable * @param Boolean $checked * @param String $checkPostURL * @return type */ function bootStrapTable($sql = "select * from user_detail", $buttons = "", $hideColumns = "", $toolbar = "My Grid", $customFields = null, $name = "grid", $tableInfo = "", $formHideFields = "", $class = "table table-striped", $rowLimit = 10, $paginate = true, $searchable = true, $checked = false, $selected_page = 1, $checkedPostURL = "", $checkSingleSelect = true, $event = "", $mobiletooltip = "") { $DEB = $this->DEB; $hideColumns = explode(",", strtoupper($hideColumns)); $object = rawurlencode(json_encode(func_get_args())); $paginating = "false"; if ($paginate) { $paginating = "true"; } $options = ["id" => $name, "class" => $class, "data-toolbar" => "#toolbar" . $name, "data-pagination" => "{$paginating}", "data-side-pagination" => "server", "data-search" => "false", "data-height" => "400", "data-page-list" => "[5, 10, 20, 50, 100, 200]", "data-page-size" => $rowLimit]; if ($searchable) { $options["data-search"] = "true"; } if ($checked) { $options["data-click-to-select"] = "true"; if ($checkSingleSelect) { $options["data-single-select"] = "true"; } } $data = @$DEB->getRow("select first 1 * from ({$sql}) t "); $fieldInfo = @$DEB->fieldinfo; if (empty($fieldInfo)) { die("Perhaps the SQL for this query is broken {$sql} or the table does not exist, have you specified the correct database in your Cody initialization, Try running migrations with maggy"); } $header = ""; if ($checked) { $header .= th(["data-field" => "checked" . $name . "[]", "class" => "text-left", "data-checkbox" => "true"], ""); } foreach ($fieldInfo as $fid => $field) { if (!in_array(strtoupper($field["name"]), $hideColumns)) { if (isset($customFields[$field["name"]])) { $customField = $customFields[$field["name"]]; if (empty($customField["type"])) { $customField["type"] = "text"; } switch ($customField["type"]) { default: $header .= th(["data-field" => $field["name"], "class" => "text-" . $field["align"], "data-sortable" => "true"], ucwords(str_replace("_", " ", strtolower($field["alias"])))); break; case "checkbox": $header .= th(["data-field" => $field["name"], "class" => "text-" . $field["align"], "data-checkbox" => "true"], ""); break; case "hidden": $header .= th(["data-field" => $field["name"], "class" => "hidden"], ucwords(str_replace("_", " ", strtolower($field["alias"])))); break; } } else { $header .= th(["data-field" => $field["name"], "class" => "text-" . $field["align"], "data-sortable" => "true"], ucwords(str_replace("_", " ", strtolower($field["alias"])))); } } } $addColumn = ""; if ($buttons) { $addColumn .= th(["data-field" => "BUTTONS"], "Options"); } $header = thead(tr($header . $addColumn)); if (empty($toolbar["caption"])) { $toolbar = array(); $toolbar["caption"] = ""; } $insertButton = $this->bootStrapButton("btnInsert", "Add", "call{$name}Ajax('/cody/form/insert','{$name}Target', {object : a{$name}object, record: null, db: '{$DEB->tag}' })", "btn btn-success pull-left", "", true); if (empty($toolbar["buttons"])) { $toolbar["buttons"] = ""; } $toolbar["buttons"] = $insertButton . $toolbar["buttons"]; if (empty($toolbar["filter"])) { $toolbar["filter"] = ""; } $tableHeading = ""; if (!empty($toolbar["caption"])) { $tableHeading = h3($toolbar["caption"]) . hr(); } $toolbarButtons = $toolbar["buttons"]; $toolbarFilters = $toolbar["filter"]; if ($searchable) { $toolbarFilters .= div(["class" => "search"], input(["id" => "search{$name}", "class" => "search form-control", "type" => "text", "placeholder" => "Search " . $toolbar["caption"], "onkeyup" => '$table' . $name . '.bootstrapTable(\'getData\')'])); } $toolbarFilters = div(["class" => "form-inline", "role" => "form"], $toolbarFilters); $html = $tableHeading . div(["class" => "table-responsive"], div(["class" => "table-toolbar clearfix"], div(["class" => "toolbar-buttons"], $toolbarButtons) . div(["class" => "toolbar-filters"], $toolbarFilters)) . table($options, $header, tbody())); $html .= script(' var a' . $name . 'object = "' . $object . '"; var $table' . $name . ' = $("#' . $name . '").bootstrapTable({search : false, url : "/cody/data/ajax/' . $this->DEB->tag . '", method : "post", onCheck: function (row) { eventType = \'check\'; ' . $event . ' }, onUnCheck: function (row) { eventType = \'uncheck\'; ' . $event . ' }, queryParams: function (p) { return {object: a' . $name . 'object, limit: p.limit, offset :p.offset, order: p.order, search : $("#search' . $name . '").val(), sort: p.sort } } }); $search = $("#search' . $name . '"); var timeoutId = null; $search.off("keyup").on("keyup", function (event) { clearTimeout(timeoutId); timeoutId = setTimeout(function () { $table' . $name . '.bootstrapTable("refresh", {pageNumber: 1}); }, 1000); }); '); if ($checked) { $html = form(["method" => "post", "action" => $checkedPostURL, "enctype" => "multipart/form-data"], $html); } $html .= div(["id" => "{$name}Target"]); $html .= $this->ajaxHandler("", "{$name}Target", "call{$name}Ajax"); return $html; }
$_SESSION['toggle_sidebar'] = $_POST['toggle_sidebar']; } if (isset($_POST['toggle_filter'])) { $_SESSION['toggle_filter'] = $_POST['toggle_filter']; } if (isset($_POST['toggle_val']) && isset($_POST['toggle_type'])) { $_SESSION['toggle_filter_' . $_POST['toggle_type']] = $_POST['toggle_val']; } if (isset($_GET['update_sort_order'])) { $i = 1; foreach ($_POST['sort'] as $value) { $sql = "UPDATE " . $_SESSION['TABLE_PREFIX'] . $_SESSION['modul'] . " SET sort_order = '" . $i . "' WHERE id = '" . $value . "' "; db_mysql_query($sql, $conn); $i++; } } if (isset($_GET['form_inputadd'])) { $i = $_GET['form_inputadd']; $formdata['source_value_' . $i] = array('type' => 'input_add', 'label' => v('CMT_DATA'), 'class' => 'source_input', 'style' => array('class' => "col-3_of_7")); print_form($formdata); unset($formdata); } if (isset($_POST['sub_page'])) { if (isset($_POST['modul'])) { $modul = parse($_POST['modul'], 'string'); } if (isset($_POST['sub_page'])) { $sub_page = parse($_POST['sub_page'], 'int'); } tbody(unserialize($_POST['params'])); }
function listar_cad_documento_item($cod_documento) { ///////////////////////////////////////////////////////////////////////////// function tbody($codigo_lancamento, $cod_projeto, $cod_ctr_custo, $cod_conta, $historico, $montante, $data_vencimento_liquidacao) { if (intval($_GET['id']) > 0) { $disabled = " disabled "; } else { $disabled = " "; } return "<tr id='rowToClone'>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 20px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<input " . $disabled . " coluna='codigo_lancamento' id='codigo_lancamento' placeholder='' onchange='calcular_total_debito_credito();' onkeyup='calcular_total_debito_credito();' class='uk-form-small' type='text' style='width: 100%;' value='" . $codigo_lancamento . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_projeto}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_projeto' id='cod_projeto' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_projeto . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_ctrcusto}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_ctr_custo' id='cod_ctr_custo' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_ctr_custo . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_conta}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_conta' id='cod_conta' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_conta . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 200px;padding: 0px 5px; '><input " . $disabled . " coluna='historico_' id='historico_' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $historico . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 100px;padding: 0px 5px;'><input " . $disabled . " coluna='montante' id='montante' placeholder='' class='uk-form-small' type='text' style='width: 100%;text-align: right;' onchange='formatar_numero(this);calcular_total_debito_credito();' onkeyup='formatar_numero(this);calcular_total_debito_credito();' value='" . $montante . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 100px;padding: 0px 5px;'><input " . $disabled . " coluna='data_vencimento_liquidacao' id='data_vencimento_liquidacao' placeholder='' class='uk-form-small' type='text' style='width: 100%;' onchange='formatar_data(this);' onkeyup='formatar_data(this);' value='" . $data_vencimento_liquidacao . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 10px;padding: 0px 5px;'>\n\t\t\t\t\t\t\t<button " . $disabled . " class='uk-button uk-button-mini uk-button-danger' type='button' onclick=delRow(this,'tableToModify') data-uk-tooltip title='Excluir linha'><i class='uk-icon-trash-o'></i></button>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>"; } if (intval($_GET['id']) > 0) { $tbody = ""; } else { $tbody = tbody('', '', '', '', '', '', ''); } include "config.php"; $select = "\n\t\t\t\t\tSELECT \n\t\t\t\t\t\t\tcad_documento_item.cod_documento_item, \n\t\t\t\t\t\t\tcad_documento_item.cod_documento, \n\t\t\t\t\t\t\tcad_documento_item.numero_item, \n\t\t\t\t\t\t\tcad_documento_item.codigo_lancamento,\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tconcat(cad_projeto.cod_projeto,' - ', cad_projeto.nome_projeto) as cod_projeto,\n\t\t\t\t\t\t\tconcat(cad_conta.numero_conta,' - ', cad_conta.descricao) as cod_conta,\n\t\t\t\t\t\t\tconcat(cad_centro_custo.numero_centro_custo,' - ', cad_centro_custo.descricao) as cod_ctr_custo,\n\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tmontante, \n\t\t\t\t\t\t\thistorico, \n\n\t\t\t\t\t\t\tDATE_FORMAT(data_vencimento_liquidacao,'%d/%m/%Y') as data_vencimento_liquidacao,\n\t\t\t\t\t\t\tcod_documento_compensacao\n\t\t\t\t\t FROM \n\t\t\t\t\t\t" . $schema_projetos . ".cad_projeto, \n\t\t\t\t\t\t" . $schema . ".cad_documento_item, \n\t\t\t\t\t\t" . $schema . ".cad_conta,\n\t\t\t\t\t\t" . $schema . ".cad_centro_custo \n\t\t\t\t\t\t\n\t\t\t\t\t\twhere \n\t\t\t\t\t\t\tcad_documento_item.cod_projeto=cad_projeto.cod_projeto and\n\t\t\t\t\t\t\tcad_documento_item.cod_conta=cad_conta.cod_conta and\n\t\t\t\t\t\t\tcad_documento_item.cod_ctr_custo=cad_centro_custo.cod_centro_custo and\n\t\t\t\t\t\t\tcod_documento='" . $cod_documento . "' and cad_documento_item.cod_empresa=" . $_SESSION['cod_empresa'] . " ; "; $resultado = mysql_query($select, $conexao) or die(mysql_error()); while ($row = mysql_fetch_array($resultado)) { $tbody .= tbody($row['codigo_lancamento'], $row['cod_projeto'], $row['cod_ctr_custo'], $row['cod_conta'], $row['historico'], $row['montante'], $row['data_vencimento_liquidacao']); } echo " <div>\n\t\t\t\t\t\t<script>"; $selects = new selects(); $selects->projeto_autocomplete(''); echo "</script>\n\t\t\t\t\t\t<script>"; $selects = new selects(); $selects->ctrcusto_autocomplete(''); echo "</script>\n\t\t\t\t\t\t<script>"; $selects = new selects(); $selects->conta_autocomplete(''); echo "</script>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='uk-form'>\n\t\t\t\t\t\t<table class='uk-table uk-table-hover uk-table-condensed' id='tableToModify'>\n\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th style='width: 20px;'>CL</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Projeto</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Ctr. Custo</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Conta</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 200px;'>Descrição</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 100px;'>Valor</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 100px;'>Vencimento</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 30px;'></th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</thead>\n\t\t\t\t<tbody style='min-height: 250px;'>\n\t\t\t\t\t" . $tbody . "\n\t\t\t\t</tbody>\n\t\t\t</table>\n\t</div>\n\t\n\t"; ///////////////////////////////////////////////////////////////////////////// }