PageRenderTime 61ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 1ms

/common/lib/Form/Class.ImportView.inc.php

https://github.com/xrg/a2billing
PHP | 1061 lines | 904 code | 109 blank | 48 comment | 110 complexity | 577655ca8305145bad0d3184dad5a110 MD5 | raw file
Possible License(s): AGPL-1.0 
    

  1. <?php
    2. 

  2. 

  3. require_once("Class.FormViews.inc.php");
    4. 

  4. 

  5. 	/** Upload View! Set this up to enable importing CSV data into entity.
    6. 

    7. 

  7. 	*/
    8. 

  8. 

  9. //TODO: use $form->prefix for fields
    10. 

  10. //TODO: Locales!!
    11. 

  11. 

  12. 

  13. class AskImportView extends FormView {
    14. 

  14. 	public $common = array();	///< Common fields, for which add-style elements appear
    15. 

  15. 	public $mandatory = array();	///< Mandatory fields to import
    16. 

  16. 	public $optional = array();	///< Optional fields
    17. 

  17. 	public $multiple = array();
    18. 

  18. 	public $distinct = true;
    19. 

  19. 	public $multi_sep = '|';
    20. 

  20. 	public $delimiter = ';';
    21. 

  21. 	public $csvmode = true; ///< Defines some behaviour, like optional fields.
    22. 

  22. 	public $fmtcomment;	///< The text describing the import format.
    23. 

  23. 	public $bodyfield;	///< For mail mode, the body field
    24. 

  24. 

  25. 	function RenderHead(){
    26. 

  26. 	?>
    27. 

  27. <script type="text/javascript">
    28. 

  28. // <!--
    29. 

  29. 

  30. function MM_openBrWindow(theURL,winName,features) { //v2.0
    31. 

  31.   window.open(theURL,winName,features);
    32. 

  32. }
    33. 

  33. 

  34. function importValidate(tform){
    35. 

  35. 	if (tform.the_file.value.length < 2){
    36. 

  36. 		alert ('<?= _("Please, you must first select a file !") ?>');
    37. 

  37. 		tform.the_file.focus ();
    38. 

  38. 		return false;
    39. 

  39. 	}
    40. 

  40. }
    41. 

  41. 

  42. //-->
    43. 

  43. </script>
    44. 

  44. 

  45. 

  46. <script language="JavaScript" type="text/javascript">
    47. 

  47. <!--
    48. 

  48. function deselectHeaders(tform)
    49. 

  49. {
    50. 

  50. //     tform.unselected_search_sources[0].selected = false;
    51. 

  51. //     tform.prefs.selected_search_sources[0].selected = false;
    52. 

  52. }
    53. 

  53. 

  54. function resetHidden(tform)
    55. 

  55. {
    56. 

  56.     var tmp = '';
    57. 

  57.     for (i = 0; i < tform.selected_search_sources.length; i++) {
    58. 

  58.         tmp += tform.selected_search_sources[i].value;
    59. 

  59.         if (i < tform.selected_search_sources.length - 1)
    60. 

  60.             tmp += ":";
    61. 

  61.     }
    62. 

  62. 

  63.     tform.search_sources.value = tmp;
    64. 

  64. }
    65. 

  65. 

  66. function addSource(tform)
    67. 

  67. {
    68. 

  68.     for (i = 0; i < tform.unselected_search_sources.length; i++) {
    69. 

  69.         if (tform.unselected_search_sources[i].selected) {
    70. 

  70.             tform.selected_search_sources[tform.selected_search_sources.length] = new Option(tform.unselected_search_sources[i].text, tform.unselected_search_sources[i].value);
    71. 

  71.             tform.unselected_search_sources[i] = null;
    72. 

  72.             i--;
    73. 

  73.         }
    74. 

  74.     }
    75. 

  75. 

  76.     resetHidden(tform);
    77. 

  77. }
    78. 

  78. 

  79. function removeSource(tform)
    80. 

  80. {
    81. 

  81.     for (i = 0; i < tform.selected_search_sources.length; i++) {
    82. 

  82.         if (tform.selected_search_sources[i].selected) {
    83. 

  83.             tform.unselected_search_sources[tform.unselected_search_sources.length] = new Option(tform.selected_search_sources[i].text, tform.selected_search_sources[i].value)
    84. 

  84.             tform.selected_search_sources[i] = null;
    85. 

  85.             i--;
    86. 

  86.         }
    87. 

  87.     }
    88. 

  88. 

  89.     resetHidden(tform);
    90. 

  90. }
    91. 

  91. 

  92. function moveSourceUp(tform)
    93. 

  93. {
    94. 

  94.     var sel = tform.selected_search_sources.selectedIndex;
    95. 

  95. 	//var sel = tform["selected_search_sources[]"].selectedIndex;
    96. 

  96. 	
    97. 

  97.     if (sel == -1 || tform.selected_search_sources.length <= 1) return;
    98. 

  98. 

  99.     // deselect everything but the first selected item
    100. 

  100.     tform.selected_search_sources.selectedIndex = sel;
    101. 

  101. 

  102.     if (sel == 1) {
    103. 

  103.         tmp = tform.selected_search_sources[sel];
    104. 

  104.         tform.selected_search_sources[sel] = null;
    105. 

  105.         tform.selected_search_sources[tform.selected_search_sources.length] = tmp;
    106. 

  106.         tform.selected_search_sources.selectedIndex = tform.selected_search_sources.length - 1;
    107. 

  107.     } else {
    108. 

  108.         tmp = new Array();
    109. 

  109. 

  110.         for (i = 1; i < tform.selected_search_sources.length; i++) {
    111. 

  111.             tmp[i - 1] = new Option(tform.selected_search_sources[i].text, tform.selected_search_sources[i].value)
    112. 

  112.         }
    113. 

  113. 

  114.         for (i = 0; i < tmp.length; i++) {
    115. 

  115.             if (i + 1 == sel - 1) {
    116. 

  116.                 tform.selected_search_sources[i + 1] = tmp[i + 1];
    117. 

  117.             } else if (i + 1 == sel) {
    118. 

  118.                 tform.selected_search_sources[i + 1] = tmp[i - 1];
    119. 

  119.             } else {
    120. 

  120.                 tform.selected_search_sources[i + 1] = tmp[i];
    121. 

  121.             }
    122. 

  122.         }
    123. 

  123. 

  124.         tform.selected_search_sources.selectedIndex = sel - 1;
    125. 

  125.     }
    126. 

  126. 

  127.     resetHidden(tform);
    128. 

  128. }
    129. 

  129. 

  130. function moveSourceDown(tform)
    131. 

  131. {
    132. 

  132.     var sel = tform.selected_search_sources.selectedIndex;
    133. 

  133. 

  134.     if (sel == -1 || tform.selected_search_sources.length <= 1) return;
    135. 

  135. 

  136.     // deselect everything but the first selected item
    137. 

  137.     tform.selected_search_sources.selectedIndex = sel;
    138. 

  138. 

  139.     if (sel == tform.selected_search_sources.length - 1) {
    140. 

  140.         tmp = new Array();
    141. 

  141. 

  142.         for (i = 1; i < tform.selected_search_sources.length; i++) {
    143. 

  143.             tmp[i - 1] = new Option(tform.selected_search_sources[i].text, tform.selected_search_sources[i].value)
    144. 

  144.         }
    145. 

  145. 

  146.         tform.selected_search_sources[1] = tmp[tmp.length - 1];
    147. 

  147.         for (i = 0; i < tmp.length - 1; i++) {
    148. 

  148.             tform.selected_search_sources[i + 2] = tmp[i];
    149. 

  149.         }
    150. 

  150. 

  151.         tform.selected_search_sources.selectedIndex = 1;
    152. 

  152.     } else {
    153. 

  153.         tmp = new Array();
    154. 

  154. 

  155.         for (i = 1; i < tform.selected_search_sources.length; i++) {
    156. 

  156.             tmp[i - 1] = new Option(tform.selected_search_sources[i].text, tform.selected_search_sources[i].value)
    157. 

  157.         }
    158. 

  158. 

  159.         for (i = 0; i < tmp.length; i++) {
    160. 

  160.             if (i + 1 == sel) {
    161. 

  161.                 tform.selected_search_sources[i + 1] = tmp[i + 1];
    162. 

  162.             } else if (i + 1 == sel + 1) {
    163. 

  163.                 tform.selected_search_sources[i + 1] = tmp[i - 1];
    164. 

  164.             } else {
    165. 

  165.                 tform.selected_search_sources[i + 1] = tmp[i];
    166. 

  166.             }
    167. 

  167.         }
    168. 

  168. 

  169.         tform.selected_search_sources.selectedIndex = sel + 1;
    170. 

  170.     }
    171. 

  171. 

  172.     resetHidden(tform);
    173. 

  173. }
    174. 

  174. 

  175. 

  176. // -->
    177. 

  177. </script>
    178. 

  178. 

  179. <?php
    180. 

  180. 	} //end function
    181. 

  181. 	
    182. 

  182. 	function Render(&$form){
    183. 

  183. 		$this->RenderHead();
    184. 

  184. 		
    185. 

  185. 		if (empty($this->fmtcomment) &&($this->csvmode)){
    186. 

  186. 			$this->fmtcomment = str_params( _("Use the example below to format the CSV file. Fields are separated by '%1' , </br>".
    187. 

  187. 			    ". and , are used for decimal format."),
    188. 

  188. 			    array($this->delimiter),1);
    189. 

  189. 		}
    190. 

  190. 		if ($this->csvmode)
    191. 

  191. 			$impMsg= str_params(_("New %1 have to be imported from a CSV file."),
    192. 

  192. 				array($form->model_name),1);
    193. 

  193. 		else
    194. 

  194. 			$impMsg= str_params(_("New %1 have to be imported from a file."),
    195. 

  195. 				array($form->model_name),1);
    196. 

  196. 		
    197. 

  197. 		$fldIndex = array();
    198. 

  198. 		foreach ($form->model as $key => $fld)
    199. 

  199. 			if ($fld->fieldname)
    200. 

  200. 				$fldIndex[$fld->fieldname]=$key;
    201. 

  201. 		
    202. 

  202. 		$formname = $form->prefix .'Imp' ;
    203. 

  203. 		?>
    204. 

  204. 	<div class='impMsg'><?= $impMsg ?>
    205. 

  205. 	</div>
    206. 

  206. 	
    207. 

  207. 	<table cellspacing="2" align="center" class="importForm">
    208. 

  208. 	<form name="<?= $formname ?>" enctype="multipart/form-data" action="<?= $_SERVER['PHP_SELF']?>" method="post" onsubmit="return importValidate(this)">
    209. 

  209. 	<input type="hidden" name="action" value="import-analyze">
    210. 

  210. 	<?php if (count($this->common)){ ?>
    211. 

  211. 		<tr> <td colspan="3" align=center class='title'> <?= _("Common fields");?></td></tr>
    212. 

  212. 	<?php		foreach($this->common as $fldname) {
    213. 

  213. 				$fld = &$form->model[$fldIndex[$fldname]];
    214. 

  214. 	?><tr><td class='field'><?php $fld->RenderAddTitle($form) ?></td>
    215. 

  215. 		<td colspan="2" class='value'><?php $fld->DispAdd($form);?> </td>
    216. 

  216. 	</tr>
    217. 

  217. 	<?php		}
    218. 

  218. 		}
    219. 

  219. 		
    220. 

  220. 		if (count($this->mandatory)){ ?>
    221. 

  221. 		<tr> <td colspan="3" align=center class='title'> <?= _("Mandatory fields");?></td></tr>
    222. 

  222. 	<?php		foreach($this->mandatory as $fldname) {
    223. 

  223. 				if ((!$this->csvmode) && $fldname == $this->bodyfield)
    224. 

  224. 					continue;
    225. 

  225. 				$fld = &$form->model[$fldIndex[$fldname]];
    226. 

  226. 		?><tr><td class='field'><?php $fld->RenderAddTitle($form) ?></td>
    227. 

  227. 		<td class='value'><?php if (!$this->csvmode) echo ucfirst($fldname); ?></td>
    228. 

  228. 		<td class='value'><div class="descr"><?= $fld->editDescr?></div></td>
    229. 

  229. 	</tr>
    230. 

  230. 	<?php		}
    231. 

  231. 		}
    232. 

  232. 		
    233. 

  233. 		if (count($this->optional)){ ?>
    234. 

  234. 		<tr> <td colspan="3" align=center class='title'> <?= _("Optional fields");?></td></tr>
    235. 

  235. 		<?php	if ($this->csvmode) { ?>
    236. 

  236. 		<tr><td colspan="3" align=center>
    237. 

  237. 			<input name="search_sources" value="" type="hidden">
    238. 

  238. 			<table><tbody><tr>
    239. 

  239. 			<td><?php echo gettext("Unselected Fields...");?><br>
    240. 

  240. 				<select name="unselected_search_sources" multiple="multiple" size="<?= count($this->optional)?>" width="50" onchange="deselectHeaders(document.forms['<?= $formname?>'])">
    241. 

  241. 	<?php		foreach($this->optional as $fldname) {
    242. 

  242. 				$fld = &$form->model[$fldIndex[$fldname]]; ?>
    243. 

  243. 					<option value="<?= $fldname ?>"><?= htmlspecialchars($fld->fieldtitle) ?></option><?php
    244. 

  244. 			}
    245. 

  245. 			?>
    246. 

  246. 				</select>
    247. 

  247. 			</td>
    248. 

  248. 			<td> <a onclick="addSource(document.forms['<?= $formname?>']); return false;"><img src="./Images/forward.png" alt="<?= _("Add field")?>" title="<?= _("Add field")?>" border="0"></a>
    249. 

  249. 				<br>
    250. 

  250. 			     <a onclick="removeSource(document.forms['<?= $formname?>']); return false;"><img src="./Images/back.png" alt="<?= _("Remove field")?>" title="<?= _("Remove field")?>" border="0"></a>
    251. 

  251. 			</td>
    252. 

  252. 			<td>
    253. 

  253. 				<?= _("Selected Fields...");?><br>
    254. 

  254. 				<select name="selected_search_sources" multiple="multiple" size="<?= count($this->optional)?>" width="50" onchange="deselectHeaders(document.forms['<?= $formname?>']);">
    255. 

  255. 				</select>
    256. 

  256. 			</td>
    257. 

  257. 			<td>
    258. 

  258. 				<a onclick="moveSourceUp(document.forms['<?= $formname?>']); return false;"><img src="./Images/up_black.png" alt="<?= _("Move up")?>" title="<?= _("Move up")?>" border="0"></a>
    259. 

  259. 				<br>
    260. 

  260. 				<a onclick="moveSourceDown(document.forms['<?= $formname?>']); return false;"><img src="./Images/down_black.png" alt="<?= _("Move down")?>" title="<?= _("Move down")?>" border="0"></a>
    261. 

  261.         		</td>
    262. 

  262. 			
    263. 

  263. 			</tr>
    264. 

  264. 			</tbody></table>
    265. 

  265. 		</td></tr>
    266. 

  266. 		<?php }else  { //non-csvmode
    267. 

  267. 			foreach($this->optional as $fldname) {
    268. 

  268. 				$fld = &$form->model[$fldIndex[$fldname]];
    269. 

  269. 		?><tr><td class='field'><?php $fld->RenderAddTitle($form) ?></td>
    270. 

  270. 		<td class='value'><?php if (!$this->csvmode) echo ucfirst($fldname); ?></td>
    271. 

  271. 		<td class='value'><div class="descr"><?= $fld->editDescr?></div></td>
    272. 

  272. 	</tr>
    273. 

  273. 	<?php			}
    274. 

  274. 			}
    275. 

  275. 		}
    276. 

  276. 		
    277. 

  277. 		?>
    278. 

  278. 

  279. 		<tr> <td colspan="3" align=center class='title'> <?= _("Upload File");?></td></tr>
    280. 

  280. 		<tr> <td class="field"><?= _("File") ?></td>
    281. 

  281. 			<td colspan="2" class="value"> 
    282. 

  282. 			<p align="center"><span class="textcomment"> 
    283. 

  283. 			<?= str_params(_("The maximum file size is %1 KB"),
    284. 

  284. 					array($my_max_file_size / 1024),1) ?>
    285. 

  285. 			</span><br>
    286. 

  286. 			<input type="hidden" name="MAX_FILE_SIZE" value="<?php echo $my_max_file_size?>">
    287. 

  287. 			<input type="hidden" name="task" value="upload">
    288. 

  288. 			<input name="the_file" type="file" size="50" onFocus="this.select()" >
    289. 

  289. 			</p>
    290. 

  290. 		</td> </tr>
    291. 

  291. 		<tr><td class="field"><?= _("Submit")?></td>
    292. 

  292. 		    <td class='value' colspan="2" align='right'>
    293. 

  293. 			<input type="submit" value="<?= str_params(_("Import %1"),array($form->model_name),1) ?>" class="btnsubmit" >
    294. 

  294. 		    </td></tr>
    295. 

  295. 	
    296. 

  296. 			<?php if (count($this->examples)) {
    297. 

  297. 		?>
    298. 

  298. 		<tr> <td colspan="3" align="center">&nbsp; </td> </tr>
    299. 

  299. 		<tr> <td colspan="3" align=center class='title'> <?= _("Examples");?></td></tr>
    300. 

  300. 		<tr> <td colspan="3"> 
    301. 

  301.                     <div align="center"><span class="textcomment">
    302. 

  302. 			<?= $this->fmtcomment ?>
    303. 

  303. 			   </span>
    304. 

  304. 			<br/>
    305. 

  305. 			<?php foreach ($this->examples as $exmpl){ ?>
    306. 

  306. 				<a href="<?= $exmpl[1]?>" target="superframe"><?= $exmpl[0] ?></a> -
    307. 

  307. 			<?php  } ?>
    308. 

  308. 		    </div>
    309. 

  309. 			<iframe name="superframe" src="<?= $this->examples[0][1]?>" bgcolor="white" width=500 height=120 marginWidth=10 marginHeight=10  frameBorder=1  scrolling="auto">
    310. 

  310. 			</iframe>
    311. 

  311. 		</td> </tr>
    312. 

  312. 		<?php  } ?>
    313. 

  313. 

  314. 		</form>
    315. 

  315.             </table>
    316. 

  316. 	<?php
    317. 

  317. 	}
    318. 

  318. };
    319. 

  319. 

  320. /** This class retrieves the file and analyzes it */
    321. 

  321. class ImportAView extends FormView {
    322. 

  322. 	protected $askImport;
    323. 

  323. 	protected $movedFile;
    324. 

  324. 	protected $fields;
    325. 

  325. 	
    326. 

  326. 	public function ImportAView(AskImportView &$ai){
    327. 

  327. 		$this->askImport = &$ai;
    328. 

  328. 	}
    329. 

  329. 	
    330. 

  330. 	public function PerformAction(&$form){
    331. 

  331. 		$dbg_elem = new DbgElem();
    332. 

  332. 		$dbhandle = $form->a2billing->DBHandle();
    333. 

  333. 		
    334. 

  334. 		if ($form->FG_DEBUG>0)
    335. 

  335. 			array_unshift($form->pre_elems,$dbg_elem);
    336. 

  336. 		
    337. 

  337. 		
    338. 

  338. 		$dbg_elem->content .= print_r($_POST,true) . "\n";
    339. 

  339. 		
    340. 

  340. 		$fil = $_FILES[$form->prefix.'the_file'];
    341. 

  341. 		if (!isset($fil)){
    342. 

  342. 			$form->pre_elems[] = new ErrorElem(_("File has not been posted at all!"));
    343. 

  343. 			$form->setAction('ask-import');
    344. 

  344. 			return;
    345. 

  345. 		}
    346. 

  346. 		switch($fil['error']){
    347. 

  347. 		case UPLOAD_ERR_OK:
    348. 

  348. 			$dbg_elem->content .= "File uploaded OK.\n";
    349. 

  349. 			break;
    350. 

  350. 		case UPLOAD_ERR_INI_SIZE:
    351. 

  351. 			$form->pre_elems[] = new ErrorElem(str_params(_("File size exceeds %1 limit of the system!"),array(123),1));
    352. 

  352. 			$dbg_elem->content .="Error!\n";
    353. 

  353. 			$form->setAction('ask-import');
    354. 

  354. 			return;
    355. 

  355. 		case UPLOAD_ERR_FORM_SIZE:
    356. 

  356. 			$form->pre_elems[] = new ErrorElem(str_params(_("File size exceeds %1 limit for this action!"),array(123),1));
    357. 

  357. 			$dbg_elem->content .="Error!\n";
    358. 

  358. 			$form->setAction('ask-import');
    359. 

  359. 			return;
    360. 

  360. 		case UPLOAD_ERR_PARTIAL:
    361. 

  361. 			$form->pre_elems[] = new ErrorElem(_("The uploaded file was only partially uploaded."));
    362. 

  362. 			$dbg_elem->content .="Error!\n";
    363. 

  363. 			$form->setAction('ask-import');
    364. 

  364. 			return;
    365. 

  365. 		case UPLOAD_ERR_NO_FILE:
    366. 

  366. 			$form->pre_elems[] = new ErrorElem(_("No file was uploaded."));
    367. 

  367. 			$dbg_elem->content .="Error!\n";
    368. 

  368. 			$form->setAction('ask-import');
    369. 

  369. 			return;
    370. 

  370. 		case UPLOAD_ERR_NO_TMP_DIR:
    371. 

  371. 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    372. 

  372. 			$dbg_elem->content .="Missing a temporary folder. \n";
    373. 

  373. 			$form->setAction('ask-import');
    374. 

  374. 			return;
    375. 

  375. 		case UPLOAD_ERR_CANT_WRITE:
    376. 

  376. 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    377. 

  377. 			$dbg_elem->content .="Failed to write file to disk.\n";
    378. 

  378. 			$form->setAction('ask-import');
    379. 

  379. 			return;
    380. 

  380. 		default:
    381. 

  381. 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    382. 

  382. 			$dbg_elem->content .="Unknown error:".$fil['error']. "\n";
    383. 

  383. 			$form->setAction('ask-import');
    384. 

  384. 			return;
    385. 

  385. 		}
    386. 

  386. 		
    387. 

  387. 		if (isset($this->allowed_mimetypes) && !in_array($fil['type'],$this->allowed_mimetypes)){
    388. 

  388. 			$form->pre_elems[] = new ErrorElem(str_params(_("Cannot accept file of type %1. Allowed types are: %2."),
    389. 

  389. 							array($fil['type'],implode(', ',$this->allowed_mimetypes)),1));
    390. 

  390. 			$dbg_elem->content .="Cannot accept file type \n";
    391. 

  391. 			$form->setAction('ask-import');
    392. 

  392. 			return;
    393. 

  393. 		}
    394. 

  394. 		
    395. 

  395. 			//Now, check the given fields
    396. 

  396. 		$this->fields = $this->askImport->mandatory;
    397. 

  397. 		if($this->askImport->csvmode){
    398. 

  398. 			$optionals= explode(':',$form->getpost_dirty('search_sources'));
    399. 

  399. 			foreach ($optionals as $opt)
    400. 

  400. 				if (!empty($opt))
    401. 

  401. 				if (!in_array($opt,$this->askImport->optional)){
    402. 

  402. 					$form->pre_elems[] = new ErrorElem(_("Error in submitted form."));
    403. 

  403. 					$dbg_elem->content .= "You tried to pass $opt as a field.\n";
    404. 

  404. 					$form->setAction('ask-import');
    405. 

  405. 					return;
    406. 

  406. 				}else
    407. 

  407. 					$this->fields[] = $opt;
    408. 

  408. 		}
    409. 

  409. 		
    410. 

  410. 		$tmpdir = DynConf::GetCfg('global','upload_tmpdir','/tmp');
    411. 

  411. 		$tmpname = str_replace('/','-',basename($fil['name']));
    412. 

  412. 		$tmpname = tempnam($tmpdir,$tmpname);
    413. 

  413. 		if ($tmpname ===false) {
    414. 

  414. 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    415. 

  415. 			$dbg_elem->content .="Cannot make temp file in $tmpdir \n";
    416. 

  416. 			$form->setAction('ask-import');
    417. 

  417. 			return;
    418. 

  418. 		}
    419. 

  419. 		
    420. 

  420. 		if (move_uploaded_file($fil['tmp_name'],$tmpname)){
    421. 

  421. 			$dbg_elem->content .="moved  \"".$fil['tmp_name'] ."\" to \"". $tmpname ."\"\n";
    422. 

  422. 			$this->movedFile = $tmpname;
    423. 

  423. 		}else {
    424. 

  424. 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    425. 

  425. 			$dbg_elem->content .="Cannot move uploaded file to temporary. \n";
    426. 

  426. 			$form->setAction('ask-import');
    427. 

  427. 			return;
    428. 

  428. 		}
    429. 

  429. // 		$dbg_elem->content .="copying data from  \"".$fil['tmp_name'] ."\" to \"". $tmpname ."\"\n";
    430. 

  430. // 		$this->tmpFile = @fopen($fil['tmp_name'],'rb');
    431. 

  431. // 		if ($this->tmpFile === false){
    432. 

  432. // 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    433. 

  433. // 			$dbg_elem->content .="Cannot open uploaded file. \n";
    434. 

  434. // 			$form->setAction('ask-import');
    435. 

  435. // 			return;
    436. 

  436. // 		}
    437. 

  437. // 		
    438. 

  438. // 		$this->copyFile = fopen($tmpname,'w');
    439. 

  439. // 		if ($this->copyFile === false){
    440. 

  440. // 			$form->pre_elems[] = new ErrorElem(_("Internal error, could not upload."));
    441. 

  441. // 			$dbg_elem->content .="Cannot open copy file. \n";
    442. 

  442. // 			$form->setAction('ask-import');
    443. 

  443. // 			return;
    444. 

  444. // 		}
    445. 

  445. 

  446. 	}
    447. 

  447. 	
    448. 

  448. 	public function Render(&$form){
    449. 

  449. 		?><div class='impA-progress' name="<?= $form->prefix?>iprogress">
    450. 

  450. 			<?= _("Analyzing uploaded data...") ?>
    451. 

  451. 		<div>
    452. 

  452. 		
    453. 

  453. 		<?php
    454. 

  454. 		$fp = fopen($this->movedFile,  "r");
    455. 

  455. 		if (!$fp){
    456. 

  456. 			?><div class="error">
    457. 

  457. 				<?= _("Error: Cannot open uploaded file") ?>
    458. 

  458. 			</div>
    459. 

  459. 			<?php
    460. 

  460. 			return;
    461. 

  461. 		}
    462. 

  462. 		
    463. 

  463. 		// Construct an array of the fields to be imported,
    464. 

  464. 		// structure: $fields2[<num>] = array(<name>,<key>,<bool:!aggregate>)
    465. 

  465. 		$fldIndex = array();
    466. 

  466. 		foreach ($form->model as $key => $fld)
    467. 

  467. 			if ($fld->fieldname)
    468. 

  468. 				$fldIndex[$fld->fieldname]=$key;
    469. 

  469. 

  470. 		$fields2= array();
    471. 

  471. 		foreach($this->fields as $fld)
    472. 

  472. 			if (in_array($fld,$this->askImport->multiple))
    473. 

  473. 				$fields2[] = array($fld,$fldIndex[$fld],false);
    474. 

  474. 			else
    475. 

  475. 				$fields2[] = array($fld,$fldIndex[$fld],true);
    476. 

  476. 		
    477. 

  477. 		unset($fldIndex);
    478. 

  478. 

  479. 		?> <table cellSpacing="2" align='center' class="<?= $form->list_class?>">
    480. 

  480. 		<?php
    481. 

  481. 		
    482. 

  482. 		$this->RenderListHeads($fields2,$form);
    483. 

  483. 		
    484. 

  484. 		// echo nl2br(print_r($fields2,true));
    485. 

  485. 		$nrows = 0;
    486. 

  486. 		$delimiter = $this->askImport->delimiter;
    487. 

  487. 		$multi_sep = $this->askImport->multi_sep;
    488. 

  488. 		$max_rows = 10; //TODO
    489. 

  489. 		$last_a = null;
    490. 

  490. 		$last_b = null;
    491. 

  491. 		
    492. 

  492. 		?><tbody>
    493. 

  493. 		<?php
    494. 

  494. 		
    495. 

  495. 		while (($larr = fgetcsv($fp,4096,$delimiter))!==false){
    496. 

  496. 			if ($larr===null)
    497. 

  497. 				continue;
    498. 

  498. 			if(count($larr)<count($fields2)){
    499. 

  499. 				if ($form->FG_DEBUG)
    500. 

  500. 					echo "Less fields came!<br>\n";
    501. 

  501. 				if ($form->FG_DEBUG>2)
    502. 

  502. 					echo nl2br(print_r($larr,true). "\n");
    503. 

  503. 				break;
    504. 

  504. 			}
    505. 

  505. 			$arr_a = array();
    506. 

  506. 			$arr_b = array();
    507. 

  507. 				//split the data into 2 arrays.
    508. 

  508. 			foreach($fields2 as $fld){
    509. 

  509. 				$val = $form->model[$fld[1]]->buildValue(current($larr),$form);
    510. 

  510. 				if($fld[2])
    511. 

  511. 					$arr_a[] = $val;
    512. 

  512. 				else
    513. 

  513. 					$arr_b[] = $val;
    514. 

  514. 				next($larr);
    515. 

  515. 			}
    516. 

  516. 				//If non-multiple data matches, we reuse the line
    517. 

  517. 			if ($this->askImport->distinct && ($arr_a == $last_a)){
    518. 

  518. 				foreach($arr_b as $kb => $b)
    519. 

  519. 					$last_b[$kb] = array_merge($last_b[$kb],
    520. 

  520. 						explode($multi_sep, $b));
    521. 

  521. 			}
    522. 

  522. 			else{
    523. 

  523. 				if (!empty($last_a))
    524. 

  524. 					$this->RenderRow($fields2,$last_a,$last_b,$form);
    525. 

  525. 				$last_a = $arr_a;
    526. 

  526. 				$last_b = array();
    527. 

  527. 				foreach($arr_b as $b)
    528. 

  528. 					$last_b[] =explode($multi_sep,$b);
    529. 

  529. 				$nrows++;
    530. 

  530. 			}
    531. 

  531. 			
    532. 

  532. 			
    533. 

  533. 			if ($nrows > $max_rows)
    534. 

  534. 				break;
    535. 

  535. 			// Will actually skip the latest $last_a
    536. 

  536. 		}
    537. 

  537. 		?></tbody> </table>
    538. 

  538. 

  539. 	<form action=<?= $_SERVER['PHP_SELF']?> method=post name="<?= $form->prefix?>Imp" id="<?= $form->prefix ?>Imp">
    540. 

  540. 	<?php	// The uploaded file should never be revealed to the client. Thus, we keep that
    541. 

  541. 		// in _SESSION.
    542. 

  542. 		$_SESSION[$form->prefix.'importFile'] = $this->movedFile;
    543. 

  543. 		$_SESSION[$form->prefix.'importFields'] = implode(',',$this->fields);
    544. 

  544. 			// Also, protect against multiple uploads in the same session
    545. 

  545. 		$str ='';
    546. 

  546. 		for ($i=0;$i<6;$i++)
    547. 

  547. 			$str .= mt_rand(0,9);
    548. 

  548. 		$_SESSION[$form->prefix.'importRnd'] = $str;
    549. 

  549. 		
    550. 

  550. 		$hidden_arr = array( 'action' => 'import', 'sub_action' => '', 'rnd' => $str);
    551. 

  551. 		foreach ($this->askImport->common as $co)
    552. 

  552. 			$hidden_arr[$co] = $form->getpost_dirty($co);
    553. 

  553. 

  554. 		if (strlen($form->prefix)>0){
    555. 

  555. 			$arr2= array();
    556. 

  556. 			foreach($hidden_arr as $key => $val)
    557. 

  557. 				$arr2[$form->prefix.$key] = $val;
    558. 

  558. 			$hidden_arr = $arr2;
    559. 

  559. 		}
    560. 

  560. 

  561. 		$form->gen_PostParams($hidden_arr,true); 
    562. 

  562. 		?>
    563. 

  563. 		<button type=submit>
    564. 

  564. 		<?= str_params(_("Import these %1"),array($form->model_name),1) ?>
    565. 

  565. 		<img src="./Images/icon_arrow_orange.png" ></button>
    566. 

  566. 		</form>
    567. 

  567. 		<?php
    568. 

  568. 		
    569. 

  569. 		fclose($fp);
    570. 

  570. 	}
    571. 

  571. 	
    572. 

  572. 	protected function RenderListHeads($fields2,$form){
    573. 

  573. 		?> <thead><tr> <?php
    574. 

  574. 		foreach ($fields2 as $fld){
    575. 

  575. 			$mfld = &$form->model[$fld[1]];
    576. 

  576. 			echo "<td";
    577. 

  577. 			if ($mfld->listWidth)
    578. 

  578. 				echo ' width="'.$mfld->listWidth .'"';
    579. 

  579. 			echo '>';
    580. 

  580. 			if ($mfld->fieldacr){
    581. 

  581. 				echo '<acronym title="'.htmlspecialchars($mfld->fieldtitle).'" >';
    582. 

  582. 				echo htmlspecialchars($mfld->fieldacr);
    583. 

  583. 				echo '<acronym>';
    584. 

  584. 				
    585. 

  585. 			}else
    586. 

  586. 				echo htmlspecialchars($mfld->fieldtitle);
    587. 

  587. 			echo "</td>";
    588. 

  588. 		}
    589. 

  589. 		
    590. 

  590. 		?></tr></thead> <?php
    591. 

  591. 	}
    592. 

  592. 

  593. 	protected function RenderRow($fields2,$last_a,$last_b,&$form){
    594. 

  594. 		reset($last_a);
    595. 

  595. 		reset($last_b);
    596. 

  596. 		echo "<tr>";
    597. 

  597. 		foreach($fields2 as $fld){
    598. 

  598. 			echo "<td>";
    599. 

  599. 			$mfld = &$form->model[$fld[1]];
    600. 

  600. 			if ($fld[2]){
    601. 

  601. 				echo htmlspecialchars(current($last_a));
    602. 

  602. 				next($last_a);
    603. 

  603. 			}else{
    604. 

  604. 				echo htmlspecialchars(implode(', ',current($last_b)));
    605. 

  605. 				next($last_b);
    606. 

  606. 			}
    607. 

  607. 			echo "</td>";
    608. 

  608. 		}
    609. 

  609. 		echo "</tr>\n";
    610. 

  610. 		
    611. 

  611. 	}
    612. 

  612. };
    613. 

  613. 

  614. /** Import a file in mail-like format */
    615. 

  615. class ImportMailAView extends ImportAView {
    616. 

  616. 	public $comment_char = '#';
    617. 

  617. 	public $delim_line = '-------- Mail --------';
    618. 

  618. 	
    619. 

  619. 	public function Render(&$form){
    620. 

  620. 		?><div class='impA-progress' name="<?= $form->prefix?>iprogress">
    621. 

  621. 			<?= _("Analyzing uploaded data...") ?>
    622. 

  622. 		<div>
    623. 

  623. 		
    624. 

  624. 		<?php
    625. 

  625. 		$fp = fopen($this->movedFile,  "r");
    626. 

  626. 		if (!$fp){
    627. 

  627. 			?><div class="error">
    628. 

  628. 				<?= _("Error: Cannot open uploaded file") ?>
    629. 

  629. 			</div>
    630. 

  630. 			<?php
    631. 

  631. 			return;
    632. 

  632. 		}
    633. 

  633. 		
    634. 

  634. 		$all_fields = array();
    635. 

  635. 		foreach ($this->askImport->mandatory as $fld)
    636. 

  636. 			$all_fields[ucfirst($fld)] = $fld;
    637. 

  637. 		
    638. 

  638. 		foreach ($this->askImport->optional as $fld)
    639. 

  639. 			$all_fields[ucfirst($fld)] = $fld;
    640. 

  640. 		
    641. 

  641. 		// echo nl2br(print_r($fields2,true));
    642. 

  642. 		$nrows = 0;
    643. 

  643. 		$commentc = $this->comment_char;
    644. 

  644. 		$comment_len = strlen($this->comment_char);
    645. 

  645. 		//$multi_sep = $this->askImport->multi_sep;
    646. 

  646. 		$max_rows = 10; //TODO
    647. 

  647. 		$bodyfld=$this->askImport->bodyfield;
    648. 

  648. 		if (empty($bodyfld))
    649. 

  649. 			$bodyfld="message";
    650. 

  650. 				
    651. 

  651. 		if (!feof($fp)){	// only one, not "while"
    652. 

  652. 			$temail=array();
    653. 

  653. 			// Sub-loop: get headers
    654. 

  654. 			while (!feof($fp)){
    655. 

  655. 				$line =fgets($fp);
    656. 

  656. 				if (! $line)
    657. 

  657. 					break;
    658. 

  658. 				$line2=trim($line); // but also leave $line intact
    659. 

  659. 				if (substr($line2,0,$comment_len)== $commentc)
    660. 

  660. 					continue;
    661. 

  661. 				if (($pos=strpos($line2,':'))===false)
    662. 

  662. 					break;
    663. 

  663. 				$fld = substr($line2,0,$pos);
    664. 

  664. 				if (!isset($all_fields[$fld])){
    665. 

  665. 					if ($form->FG_DEBUG>1)
    666. 

  666. 						echo "Skipping tag \"$fld\"<br>\n";
    667. 

  667. 					continue;
    668. 

  668. 				}
    669. 

  669. 				$temail[$all_fields[$fld]] = substr($line2,$pos+1);
    670. 

  670. 			}
    671. 

  671. 			
    672. 

  672. 				// skip the first line of the message, if it's whitespace
    673. 

  673. 			if ($line && trim($line)=="")
    674. 

  674. 				$line="";
    675. 

  675. 			
    676. 

  676. 			$temail[$bodyfld] = "";
    677. 

  677. 			// Second loop: message body
    678. 

  678. 			do{
    679. 

  679. 				if ($line == '')
    680. 

  680. 					continue;
    681. 

  681. 				if ($line == $this->delim_line."\n")
    682. 

  682. 					break;
    683. 

  683. 				$temail[$bodyfld] .=$line;
    684. 

  684. 			
    685. 

  685. 			}while (($line = fgets($fp))!==false);
    686. 

  686. 			
    687. 

  687. 			if ($form->FG_DEBUG>2)
    688. 

  688. 				echo "Got one mail!\n";
    689. 

  689. 			
    690. 

  690. 			$this->RenderMail($temail,$form);
    691. 

  691. 		}
    692. 

  692. 		?>
    693. 

  693. 		
    694. 

  694. 	<form action=<?= $_SERVER['PHP_SELF']?> method=post name="<?= $form->prefix?>Imp" id="<?= $form->prefix ?>Imp">
    695. 

  695. 	<?php	// The uploaded file should never be revealed to the client. Thus, we keep that
    696. 

  696. 		// in _SESSION.
    697. 

  697. 		$_SESSION[$form->prefix.'importFile'] = $this->movedFile;
    698. 

  698. 			// Also, protect against multiple uploads in the same session
    699. 

  699. 		$str ='';
    700. 

  700. 		for ($i=0;$i<6;$i++)
    701. 

  701. 			$str .= mt_rand(0,9);
    702. 

  702. 		$_SESSION[$form->prefix.'importRnd'] = $str;
    703. 

  703. 		
    704. 

  704. 		$hidden_arr = array( 'action' => 'import', 'sub_action' => '', 'rnd' => $str);
    705. 

  705. 		foreach ($this->askImport->common as $co)
    706. 

  706. 			$hidden_arr[$co] = $form->getpost_dirty($co);
    707. 

  707. 

  708. 		if (strlen($form->prefix)>0){
    709. 

  709. 			$arr2= array();
    710. 

  710. 			foreach($hidden_arr as $key => $val)
    711. 

  711. 				$arr2[$form->prefix.$key] = $val;
    712. 

  712. 			$hidden_arr = $arr2;
    713. 

  713. 		}
    714. 

  714. 

  715. 		$form->gen_PostParams($hidden_arr,true); 
    716. 

  716. 		?>
    717. 

  717. 		<button type=submit>
    718. 

  718. 		<?= str_params(_("Import these %1"),array($form->model_name),1) ?>
    719. 

  719. 		<img src="./Images/icon_arrow_orange.png" ></button>
    720. 

  720. 		</form>
    721. 

  721. 		<?php
    722. 

  722. 		
    723. 

  723. 		fclose($fp);
    724. 

  724. 	}
    725. 

  725. 	
    726. 

  726. 	public function RenderMail($temail,$form){
    727. 

  727. 		$fldIndex = array();
    728. 

  728. 		foreach ($form->model as $key => $fld)
    729. 

  729. 			if ($fld->fieldname)
    730. 

  730. 				$fldIndex[$fld->fieldname]=$key;
    731. 

  731. 		
    732. 

  732. 		$bodyfld=$this->askImport->bodyfield;
    733. 

  733. 		if (empty($bodyfld))
    734. 

  734. 			$bodyfld="message";
    735. 

  735. 

  736. 		?>
    737. 

  737. 		<table cellspacing="2" align="center" class="importMailForm">
    738. 

  738. 		<tbody>
    739. 

  739. 		<tr><td colspan="3" align=center class='title'>&nbsp;&nbsp;</td><tr>
    740. 

  740. 		<?php 
    741. 

  741. 			foreach($this->askImport->mandatory as $fld){
    742. 

  742. 				if ($fld == $bodyfld)
    743. 

  743. 					continue;
    744. 

  744. 			?>
    745. 

  745. 		<tr><td class="field"><?php
    746. 

  746. 				$form->model[$fldIndex[$fld]]->RenderAddTitle($form);
    747. 

  747. 		?></td><td class="value"><?php
    748. 

  748. 				if(isset($temail[$fld]))
    749. 

  749. 					echo htmlspecialchars($temail[$fld]);
    750. 

  750. 		?></td></tr>
    751. 

  751. 		<?php
    752. 

  752. 			}
    753. 

  753. 		?>
    754. 

  754. 		<tr><td class="field">&nbsp;</td><td class= "value">&nbsp;</td></tr>
    755. 

  755. 		<?php
    756. 

  756. 			foreach($this->askImport->optional as $fld){
    757. 

  757. 				if ($fld == $bodyfld)
    758. 

  758. 					continue;
    759. 

  759. 			?>
    760. 

  760. 		<tr><td class="field"><?php
    761. 

  761. 				$form->model[$fldIndex[$fld]]->RenderAddTitle($form);
    762. 

  762. 		?></td><td class="value"><?php
    763. 

  763. 				if(isset($temail[$fld]))
    764. 

  764. 					$form->model[$fldIndex[$fld]]->DispList($temail,$form);
    765. 

  765. 		?></td></tr>
    766. 

  766. 		<?php
    767. 

  767. 			}
    768. 

  768. 		?>
    769. 

  769. 		<tr><td colspan="3" align=center class='title'><?= $form->model[$fldIndex[$bodyfld]]->fieldtitle ?></td></tr>
    770. 

  770. 		<tr><td class="message" colspan="2">
    771. 

  771. 		<?= nl2br(htmlspecialchars($temail[$bodyfld])) ?>
    772. 

  772. 		</td></tr></tbody>
    773. 

  773. 		</table>
    774. 

  774. 		<?
    775. 

  775. 	}
    776. 

  776. };
    777. 

  777. /** This class performs the SQL import */
    778. 

  778. class ImportView extends FormView {
    779. 

  779. 	protected $askImport;
    780. 

  780. 	protected $movedFile;
    781. 

  781. 	
    782. 

  782. 	public function ImportView(AskImportView &$ai){
    783. 

  783. 		$this->askImport = &$ai;
    784. 

  784. 	}
    785. 

  785. 	
    786. 

  786. 	public function PerformAction(&$form){
    787. 

  787. 		$dbg_elem = new DbgElem();
    788. 

  788. 		
    789. 

  789. 		if ($form->FG_DEBUG>0)
    790. 

  790. 			array_unshift($form->pre_elems,$dbg_elem);
    791. 

  791. 		
    792. 

  792. 		$dbg_elem->content .= print_r($_POST,true) . "\n";
    793. 

  793. 		if ((!isset($_SESSION[$form->prefix.'importRnd'])) || 
    794. 

  794. 			($_SESSION[$form->prefix.'importRnd'] != $form->getpost_single('rnd'))){
    795. 

  795. 			$form->pre_elems[] = new ErrorElem(_("Session Error, cannot import!"));
    796. 

  796. 			$dbg_elem->content .="Random didn't match!\n";
    797. 

  797. 			if ($form->FG_DEBUG>3) $dbg_elem->content .= print_r($_SESSION,true);
    798. 

  798. 			$form->setAction('idle');
    799. 

  799. 			return;
    800. 

  800. 		}
    801. 

  801. 	
    802. 

  802. 		if (!isset($_SESSION[$form->prefix.'importFile']) ||
    803. 

  803. 			!is_readable($_SESSION[$form->prefix.'importFile'])){
    804. 

  804. 			$form->pre_elems[] = new ErrorElem(_("Session Error, file vanished!"));
    805. 

  805. 			$dbg_elem->content .="Cannot read ".$_SESSION[$form->prefix.'importFile'] ." \n";
    806. 

  806. 			$form->setAction('idle');
    807. 

  807. 			return;
    808. 

  808. 		}
    809. 

  809. 		
    810. 

  810. 		$dbg_elem->content .="Ready to open ".$_SESSION[$form->prefix.'importFile'] ." \n";
    811. 

  811. 		$this->movedFile= $_SESSION[$form->prefix.'importFile'];
    812. 

  812. 	
    813. 

  813. 		if (!isset($_SESSION[$form->prefix.'importFields'])) {
    814. 

  814. 			$form->pre_elems[] = new ErrorElem(_("Session Error !"));
    815. 

  815. 			$dbg_elem->content .="Fields vanished from session. \n";
    816. 

  816. 			$form->setAction('idle');
    817. 

  817. 			return;
    818. 

  818. 		}
    819. 

  819. 	
    820. 

  820. 	}
    821. 

  821. 	
    822. 

  822. 	public function Render(&$form){
    823. 

  823. 		$dbhandle = $form->a2billing->DBHandle();
    824. 

  824. 		$fldIndex = array();
    825. 

  825. 		
    826. 

  826. 		
    827. 

  827. 		?><div class='impA-progress' name="<?= $form->prefix?>iprogress">
    828. 

  828. 			<?= _("Importing uploaded data...") ?>
    829. 

  829. 			<span name="<?= $form->prefix?>icount"> </span>
    830. 

  830. 		<div>
    831. 

  831. 		
    832. 

  832. 		<?php
    833. 

  833. 			// Construct, again, the list of fields
    834. 

  834. 		foreach ($form->model as $key => $fld)
    835. 

  835. 			if ($fld->fieldname)
    836. 

  836. 				$fldIndex[$fld->fieldname]=$key;
    837. 

  837. 

  838. 		$fields2= array();
    839. 

  839. 		$returning = array();
    840. 

  840. 		$fields = explode(',',$_SESSION[$form->prefix.'importFields']);
    841. 

  841. 		foreach($fields as $fld){
    842. 

  842. 			$retk = null;
    843. 

  843. 			$ext = false;
    844. 

  844. 				//does it aggregate over CSV rows?
    845. 

  845. 			$aggr = in_array($fld,$this->askImport->multiple);
    846. 

  846. 			
    847. 

  847. 				// does it belong to the primary INSERT or to
    848. 

  848. 				// some subsequent?
    849. 

  849. 			if ($form->model[$fldIndex[$fld]] instanceof RevRef){
    850. 

  850. 				$ext = true;
    851. 

  851. 				$retk = $form->model[$fldIndex[$fld]]->localkey;
    852. 

  852. 			}
    853. 

  853. 

  854. 			$fields2[] = array($fld,$fldIndex[$fld],$aggr,$ext, $retk);
    855. 

  855. 		}
    856. 

  856. 		
    857. 

  857. 		unset($fields);
    858. 

  858. 		
    859. 

  859. 		if ($form->FG_DEBUG >4) {
    860. 

  860. 			echo nl2br(htmlspecialchars(print_r($fields2,true)));
    861. 

  861. 			echo "<br>\n";
    862. 

  862. 		}
    863. 

  863. 		
    864. 

  864. 		// Build primary INSERT
    865. 

  865. 

  866. 		$ins_keys = array();
    867. 

  867. 		//$ins_values = array();
    868. 

  868. 		$ins_qm = array();
    869. 

  869. 		$ins_returning = array();
    870. 

  870. 		
    871. 

  871. 			// Find 
    872. 

  872. 		foreach($this->askImport->common as $fld){
    873. 

  873. 			$ins_keys[] = $fld;
    874. 

  874. 			$ins_qm[] = str_dbparams($dbhandle, "%!1",
    875. 

  875. 				array( $form->model[$fldIndex[$fld]]->
    876. 

  876. 					buildValue( $form->getpost_dirty($fld),$form)));
    877. 

  877. 		}
    878. 

  878. 		
    879. 

  879. 		foreach($fields2 as $fld)
    880. 

  880. 			if (!$fld[3]){
    881. 

  881. 				$ins_keys[]=$fld[0];
    882. 

  882. 				$ins_qm[] = '?';
    883. 

  883. 			}else
    884. 

  884. 				$ins_returning[] = $fld[4];
    885. 

  885. 

  886. 		$insert_pri = "INSERT INTO ". $form->model_table ."(" .
    887. 

  887. 			implode(', ',$ins_keys) . ") VALUES(". 
    888. 

  888. 			implode(',', $ins_qm).")";
    889. 

  889. 		if (count($ins_returning))
    890. 

  890. 			$insert_pri .= " RETURNING ".implode(', ',$ins_returning);
    891. 

  891. 		$insert_pri .=";";
    892. 

  892. 

  893. 		
    894. 

  894. 		if ($form->FG_DEBUG >1) {
    895. 

  895. 			echo "Insert query: ". htmlspecialchars($insert_pri) . "<br>\n";
    896. 

  896. 		}
    897. 

  897. 

  898. 		$fp = fopen($this->movedFile,  "r");
    899. 

  899. 		if (!$fp){
    900. 

  900. 			?><div class="error">
    901. 

  901. 				<?= _("Error: Cannot open uploaded file") ?>
    902. 

  902. 			</div>
    903. 

  903. 			<?php
    904. 

  904. 			return;
    905. 

  905. 		}
    906. 

  906. 

  907. 		$nrows = 0;
    908. 

  908. 		$nlines = 0;
    909. 

  909. 		$delimiter = $this->askImport->delimiter;
    910. 

  910. 		$multi_sep = $this->askImport->multi_sep;
    911. 

  911. 		$last_a = null;
    912. 

  912. 		$reted = null;
    913. 

  913. // 		$last_b = null;
    914. 

  914. 

  915. 			//Everything must be in one transaction, to avoid partially imported
    916. 

  916. 			//data
    917. 

  917. 		$dbhandle->StartTrans();
    918. 

  918. 		
    919. 

  919. 			// The actual import loop!
    920. 

  920. 		while (($larr = fgetcsv($fp,4096,$delimiter))!==false){
    921. 

  921. 			if ($larr===null)
    922. 

  922. 				continue;
    923. 

  923. 			if(count($larr)<count($fields2)){
    924. 

  924. 				if ($form->FG_DEBUG)
    925. 

  925. 					echo "Less fields came!<br>\n";
    926. 

  926. 				if ($form->FG_DEBUG>2)
    927. 

  927. 					echo nl2br(print_r($larr,true). "\n");
    928. 

  928. 				$dbhandle->FailTrans();
    929. 

  929. 				break;
    930. 

  930. 			}
    931. 

  931. 			$nlines++;
    932. 

  932. 			
    933. 

  933. 			$arr_a = array();
    934. 

  934. 			$arr_b = array();
    935. 

  935. 			$arr_ext = array();
    936. 

  936. 				//split the data into 2 arrays.
    937. 

  937. 			foreach($fields2 as $fld){
    938. 

  938. 				$val = $form->model[$fld[1]]->buildValue(current($larr),$form);
    939. 

  939. 				if(!$fld[2])
    940. 

  940. 					$arr_a[] = $val;
    941. 

  941. 				else if (!$fld[3])
    942. 

  942. 					$arr_b[] = $val;
    943. 

  943. 				else
    944. 

  944. 					$arr_c[$fld[0]] =$val;
    945. 

  945. 				next($larr);
    946. 

  946. 			}
    947. 

  947. 				//If non-multiple data matches, we reuse the line
    948. 

  948. 			if ($this->askImport->distinct && ($arr_a == $last_a)){
    949. 

  949. 			}
    950. 

  950. 			else{
    951. 

  951. 				if ($form->FG_DEBUG>2 && ($nrows<100)) {
    952. 

  952. 					echo "Data:" . htmlspecialchars(implode(', ',$arr_a)) . "<br>\n";
    953. 

  953. 				}
    954. 

  954. 				$res = $dbhandle->Execute($insert_pri,$arr_a);
    955. 

  955. 				
    956. 

  956. 				if(!$res){ ?>
    957. 

  957. 				<div class="error">
    958. 

  958. 					<?= _("Database error, cannot import!"); ?>
    959. 

  959. 				</div>
    960. 

  960. 				<?php if ($form->FG_DEBUG) {
    961. 

  961. 					echo $dbhandle->ErrorMsg();
    962. 

  962. 					echo "<br>\n";
    963. 

  963. 					}
    964. 

  964. 					$dbhandle->FailTrans();
    965. 

  965. 					return;
    966. 

  966. 				}elseif(count($ins_returning) && $res->EOF){ ?>
    967. 

  967. 				<div class="error">
    968. 

  968. 					<?= _("Database error, rows not imported!"); ?>
    969. 

  969. 				</div>
    970. 

  970. 				<?php if ($form->FG_DEBUG) {
    971. 

  971. 					echo "No result from insert operation!";
    972. 

  972. 					echo "<br>\n";
    973. 

  973. 					}
    974. 

  974. 					$dbhandle->FailTrans();
    975. 

  975. 					return;
    976. 

  976. 				}else
    977. 

  977. 					$reted = $res->fetchRow();
    978. 

  978. 					
    979. 

  979. 				if ($form->FG_DEBUG && !$res->EOF)
    980. 

  980. 					echo "Second result after INSERT? weird..<br>\n";
    981. 

  981. 				
    982. 

  982. 				if ($form->FG_DEBUG>2 && ($nlines <10) && count($ins_returning))
    983. 

  983. 					echo "Returned: " . print_r($reted,true) . "<br>\n";
    984. 

  984. 				$last_a = $arr_a;
    985. 

  985. 				$nrows++;
    986. 

  986. 			}
    987. 

  987. 			
    988. 

  988. 			if (count($arr_c))
    989. 

  989. 			    foreach ($fields2 as $fld) {
    990. 

  990. 				if(!$fld[3])
    991. 

  991. 					continue;
    992. 

  992. 				$mfld = &$form->model[$fld[1]];
    993. 

  993. 				$cqry = "INSERT INTO $mfld->reftable ($mfld->refid, $mfld->refname) VALUES ";
    994. 

  994. 				$data = explode($multi_sep,$arr_c[$fld[0]]);
    995. 

  995. 				if (! count($data)) continue;
    996. 

  996. 				$cqry_val = array();
    997. 

  997. 				foreach($data as $dat)
    998. 

  998. 					$cqry_val[] = str_dbparams($dbhandle,"(%1, %2)",array($reted[$mfld->localkey],$dat));
    999. 

  999. 				
    1000. 

  1000. 				$cqry .= implode(",\n",$cqry_val) . ";";
    1001. 

  1001. 				
    1002. 

  1002. 				if ($form->FG_DEBUG>2 && ($nlines<100)) {
    1003. 

  1003. 					echo "Extra: " . htmlspecialchars($cqry) ."<br>\n";
    1004. 

  1004. 				}
    1005. 

  1005. 				$res = $dbhandle->Execute($cqry);
    1006. 

  1006. 				if (!$res){ ?>
    1007. 

  1007. 				<div class="error">
    1008. 

  1008. 					<?= _("Database error, secondary rows not imported!"); ?>
    1009. 

  1009. 				</div>
    1010. 

  1010. 				<?php if ($form->FG_DEBUG) {
    1011. 

  1011. 					if ($form->FG_DEBUG>2)
    1012. 

  1012. 						echo "Query: " . htmlspecialchars($cqry) ."<br>\n";
    1013. 

  1013. 					echo $dbhandle->ErrorMsg();
    1014. 

  1014. 					echo "<br>\n";
    1015. 

  1015. 					}
    1016. 

  1016. 					$dbhandle->FailTrans();
    1017. 

  1017. 					return;
    1018. 

  1018. 				}
    1019. 

  1019. 			}
    1020. 

  1020. 

  1021. 			if (($nlines %1000) == 0) {
    1022. 

  1022. 				// reset the timer and give us another 20sec
    1023. 

  1023. 				set_time_limit(20);
    1024. 

  1024. 				if ($form->FG_DEBUG>1)
    1025. 

  1025. 					echo "Rows found: $nrows<br>\n";
    1026. 

  1026. 				?>
    1027. 

  1027. 	<script language="JavaScript" type="text/javascript">
    1028. 

  1028. 	document.getElementsByName("<?= $form->prefix?>icount")[0].innerHTML = "<?= 
    1029. 

  1029. 		str_params(_("%1 lines processed: %2 rows"), array($nlines,$nrows),1) ?>";
    1030. 

  1030. 	window.status = "<?= 
    1031. 

  1031. 		str_params(_("%1 lines processed: %2 rows"), array($nlines,$nrows),1) ?>";
    1032. 

  1032. 		</script>
    1033. 

  1033. 				<?php
    1034. 

  1034. 				@ob_end_flush(); // Make sure we flush the http data
    1035. 

  1035. 				
    1036. 

  1036. 			}
    1037. 

  1037. 		} //while fgets
    1038. 

  1038. 		
    1039. 

  1039. 		if ($dbhandle->CompleteTrans() ){
    1040. 

  1040. 		?>
    1041. 

  1041. 	<script language="JavaScript" type="text/javascript">
    1042. 

  1042. 	document.getElementsByName("<?= $form->prefix?>icount")[0].innerHTML = "<?= 
    1043. 

  1043. 		str_params(_("%1 lines processed: %2 rows"), array($nlines,$nrows),1) ?>";
    1044. 

  1044. 	window.status = "<?= 
    1045. 

  1045. 		str_params(_("%1 lines processed: %2 rows"), array($nlines,$nrows),1) ?>";
    1046. 

  1046. 		</script>
    1047. 

  1047. 		<?php
    1048. 

  1048. 		}
    1049. 

  1049. 		else{
    1050. 

  1050. 			echo _("Import of data aborted.");
    1051. 

  1051. 			echo "<br>\n";
    1052. 

  1052. 		}
    1053. 

  1053. 		
    1054. 

  1054. 		unset($_SESSION[$form->prefix.'importFile']);
    1055. 

  1055. 		unset($_SESSION[$form->prefix.'importFields']);
    1056. 

  1056. 		unset($_SESSION[$form->prefix.'importRnd']);
    1057. 

  1057. 		@unlink($this->movedFile);
    1058. 

  1058. 	} // Render
    1059. 

  1059. };
    1060. 

  1060. 

  1061. ?>
    1062. 

  1062.