Ejemplo n.º 1
0
function GetRecords() {
global $recordSet, $fieldSet, $table, $onsubmit, $arr_field;

		for( $i = 0; $i < $recordSet->FieldCount(); $i++ )
		{
		
			$field = $recordSet->FetchField($i); 
			$name  = $field->name;
			$value = $recordSet->fields[$name];
			if ( $field->primary_key )
			{
				$id = $value;
				$formName = "f$table$id";
				if ( isAdmin() )
					echo WrapDIV( $name, WrapForm( $formName, "add_record_in_table.php", $onsubmit, GetHiddenInput('table', $table).GetHiddenInput('key_name', 'id').GetHiddenInput( $name, $value )."<input type='image' src='http://solution.artel.ws/images/valid.png' value='Сохранить' form='$formName' hidden title='Сохранить изменения'/> ",  "max-width:100%;" ) );
				else
					echo WrapDIV( $name, "<a target='_blank' href='show_record.php?table=$table&id=$value&key_id=$name' onmousemove='this.click();' > <img src='http://solution.artel.ws/images/eye.png' /> </a>", 'max-width:100%;', 'left' );
				
				continue;
			}
			
					
			$field_name = GetFieldProp($name);
		   if ( ($name == 'id') ||  !(isAdmin() || ( !$fieldSet->EOF ? $fieldSet->fields['is_view'] : '1' ) ) )
				continue;
			
			$type = ( $fieldSet->fields['type_input'] ? $fieldSet->fields['type_input'] : StyleInput( $field->type ) );
			$formula = $fieldSet->fields['formula'];
			$length = ( $fieldSet->fields['field_len'] ? $fieldSet->fields['field_len']  : $field->max_length );;
			$col_width = ( $length > 5 ? $length *10 : GetLengthFromType($type) )."px";
			$style = "min-width:$col_width;float:left;";
			
			if ( isAdmin() )
				echo WrapDIV( $name, GetInputFromType( $type, $name, $value, "width:100%;max-width:150px;", $formName, $in_table, $field_name), $style );
			else 
			{
				if (substr($name, 0, 2 ) == 'id' && (substr($name, 2) != substr($table, 2)) )
				 echo WrapDIV( $field_name, GetValueFromID( $value, $name ), $style ); 
				 
				elseif ($name == 'photo')
				 echo WrapDIV( $field_name, "<a href='/photos/$value' class='fancybox-button' rel='collection'> <img src='/photos/$value' style='$style'/> </a>", $style, 'center' ); 
				else
				{
					if ( !($value) && $formula )
					    $value = GetValueFormula( $formula );
					    
				  echo WrapDIV( $field_name, ( (($type=='checkbox') || ($type=='radio')) ? GetTextInput($name, '', $value, $style, $type, '', '' ) : ( $value ? $value : '-') ), $style ); 				
				}			
			}
		} //for
		 
}
Ejemplo n.º 2
0
function PutRecordSetToCSV($recordSet, $file, $TERMINATED = ',', $ENCLOSED = '"', $LINES_TERMINATED = "\r\n")
{
    global $filename;
    $fd = fopen($file, 'wb');
    // пишем заголовки
    for ($i = 0; $i < $recordSet->FieldCount(); $i++) {
        $field = $recordSet->FetchField($i);
        $name = $field->name;
        /*
        	   if ( substr($name, 0, 3 ) == 'id_' && (substr($name, 2) != substr($filename, 2)) )
        	       ClearCashe($name);
        */
        fwrite($fd, $ENCLOSED . GetFieldProp($field->name) . $ENCLOSED . $TERMINATED);
    }
    fwrite($fd, $LINES_TERMINATED);
    // пишем данные
    foreach ($recordSet as $key => $row) {
        for ($i = 0; $i < $recordSet->FieldCount(); $i++) {
            $field = $recordSet->FetchField($i);
            $name = $field->name;
            $value = substr($name, 0, 3) == 'id_' && substr($name, 2) != substr($filename, 2) ? GetValueFromID($row[$i], $name, 300) : $row[$i];
            fwrite($fd, $ENCLOSED . $value . $ENCLOSED . $TERMINATED);
        }
        fwrite($fd, $LINES_TERMINATED);
    }
    // while
    fclose($fd);
    // чистим кеш
    for ($i = 0; $i < $recordSet->FieldCount(); $i++) {
        $field = $recordSet->FetchField($i);
        $name = $field->name;
        if (substr($name, 0, 3) == 'id_' && substr($name, 2) != substr($filename, 2)) {
            ClearCashe($name);
        }
    }
}
Ejemplo n.º 3
0
function GetRealValue( $value, $name ) {
  global $table;
  
  if ( substr($name, 0, 3 ) == 'id_' )
		return GetValueFromID( $value, $name ); 
  else
      return $value;	
}
Ejemplo n.º 4
0
while (!$recordSet->EOF) {
    $pdf->AddPage();
    // создаем первую страницу, на которой будет содержимое
    if ($photo = $recordSet->fields['photo']) {
        $pdf->Image("/photos/{$photo}", 0, 0, 500);
        $pdf->setCellMargins(110);
    }
    for ($i = 0; $i < $recordSet->FieldCount(); $i++) {
        $field = $recordSet->FetchField($i);
        $name = $field->name;
        $value = $recordSet->fields[$i];
        if (!$arr_field[$i]["is_view"] || $name == 'photo') {
            continue;
        }
        if (substr($name, 0, 2) == 'id' && substr($name, 2) != substr($table, 2) && $name != 'id') {
            $value = GetValueFromID($value, $name);
        }
        $type = $arr_field[$i]["type"];
        $align = $type == 'checkbox' || $type == 'radio' ? 'C' : ($type == 'number' ? 'C' : 'L');
        // Наименование поля
        $pdf->SetFont('freeserif', 'b', 12);
        $pdf->Cell(50, 0, $arr_field[$i]["field_name"], 1, 0, 'L');
        $pdf->SetFont('', '');
        if ($type == 'checkbox' || $type == 'radio') {
            $pdf->CheckBox($name, 12, $recordSet->fields[$i]);
        } else {
            $pdf->Cell(-$arr_field[$i]["length"], 0, $value ? $value : '-', 0, 0, 'L');
        }
        $pdf->Ln();
        //ПЕРЕВОД СТРОКИ
    }