第 5 回 Agavi アプリケーションにページング機能、ファイルのアップロード機能、そしてカスタム入力バリデーターを追加する

<h3>View All Listings</h3>
<?php if (count($t['records']) == 0): ?>
No records available
<?php else: ?>

<div id="list">
  <form action="<?php echo $ro->gen('admin.listing.delete'); ?>" method="post" >
  <table cellspacing="5">
    <tr>
      <td class="key"></td>
      <td class="key"></td>
      <td class="key">Submission Date 
        <a href="<?php echo $ro->gen('admin.listing.index', 
         array('s' => 'RecordDate', 'd' => 'asc')); ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index', 
         array('s' => 'RecordDate', 'd' => 'desc')); ?>">&dArr;</a>
      </td>
      <td class="key">Manufacturer
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleManufacturerID', 'd' => 'asc')); 
         ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleManufacturerID', 'd' => 'desc')); 
         ?>">&dArr;</a>
      </td>
      <td class="key">Model
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleModel', 'd' => 'asc')); 
         ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleModel', 'd' => 'desc')); 
         ?>">&dArr;</a>
      </td>
      <td class="key">Year
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleYear', 'd' => 'asc')); ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleYear', 'd' => 'desc')); 
         ?>">&dArr;</a>
      </td>
      <td class="key">Mileage
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleMileage', 'd' => 'asc')); 
         ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleMileage', 'd' => 'desc')); 
         ?>">&dArr;</a>
      </td>
      <td class="key">Color
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleColor', 'd' => 'asc')); 
         ?>">&uArr;</a> 
        <a href="<?php echo $ro->gen('admin.listing.index',
         array('s' => 'VehicleColor', 'd' => 'desc')); 
         ?>">&dArr;</a>
      </td>
      <td class="key"></td>
    </tr>  
    <?php foreach ($t['records'] as $record): ?>
    <tr>
      <td><input type="checkbox" name="id[]"
       value="<?php echo $record['RecordID']; ?>" style="width:2px" />
      </td>
      <td><?php echo $record['RecordID']; ?></td>
      <td><?php echo date('d M Y', strtotime($record['RecordDate'])); ?>
      </td>
      <td><?php echo $record['Manufacturer']['ManufacturerName']; ?>
      </td>
      <td><?php echo $record['VehicleModel']; ?></td>
      <td><?php echo $record['VehicleYear']; ?></td>
      <td><?php echo $record['VehicleMileage']; ?></td>
      <td><?php echo $record['VehicleColor']; ?></td>
      <td><a href="<?php echo $ro->gen('admin.listing.edit',
       array('id' => $record['RecordID'])); ?>">Edit</a></td>
    </tr>  
    <?php endforeach; ?>
    <tr>
      <td colspan="9"><input type="submit" name="submit" 
       style="width:150px" value="Delete Selected" /></td>
    </tr>    
  </table>  
  </form>
</div>
<?php endif; ?>

<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations
  xmlns="http://agavi.org/agavi/config/parts/validators/1.0"
  xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0"
  parent="%core.module_dir%/Listing/config/validators.xml"
>
  <ae:configuration>
    
    <validators method="read">
      <validator class="inarray">
        <arguments>
          <argument>s</argument>
        </arguments>
        <errors>
          <error>ERROR: Invalid sort field</error>
        </errors>
        <ae:parameters>
          <ae:parameter name="required">false</ae:parameter>
          <ae:parameter name="values">RecordID,RecordDate,
           VehicleManufacturerID,VehicleModel,
           VehicleColor,VehicleYear,VehicleMileage</ae:parameter>
          <ae:parameter name="sep">,</ae:parameter>
        </ae:parameters>
      </validator>    
      
      <validator class="inarray">
        <arguments>
          <argument>d</argument>
        </arguments>
        <errors>
          <error>ERROR: Invalid sort direction</error>
        </errors>
        <ae:parameters>
          <ae:parameter name="required">false</ae:parameter>
          <ae:parameter name="values">asc,desc</ae:parameter>
          <ae:parameter name="sep">,</ae:parameter>
        </ae:parameters>
      </validator>                      
    </validators>

  </ae:configuration>
</ae:configurations>

<?php
class Listing_AdminIndexAction extends WASPListingBaseAction
{
  public function getDefaultViewName()
  {
    return 'Success';
  }
  
  public function executeRead(AgaviRequestDataHolder $rd) 
  { 
    try {
      // get input variables
      $id = $rd->getParameter('id');
      $sort = $rd->isParameterValueEmpty('s') ? 
       'RecordID' : $rd->getParameter('s');
      $dir = $rd->isParameterValueEmpty('d') ? 
       'asc' : $rd->getParameter('d');

      // create query
      $q = Doctrine_Query::create()
            ->from('Listing l')
            ->leftJoin('l.Manufacturer m')
            ->leftJoin('l.Country c')
            ->orderBy(sprintf('%s %s', $sort, $dir));
      $result = $q->fetchArray();
      
      // set view variables
      $this->setAttribute('records', $result);
      return 'Success';
    } catch (Exception $e) {
      $this->setAttribute('error', $e->getMessage());  
      return 'Error';
    }
  }
  
  final public function isSecure()
  {
    return true;
  }       
}
?>

<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations
  xmlns="http://agavi.org/agavi/config/parts/validators/1.0"
  xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0"
  parent="%core.module_dir%/Listing/config/validators.xml"
>
  <ae:configuration>
    
    <validators method="read">
      ...

      <validator class="number">
        <arguments>
          <argument>p</argument>
        </arguments>
        <errors>
          <error>ERROR: Invalid page number</error>
        </errors>
        <ae:parameters>
          <ae:parameter name="type">int</ae:parameter>
          <ae:parameter name="required">false</ae:parameter>
          <ae:parameter name="min">1</ae:parameter>
        </ae:parameters>
      </validator>                        
    </validators>
    
  </ae:configuration>
</ae:configurations>

<?php
class Listing_AdminIndexAction extends WASPListingBaseAction
{
  public function getDefaultViewName()
  {
    return 'Success';
  }
  
  public function executeRead(AgaviRequestDataHolder $rd) 
  { 
    try {
      // get input variables
      $id = $rd->getParameter('id');
      $sort = $rd->isParameterValueEmpty('s') 
       ? 'RecordID' : $rd->getParameter('s');
      $dir = $rd->isParameterValueEmpty('d') 
       ? 'asc' : $rd->getParameter('d');
      $page = $rd->getParameter('p');      

      // create query
      $q = Doctrine_Query::create()
            ->from('Listing l')
            ->leftJoin('l.Manufacturer m')
            ->leftJoin('l.Country c')
            ->orderBy(sprintf('%s %s', $sort, $dir));
            
      // set pager parameters
      $perPage = 5;
      $numPageLinks = 5;      
      
      // initialize pager
      $pager = new Doctrine_Pager($q, $page, $perPage);
      // execute paged query
      $result = $pager->execute(array(), Doctrine::HYDRATE_ARRAY);            
       
      // initialize pager layout
      $pagerRange = new Doctrine_Pager_Range_Sliding(
       array('chunk' => $numPageLinks), $pager
      );
      $pagerUrlBase = $this->getContext()->getRouting()->gen(
       'admin.listing.index', array('s' => $sort, 'd' => $dir)
      );
      $pagerLayout = new Doctrine_Pager_Layout($pager, $pagerRange, $pagerUrlBase);
      
      // set page link display template
      $pagerLayout->setTemplate(
       '<a href="{%url}&p={%page}">{%page}</a>'
      );
      $pagerLayout->setSelectedTemplate('{%page}');      
      $pagerLayout->setSeparatorTemplate('&nbsp;');
      
      // set view variables
      $this->setAttribute('records', $result);
      $this->setAttribute('pages', $pagerLayout->display(null, true));
      return 'Success';
    } catch (Exception $e) {
      $this->setAttribute('error', $e->getMessage());  
      return 'Error';
    }
  }
  
  final public function isSecure()
  {
    return true;
  }       
}
?>

<h3>View All Listings</h3>
<?php if (count($t['records']) == 0): ?>
No records available
<?php else: ?>

<div class="pager">
  Pages: <?php echo $t['pages']; ?>
</div>

<div id="list">
...
</div>
<?php endif; ?>

<div class="pager">
  Pages: <?php echo $t['pages']; ?>
</div>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
  ...
  </head>
  <body>

    <!-- begin header -->
    <div id="header">
      <div id="logo">
        <img src="/images/logo-admin.jpg" />
      </div>
      <div id="menu">
      <?php if($this->getContext()->getUser()->isAuthenticated()): ?>
      <ul>
        <li><a href="<?php echo $ro->gen('admin.listing.index'); ?>"
         >Listings</a></li>
        <li><a href="<?php echo $ro->gen('admin.logout'); ?>"
         >Log Out</a></li>
      </ul>
      <?php endif; ?>
      </div>
    </div>
    <!-- end header -->
    
    <!-- begin body -->
    ...
    <!-- end body -->
    
    <!-- begin footer -->
    ...
    <!-- end footer -->
  </body>
</html>

<?php
class Default_LoginAction extends WASPDefaultBaseAction
{

  public function getDefaultViewName()
  {
    return 'Input';
  }
  
  public function executeWrite(AgaviRequestDataHolder $rd)
  {
    try {
      // get input parameters
      $u = $rd->getParameter('username');
      $p = $rd->getParameter('password');
      
      // check user credentials
      $q = Doctrine_Query::create()
            ->from('User u')
            ->where('u.Username = ? AND u.Password = PASSWORD(?)', array($u,$p));
      $result = $q->fetchArray();
        
      // set authentication flag if valid
      if (count($result) == 1) {
        $this->getContext()->getUser()->setAuthenticated(true);
        $this->getContext()->getUser()->setAttribute('username', 
         $u, 'wasp.user.namespace'); 
        return 'Success';
      } else {
        return 'Error';
      }
    } catch (Exception $e) {
        return 'Error';        
    }
  }

}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
  <head>
  ...
  </head>
  <body>
    <!-- begin header -->
    ...
    <!-- end header -->
    
    <!-- begin body -->
    <div id="body"> 
      <?php if($this->getContext()->getUser()->isAuthenticated()): ?>
      Logged in as: 
      <?php echo $this->getContext()->getUser()->getAttribute('username', 
       'wasp.user.namespace'); ?>
      <?php endif; ?>
      <?php echo $inner; ?>
    </div>
    <!-- end body -->
    
    <!-- begin footer -->
    ...
    <!-- end footer -->
  </body>
</html>

shell> cd /usr/local/apache/htdocs/wasp/pub
shell> mkdir usr

<script src="/js/form.js"></script>
<h3>Add Listing</h3>
<form action="<?php echo $ro->gen(null); ?>" method="post" 
 enctype="multipart/form-data">
  ...	
<fieldset>  
    <legend>Vehicle Images</legend>
    <label for="Images[1]">Image #1:</label>
    <input id="Images[1]" type="file" name="Images[1]" />
    <p/>
    <label for="Images[2]">Image #2:</label>
    <input id="Images[2]" type="file" name="Images[2]" />
    <p/>
    <label for="Images[3]">Image #3:</label>
    <input id="Images[3]" type="file" name="Images[3]" />
    <p/>
    <p class="note">
      <em>Images should be 200x125 px, <br/> JPEG or GIF format only.
      </em>
    </p>
  </fieldset>
	
  <input type="submit" name="submit" class="submit" value="Submit Listing" />
</form>

<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations
  xmlns="http://agavi.org/agavi/config/parts/validators/1.0"
  xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0"
  parent="%core.module_dir%/Listing/config/validators.xml"
>
  <ae:configuration>
    
    <validators method="write">
      ...
      <validator class="imagefile">
        <arguments base="Images[]">
          <argument/>
        </arguments>
        <errors>
          <error for="no_image">ERROR: Uploaded file is not an image</error>
          <error for="format">ERROR: Image file format is invalid</error>
          <error>ERROR: Image size is incorrect</error>
        </errors>
        <ae:parameters>
          <ae:parameter name="required">false</ae:parameter>
          <ae:parameter name="format">gif jpeg</ae:parameter>
          <ae:parameter name="min_width">200</ae:parameter>
          <ae:parameter name="max_width">200</ae:parameter>
          <ae:parameter name="min_height">125</ae:parameter>
          <ae:parameter name="max_height">125</ae:parameter>
        </ae:parameters>
      </validator>
    </validators>
    
  </ae:configuration>
</ae:configurations>

<?php
class Listing_CreateAction extends WASPListingBaseAction
{
  public function getDefaultViewName()
  {
    return 'Input';
  }
  
  public function executeWrite(AgaviRequestDataHolder $rd)
  {    
    try {
      // initialize object
      $listing = new Listing();
      
      // populate with validated input
      $listing->fromArray($rd->getParameters());      
      $listing->VehicleAccessoryBit = 
       array_sum($rd->getParameter('VehicleAccessoryBit'));

      // set some values manually
      $listing->RecordDate = date('Y-m-d', mktime());
      $listing->DisplayStatus = 0;
      
      // save record and get record ID
      $listing->save();
      $id = $listing->RecordID;   
      
      // rename and move uploaded images
      $target = AgaviConfig::get('core.app_dir') . '/../pub/usr/';
      $x = 1;
      foreach ($rd->getFile('Images') as $file) {
        switch ($file->getType()) {
          case 'image/jpeg':
          case 'image/pjpeg':
            $name = sprintf('%d_%d', $id, $x) . '.jpg';
            $file->move("$target/$name");
            break;
          case 'image/gif':
            $name = sprintf('%d_%d', $id, $x) . '.gif';
            $file->move("$target/$name");
            break;
        }
        $x++;
      }  
               
      return 'Success';
    } catch (Exception $e) {    
      $this->setAttribute('error', $e->getMessage());  
      return 'Error';
    }
  }
}
?>

<h3>
 FOR SALE: <?php printf('%d %s %s (%s)', $t['listing']['VehicleYear'], 
 $t['listing']['Manufacturer']['ManufacturerName'], 
 ucwords(strtolower($t['listing']['VehicleModel'])), 
 ucwords(strtolower($t['listing']['VehicleColor']))); ?>
</h3>

  <div id="container">    
    <div id="gallery">
      <?php $id = $t['listing']['RecordID']; ?>
      <?php $target = AgaviConfig::get('core.app_dir') . '/../pub/usr/'; ?>
      <?php foreach (glob($target.$id.'_*.{gif,jpg}', GLOB_BRACE) as $file): ?>
      <img width="200" height="125" src="/usr/<?php echo basename($file); ?>" 
       style="float:left"/>
      <p/>&nbsp;<p/>
      <?php endforeach; ?>
    </div>
    <div id="specs">
      <table cellspacing="5">
      ...
      </table>
  </div>
</div>

<?php
class Listing_AdminDeleteAction extends WASPListingBaseAction
{
  public function getDefaultViewName()
  {
    return 'Success';
  }
  
  public function executeWrite(AgaviRequestDataHolder $rd)
  {
    try {
      // get record ids
      $ids = $rd->getParameter('id');
      
      foreach ($ids as $id) {
        // delete record from database
        $q = Doctrine_Query::create()
              ->delete('Listing')
              ->addWhere('RecordID = ?', $id);
        $result = $q->execute();       
         
        // delete associated image files
        $target = AgaviConfig::get('core.app_dir') . '/../pub/usr/';
        foreach (glob("$target/$id_*") as $file) {
          unlink($file);
        }        
      }
      
      return 'Success';     
    } catch (Exception $e) {
      $this->setAttribute('error', $e->getMessage());  
      return 'Error';
    }
  } 
  
  final public function isSecure()
  {
    return true;
  }   
}
?>

<?php
class Listing_DisplaySuccessView extends WASPListingBaseView
{
  public function executeHtml(AgaviRequestDataHolder $rd)
  {
    $this->setupHtml($rd);
  }
  
  public function executeXml(AgaviRequestDataHolder $rd)
  {
    // get record
    $record = $this->getAttribute('listing');
    
    // create document
    $dom = new DOMDocument('1.0', 'utf-8');

    // create root element
    $root = $dom->createElementNS('http://www.melonfire.com/agavi-wasp', 
     'wasp:result');    
    $dom->appendChild($root);
    
    // import to SimpleXML for easier manipulation
    $xml = simplexml_import_dom($dom);
    
    // add nodes to XML output
    $xml->addChild('id', $record['RecordID']);
    $xml->addChild('submissionDate', $record['RecordDate']);
    $xml->addChild('manufacturer', $record['Manufacturer']['ManufacturerName']);
    $xml->addChild('model', ucwords(strtolower($record['VehicleModel'])));
    $xml->addChild('year', $record['VehicleYear']);
    $xml->addChild('color', strtolower($record['VehicleColor']));
    $xml->addChild('mileage', $record['VehicleMileage']);
    $xml->addChild('singleOwner', $record['VehicleIsFirstOwned']);
    $xml->addChild('certified', $record['VehicleIsCertified']);
    $xml->addChild('certifiedDate', $record['VehicleCertificationDate']);
    $xml->addChild('note', $record['Note']);
    
    $accessoryArr = array(
      '1'  => 'Power steering', 
      '2'  => 'Power windows', 
      '4'  => 'Audio system', 
      '8'  => 'Video system', 
      '16' => 'Keyless entry system',
      '32' => 'GPS',
      '64' => 'Alloy wheels'
    );
    $accessories = $xml->addChild('accessories');
    foreach ($accessoryArr as $k => $v) {
      if ($record['VehicleAccessoryBit'] & $k) {
        $accessories->addChild('item', $v);
      }
    }
    
    $price = $xml->addChild('price');
    $price->addChild('min', $record['VehicleSalePriceMin']);
    $price->addChild('max', $record['VehicleSalePriceMax']);
    $price->addChild('negotiable', $record['VehicleSalePriceIsNegotiable']);
    
    $location = $xml->addChild('location');
    $location->addChild('city', $record['OwnerCity']);
    $location->addChild('country', $record['Country']['CountryName']);        
            
    // add image information if available
    $images = $xml->addChild('images');
    $id = $record['RecordID'];
    $target = AgaviConfig::get('core.app_dir') . '/../pub/usr/';
    foreach (glob($target.$id.'_*.{gif,jpg}', GLOB_BRACE) as $file) {
      $images->addChild('image', 
       $this->getContext()->getRouting()->getBaseHref() . 
       'usr/' . basename($file));  
    }
        
    // return output
    return $xml->asXML();       
  }  
}
?>

<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations
  xmlns="http://agavi.org/agavi/config/parts/validators/1.0"
  xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0"
  parent="%core.module_dir%/Listing/config/validators.xml"
>
  <ae:configuration>
    
    <validators method="write">
      ...
 
      <validator class="PriceRangeCustomValidator">
        <arguments>        
          <argument name="max">VehicleSalePriceMax</argument>
          <argument name="min">VehicleSalePriceMin</argument>
        </arguments>
        <errors>
          <error for="max_min_mismatch">ERROR: Vehicle maximum price 
           is lower than vehicle minimum price</error>
        </errors>
        <ae:parameters>
          <ae:parameter name="required">true</ae:parameter>
        </ae:parameters>
      </validator>               
    </validators>    
  </ae:configuration>
</ae:configurations>

<?php
class PriceRangeCustomValidator extends AgaviValidator {

  protected function validate()
  {
    $args = $this->getArguments();
    $max = $this->getData($args['max']); 
    $min = $this->getData($args['min']);
    if ($min > $max)
    {
        $this->throwError('max_min_mismatch');
        return false;
    }        
    return true;
  }

}
?>

<?xml version="1.0" encoding="UTF-8"?>
<ae:configurations xmlns="http://agavi.org/agavi/config/parts/autoload/1.0" 
 xmlns:ae="http://agavi.org/agavi/config/global/envelope/1.0" 
 parent="%core.system_config_dir%/autoload.xml">
  <ae:configuration>
    
    <autoload name="WASPBaseAction">
    %core.lib_dir%/action/WASPBaseAction.class.php
    </autoload>
    <autoload name="WASPBaseModel">
    %core.lib_dir%/model/WASPBaseModel.class.php
    </autoload>
    <autoload name="WASPBaseView">
    %core.lib_dir%/view/WASPBaseView.class.php
    </autoload>
    <autoload name="Doctrine">
    %core.app_dir%/../libs/doctrine/Doctrine.php
    </autoload>
    <autoload name="PriceRangeCustomValidator">
    %core.lib_dir%/validator/PriceRangeCustomValidator.class.php
    </autoload>
    
  </ae:configuration>
</ae:configurations>

<?php
/**
 * The base view from which all Listing module views inherit.
 */
class WASPListingBaseView extends WASPBaseView
{
  // set values from selection lists
  function setInputViewAttributes() {
    $q = Doctrine_Query::create()
          ->from('Country c');    
    $this->setAttribute('countries', $q->fetchArray());
    
    $q = Doctrine_Query::create()
          ->from('Manufacturer m');
    $this->setAttribute('manufacturers', $q->fetchArray());
    
    $q = Doctrine_Query::create()
          ->select('DISTINCT l.VehicleModel AS VehicleModel')
          ->from('Listing l');
    $this->setAttribute('models', $q->fetchArray());           
  }  
}
?>

<script src="/js/form.js"></script>
<h3>Add Listing</h3>
<form action="<?php echo $ro->gen(null); ?>" method="post">
    ...    
    <label for="VehicleModel" class="required">Model:</label>
    <input id="VehicleModel" type="text" name="VehicleModel">
      <div id="ac1" class="yui-skin-sam yui-ac-container" 
       style="position:relative; width:300px; margin-left:210px">
      </div> 
    </input>
    <p/>
    ...
</form>

<!-- YUI autocomplete widget -->
<!-- based on example at 
http://developer.yahoo.com/yui/examples/autocomplete/ac_basic_array.html 
-->
<script src="js/yui/yahoo-min.js"></script> 
<script src="js/yui/dom-min.js"></script> 
<script src="js/yui/event-min.js"></script> 
<script src="js/yui/datasource-min.js"></script> 
<script src="js/yui/autocomplete-min.js"></script> 
<script>        
arrayModels = [ 
<?php if (isset($t['models']) && count($t['models']) > 0): ?>
<?php foreach ($t['models'] as $m): ?>
<?php echo "\"" . $m['VehicleModel'] . "\",\r\n"; ?>
<?php endforeach; ?>
<?php endif; ?>
];       
YAHOO.example.BasicLocal = function() {
  // Use a LocalDataSource
  var oDS = new YAHOO.util.LocalDataSource(arrayModels);

  // Instantiate the AutoCompletes
  var oAC = new YAHOO.widget.AutoComplete("VehicleModel", "ac1", oDS);
  oAC.prehighlightClassName = "yui-ac-prehighlight";
  
  return {
      oDS: oDS,
      oAC: oAC,
  };
}();
</script>