protected function btnExport_Create(){
   $this->btnExport = new QButton($this);
   $this->btnExport->Text = QApplication::Translate('Export to CSV');
   $this->btnExport->AddAction(new QClickEvent(), new QServerAction('btnExport_Click'));
}
       
protected function btnExport_Click($strFormId, $strControlId, $strParameter) {
   header("Content-type: application/octet-stream");
   header("Content-Disposition: attachment; filename=\"my-data.csv\"");
   echo "this and, that"; // replace this with table data or whatever
   exit;
}

Based on the following page, I thought this would be fairly straightforward:
http://www.qcodo.com/wiki/qcodo/requirements

I copied the current site from the old box (RHEL 4 [32-bit], PHP 5.2.3, MySQL 5.0.41, WebAuth 3.5.1) to a newer box (RHEL 5 [32-bit], PHP 5.2.9, MySQL 5.0.77, WebAuth 3.6.1).

I did a mysqldump on the old box and imported into the new box.

I copied the old Apache config over to the new box.

I have the correct PHP extensions (and their dependencies) installed.

WebAuth is working on the new box.

I'm just not sure what else to try - and I'm not seeing any errors in the Apache logs.

Upon visiting the site via a browser, I get CSS, images, JS, and such, but no content. Inside of the areas where the content should be, I see either blank white areas or one with the following error:
“Oops, an error has occurred. Either the page you are looking for does not exist or an error occurred while trying to load the page.”

Any thoughts?

There were customizations performed to the site by a knowledgeable QCodo developer. Plus, the site is WebAuth aware:
http://webauth.stanford.edu

The individual we are seeking should have intermediate to advanced knowledge in the above areas.

Please feel free to contact us with any questions.

Regardless, it's fixed now, and hopefully this time, it's fixed for good.

Any ideas on what the problem might be?

Qcodo always checks the type of data in array, if datatype specified in phpdoc ends with [].

Workaround
 @return String[]

Regards,
Attila

I have a similar problem, but I wan`t to return an array which values not objects.
For ex. an array of types generated from _type tables. (ProductType::$NameArray)

This is possible?

I tryed to use @return array - but isgenerated an exception, then @return [] - with this no exception but only null returned.

My Qcodo version is 0.4.22

Regards,
Attila

Last time I checked, most of the changes could also be applied to Qcodo...

I modified the core QControlImageBase to handle background transparency.

Here is the code:
https://github.com/snowmann/qcodo/commit/929701a93dee79b65b61ebfa37fb50ff9f79d3d5

and

https://github.com/snowmann/qcodo/commit/f12fd7ee7a3bb320c93ee1068f91659c511a7848

I know it's been a while since I've posted here... but I just wanted to give a quick “hi” to everyone, and also I wanted to start a new series of postings within the Official Blog forum that I want to begin to have:

Over the years of working with, consulting, and talking to development teams, there are common, deeper rooted questions that come up time and time again with regards to efficiently and effectively using Qcodo (as well as PHP overall) in a mature project dev cycle.  Things from architecture issues, code structure, maintenance and ongoing modularity, refactoring advice, etc... all issues that come up time and time again, especially on applications that have been up and running for months and years.

Since a lot of these things aren't really covered in any sort of in-depth tutorial (and quite frankly, since many of these things aren't really well suited for an in-depth tutorial), I figure I should start blogging about them from time to time...

And so I present to you our first posting of a series known as “DevTips”.

Comparing “Type” Values Between Environments

For our first entry, I wanted to talk about something that a lot of mature Qcodo applications run into on a very regular basis.  Specifically, most development teams are running (or if you're not, you should be running) separate environments between production and development, which means that they are maintaining two distinct databases.

In general, you want to keep the two database environments in sync (e.g. if you make data model changes on dev, you should make those same changes on production when you push the updated code to production).

The tough part of course is keeping track of what changed in dev, so that you know what should be applied to production.

I'll talk about the overall data model and tips on how to keep the model, itself, in sync.  But for now, I wanted to talk specifically about the “_type” tables.

I've got a really simple CLI-based PHP script that I call typediff that can be run from any POSIX-based command line (e.g. Mac OS X, Linux, Unix, or Cygwin) which basically takes the name of two different databases.  And all it does is compare all the various type tables, and inspects the actual values stored within those type tables, in each database you specify.

Then the next step is that it does a simple “diff” on the results of both, and it shows you what type values are missing from one vs. the other.

#!/usr/local/bin/php
<?php
    if (($_SERVER['argc'] != 3) && ($_SERVER['argc'] != 4)) {
        print ('usage: typediff FROM_DB TO_DB [TABLES_TO_IGNORE]' . "\r\n");
        exit (1);
    }

    function ProcessDatabaseType($strDatabaseName, $strTablesToIgnoreArray) {
        $objDb = new mysqli('localhost', 'root', '', $strDatabaseName);
        $objTableResult = $objDb->query('SHOW TABLES WHERE Tables_in_' . $strDatabaseName . " LIKE '%_type';");
        
        $strToReturn = null;

        while ($objTableRow = $objTableResult->fetch_array()) {
            $strTableName = $objTableRow['Tables_in_' . $strDatabaseName];
            if (!array_key_exists(strtolower($strTableName), $strTablesToIgnoreArray)) {
                $objResult = $objDb->query('SELECT * FROM ' . $strTableName . ' ORDER BY id;');
                while ($objRow = $objResult->fetch_array()) {
                    $strToReturn .= sprintf('%s[%s] = "%s"' . "\r\n",
                        $strTableName,
                        $objRow['id'],
                        $objRow['name']);
                }
            }
        }

        return $strToReturn;
    }

    // Should we ignore any tables?
    $strTablesToIgnoreArray = array();
    if (array_key_exists(3, $_SERVER['argv'])) {
        foreach (explode(',', $_SERVER['argv'][3]) as $strTableName)
            $strTablesToIgnoreArray[strtolower($strTableName)] = true;
    }

    file_put_contents('/tmp/from.sql', ProcessDatabaseType($_SERVER['argv'][1], $strTablesToIgnoreArray));
    file_put_contents('/tmp/to.sql', ProcessDatabaseType($_SERVER['argv'][2], $strTablesToIgnoreArray));
    passthru('diff /tmp/from.sql /tmp/to.sql');
?>

A few assumptions: you have your PHP cli executable located in /usr/local/bin/php (see line #1) and you have the CLI tool diff installed on your local machine.  Also, it assumes that you are accessing the database via localhost, using “root” as the username and no password.

A tool like this can help when you do a build/release to production to ensure your type tables are up to date on production as what you were developing against on dev.  A typical approach would be to get the latest copy of your production database locally onto your machine in dev, and then run the typediff between your local copy of prod and your local dev instance, and you should see the differences.

From there, it should be pretty simple/straightforward to write up a little SQL script to perform any INSERTs, UPDATEs or DELETEs in order to get your prod to match what you have in dev.

Hopefully this quick little utility will help folks when trying to deal with simply knowing what the differences are within the “_type” tables on two difference versions of the same database.

As always, please post with any comments or suggestions.

The bug is when using ajax file uploads (for example a modified QFileAsset) together with a normal serveraction for form. Your patch modify form target to the id of the iframe that you dynamically create and the file upload goes just fine. The problem is when submit later the form with standard serveraction. The form has left to that target, but iframe is already deleted, so it submits in a new page, etc. So, my solution was very simple:

                var bkTarget = objForm.target;
                objForm.target = id;
                objForm.submit();
                objForm.target = bkTarget;

Hope it will help someone.

       //$this->objForm->RenderBegin(false);
       //$this->objForm->RenderEnd(false);

-> WORKING

Best Regards,
tronics

Using query cursor instead of query array does not reduce the time significantly.

Package problem (0.4.22 - apparently not) or common mistake renaming ?

The code below for some reason caused the problems I was having:

<body>
   <div id=“main-container”>            
       <div id=“top-panel”>
       <?php $this->RenderBegin(); ?>

To solve it required moving RenderBegin() to immediately below the body tag as follows:

<body>
   <?php $this->RenderBegin(); ?>
   <div id=“main-container”>            
      <div id=“top-panel”>

I don't confess to understand why but problem solved.
Mike

The QRadioButtonList is on a panel separate to the datagrid. When the page first loads it populates the radiobuttonlist using the same action that the DataGrid items use to populate it.

This works fine but when a different item is selected in the DataGrid although the list correctly updates showing a new set of radio items the radiobuttonlist always returns null as the selectedvalue. The values of each radioitem are correctly set.
Mike