<?php defined('C5_EXECUTE') or die(_("Access Denied."));?>
<h1>Content Import test</h1>
<div>
<?php if ($_POST['begin']) {
 
// section handle and page under which the imported pages will be added
$section_handle = $_POST['handle']; //handle (page type)
$section_ID = $_POST['section_ID']; //page ID
$data_query = $_POST['sql_query']; //query
$limit = intval($_POST['limit']); // Total records limit
$offset = intval($_POST['offset']); // Starting from record number
 
$articles = Page::getByID($section_ID);
$collection_type = CollectionType::getByHandle($section_handle);
 
$db = Loader::db();
$rs = $db->execute($data_query." limit $offset,$limit");
 $i=1;
if ($rs) {
  while ($arr = $rs->FetchRow()) {
   $data = array();
 
      $data['name'] = $arr['title'];
      $data['cDescription'] = $arr['brief'];
 
      $article = $articles->add($collection_type, $data);
 
      //$article->setAttribute('attibutename',value);
 
      $bt = BlockType::getByHandle('content');
      $data = array();
      $data['content']  = $arr['body'];
      //echo "Adding: $i -".$arr['title']."<br/>";
      try {
         $article->addBlock($bt, "Main", $data);
      }
      catch (Exception $e) {
         //echo "Some error...<br/>";
   echo "Exception : ",$e->getMessage(),"\n";
      }
   echo "Added Page : ".$arr['title']."<br/>";
      $i++;
   } 
}
}//when form is posted
 
 
$fh = Loader::helper('form');
echo <<<EOF
      <form method="post" action="{$this->action('')}">
         <fieldset>
            <legend>Migration Info</legend>
            <br/>Sql Query(return <b>title,Description, body</b>):<br/> {$fh->textarea('sql_query')}
            <br/>Section ID: {$fh->text('section_ID')}
            <br/>Section Handle: {$fh->text('handle')}
            <br/>Record limit: {$fh->text('limit',100)}
            <br/>Record offset: {$fh->text('offset',0)}
            {$fh->submit('submit','Do Import')}
            {$fh->hidden('begin',true)}
         </fieldset>
      </form> 
 
EOF;
?>
</div>