예제 #1
0
파일: api.php 프로젝트: edusig/USP
     $attributeCompareValue = explode(',', $values);
     $length = 0;
     foreach ($attributeCompare as $k => $v) {
         if ($v != '0') {
             $length++;
         }
     }
     foreach ($attributeList as $k => $v) {
         $continue = $k < $length - 1 ? 'AND ' : '';
         if ($attributeCompare[$k] != '0') {
             array_push($conditions, array('att' => $v, 'compare' => $attributeCompare[$k], 'value' => '"' . $attributeCompareValue[$k] . '"', 'continue' => $continue));
         }
     }
     $sqlm->setGeneratorParams($queryType, array($table), $attributeList, $conditions, false, false, false, $distinct);
     $sql = $sqlm->generateSql();
     $r = $sqlm->executeSql();
     $i = 0;
     foreach ($r as $k => $v) {
         $i++;
         $r[$k]['action'] = base64_encode("<input type='hidden' name='select_row_{$i}' id='row_pks_{$i}' data-pk='" . join(',', $sqlm->getPrimaryKeys($table)) . "' data-pkvalues='" . join(',', $sqlm->getPrimaryKeyValues($table, $v)) . "' class='tupla_select'><span class='glyphicon glyphicon-edit editarTupla' id='editar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span><span class='glyphicon glyphicon-remove removerTupla' id='deletar_{$table}_{$r[$k][0]}' data-row='{$i}' data-id='{$r[$k][0]}'></span>");
     }
     $columns = array(array('mData' => 'action', 'sTitle' => 'Ação', 'sClass' => 'actionColumn'));
     foreach ($sqlm->getColumns($table) as $k => $v) {
         array_push($columns, array('mData' => $v['Field'], 'sTitle' => $sqlm->renameColumns($v['Field']), 'sClass' => 'sortCustomColumn ' . $v['Field']));
     }
     $sqlm->setJSON(array('aoColumns' => $columns, 'aaData' => $r));
     break;
 case 'Insert':
     $attributeList = explode(',', $attributes);
     $attributeValues = explode(',', $values);
     $attributeSql = array('att_names' => $attributeList, 'att_values' => $attributeValues);