فتحات العرب Joomla! • Index page: Joomla! 2.5 Coding • error

Wednesday, September 3, 2014

Joomla! 2.5 Coding • error

hello

i have one website it is product site that site feed another Target Components XML website but now it doesn't working my Target importer please help me :'( check me code



defined('_JEXEC') or die;



JHtml::_('behavior.tooltip');

JHTML::_('script','system/multiselect.js',false,true);

$user= JFactory::getUser();

$userId= $user->get('id');

$listOrder= $this->state->get('list.ordering');

$listDirn= $this->state->get('list.direction');

$canOrder= $user->authorise('core.edit.state', 'com_targetimporter');

$saveOrder= $listOrder == 'a.ordering';

?>



<form action="<?php echo JRoute::_('index.php?option=com_targetimporter&view=allproducts'); ?>" method="post" name="adminForm" id="adminForm">

<fieldset id="filter-bar">

<div class="filter-search fltlft">

<label class="filter-search-lbl" for="filter_search"><?php echo JText::_('JSEARCH_FILTER_LABEL'); ?></label>

<input type="text" name="filter_search" id="filter_search" value="<?php echo $this->escape($this->state->get('filter.search')); ?>" title="<?php echo JText::_('Search'); ?>" />

<button type="submit"><?php echo JText::_('JSEARCH_FILTER_SUBMIT'); ?></button>

<button type="button" onclick="document.id('filter_search').value='';this.form.submit();"><?php echo JText::_('JSEARCH_FILTER_CLEAR'); ?></button>

</div>

<div class="filter-select fltrt">





<select name="filter_published" class="inputbox" onchange="this.form.submit()">

<option value=""><?php echo JText::_('JOPTION_SELECT_PUBLISHED');?></option>

<?php echo JHtml::_('select.options', JHtml::_('jgrid.publishedOptions'), "value", "text", $this->state->get('filter.state'), true);?>

</select>





</div>

</fieldset>

<div class="clr"> </div>



<table class="adminlist">

<thead>

<tr>

<th width="1%">

<input type="checkbox" name="checkall-toggle" value="" onclick="checkAll(this)" />

</th>



<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_STOCKCODE', 'a.stockcode', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_THUMBNAILURL', 'a.thumbnailurl', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_MANUFACTURER', 'a.manufacturer', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_MANUPARTCODE', 'a.manupartcode', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_PRICE', 'a.price', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_PRICE5OFF', 'a.price5off', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_PRICE20OFF', 'a.price20off', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_CATEGORY', 'a.category', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_STOCK', 'a.stock', $listDirn, $listOrder); ?>

</th>

<th class='left'>

<?php echo JHtml::_('grid.sort', 'COM_TARGETIMPORTER_ALLPRODUCTS_VIRTUMARTCAT', 'a.virtumartcat', $listDirn, $listOrder); ?>

</th>





<?php if (isset($this->items[0]->state)) { ?>

<th width="5%">

<?php echo JHtml::_('grid.sort', 'JPUBLISHED', 'a.state', $listDirn, $listOrder); ?>

</th>

<?php } ?>

<?php if (isset($this->items[0]->ordering)) { ?>

<th width="10%">

<?php echo JHtml::_('grid.sort', 'JGRID_HEADING_ORDERING', 'a.ordering', $listDirn, $listOrder); ?>

<?php if ($canOrder && $saveOrder) :?>

<?php echo JHtml::_('grid.order', $this->items, 'filesave.png', 'allproducts.saveorder'); ?>

<?php endif; ?>

</th>

<?php } ?>

<?php if (isset($this->items[0]->id)) { ?>

<th width="1%" class="nowrap">

<?php echo JHtml::_('grid.sort', 'JGRID_HEADING_ID', 'a.id', $listDirn, $listOrder); ?>

</th>

<?php } ?>

</tr>

</thead>

<tfoot>

<tr>

<td colspan="10">

<?php echo $this->pagination->getListFooter(); ?>

</td>

</tr>

</tfoot>

<tbody>

<?php foreach ($this->items as $i => $item) :

$ordering= ($listOrder == 'a.ordering');

$canCreate= $user->authorise('core.create','com_targetimporter');

$canEdit= $user->authorise('core.edit','com_targetimporter');

$canCheckin= $user->authorise('core.manage','com_targetimporter');

$canChange= $user->authorise('core.edit.state','com_targetimporter');

?>

<tr class="row<?php echo $i % 2; ?>">

<td class="center">

<?php echo JHtml::_('grid.id', $i, $item->id); ?>

</td>



<td>

<?php if (isset($item->checked_out) && $item->checked_out) : ?>

<?php echo JHtml::_('jgrid.checkedout', $i, $item->editor, $item->checked_out_time, 'allproducts.', $canCheckin); ?>

<?php endif; ?>

<?php if ($canEdit) : ?>

<a href="<?php echo JRoute::_('index.php?option=com_targetimporter&task=allproduct.edit&id='.(int) $item->id); ?>">

<?php echo $this->escape($item->stockcode); ?></a>

<?php else : ?>

<?php echo $this->escape($item->stockcode); ?>

<?php endif; ?>

</td>

<td>

<a class="modal" href="<?php echo $item->imageurl; ?>"><img style="width:50px; height:auto;" src="<?php echo $item->thumbnailurl; ?>" /></a>

</td>

<td>

<?php echo $item->manufacturer; ?>

</td>

<td>

<?php echo $item->manupartcode; ?>

</td>

<td>

<?php echo $item->price; ?>

</td>

<td>

<?php echo $item->price5off; ?>

</td>

<td>

<?php echo $item->price20off; ?>

</td>

<td>

<?php echo $item->category; ?>

</td>

<td>

<?php echo $item->stock; ?>

</td>

<td>

<?php //echo $item->virtumartcat;

//get the vm category id

$tarcat = $item->category;

//echo $tarcat;



$db = JFactory :: getDBO();

$query = "SELECT * from #__targetimporter_category WHERE categorycode = '$tarcat'";

$db->setQuery($query);

$result = $db->loadObjectList();

foreach($result as $row){

$tarcatid = $row->id;

$vmparent = $row->parent;

}

echo $vmparent;









if($vmparent){

// echo $tarcatid;

$prid = $item->id;

$prcode = $item->stockcode;

$prprice = $item->price;

$prdescription = $item->description;

$prextendeddescription = $item->extendeddescription;

$primg = $item->imageurl;

$prthum = $item->thumbnailurl;

$prlargeimg = $item->largeimageurl;

$prmanuf = $item->manufacturer;

$prmanucode = $item->manupartcode;

$prweight = $item->weight;

$prprice = $item->price;

$prcategory = $item->category;

$prstock = $item->stock;



// calcualte new price



if ($prprice <= 3) { $newprice = $prprice + ($prprice*0.03); }

elseif ($prprice > 3 && $prprice <= 5) { $newprice = $prprice + ($prprice*0.01); }

elseif ($prprice > 5 && $prprice <= 10) { $newprice = $prprice + ($prprice*0.5); }

elseif ($prprice > 10 && $prprice <= 20) { $newprice = $prprice + ($prprice*0.2); }

elseif ($prprice > 20 && $prprice <= 50) { $newprice = $prprice + ($prprice*0.17); }

elseif ($prprice > 50 && $prprice <= 100) { $newprice = $prprice + ($prprice*0.15); }

elseif ($prprice > 100 && $prprice <= 1000) { $newprice = $prprice + ($prprice*0.12); }

elseif ($prprice > 1000) { $newprice = $prprice + ($prprice*0.12); }

//echo $prprice.'newprice'. $newprice;

$newpricerounded = round($newprice, 2);

//echo $newpricerounded;





//echo 'a script to insert or update product goes here';





//echo $prid;



$db = JFactory :: getDBO();

$query = "select * from #__virtuemart_products WHERE targetid = '$prid'";

$db->setQuery($query);

$result = $db->loadObjectList();

if($result){

echo "update produc";

$db = JFactory :: getDBO();

$query = "UPDATE #__virtuemart_product_categories SET virtuemart_category_id='$vmparent' WHERE targetid= '$prid'";

$db->setQuery($query);

$db->query();





$db = JFactory :: getDBO();

$query = "UPDATE #__virtuemart_product_prices SET product_price='$newpricerounded' WHERE targetid= '$prid'";

$db->setQuery($query);

$db->query();



$db = JFactory :: getDBO();

$query = "UPDATE #__virtuemart_products_en_gb SET product_price='$newpricerounded' WHERE targetid= '$prid'";

$db->setQuery($query);

$db->query();



$db = JFactory :: getDBO();

$query = "SELECT * from #__virtuemart_products WHERE targetid = '$prid'";

$db->setQuery($query);

$result = $db->loadObjectList();

foreach($result as $row){

$vmproidd = $row->virtuemart_product_id;







$query = "SELECT * from #__virtuemart_products_en_gb WHERE virtuemart_product_id = '$prid'";

$db->setQuery($query);

$result = $db->loadObjectList();



//echo'a';

//echo $prid;

if(!$result){

//echo 'b';

//$db = JFactory :: getDBO();

$query = "INSERT INTO #__virtuemart_products_en_gb (virtuemart_product_id,product_s_desc,product_desc,product_name,slug)

VALUES ('$prid','$prdescription','$prextendeddescription','$prdescription','$prcode')";

$db->setQuery($query);

$db->query();



}





}

//echo $prid;

//echo $vmproidd;

/*

$query = "UPDATE #__virtuemart_product_prices SET virtuemart_product_id='$vmproidd' WHERE targetid = '$prid'"; //,,product_price,product_currency)

$db->setQuery($query);

$db->query();

*

$query = "UPDATE #__virtuemart_product_medias SET virtuemart_product_id='$vmproidd' WHERE targetid = '$prid'"; //,,product_price,product_currency)

$db->setQuery($query);

$db->query();



$query = "INSERT INTO #__virtuemart_product_medias (targetid,virtuemart_product_id,virtuemart_media_id)

VALUES ('$prid','$vmproidd','$prid')";

$db->setQuery($query);

$db->query();

*/



//update

}else{

echo "insert";

$db = JFactory :: getDBO();

$query = "INSERT INTO #__virtuemart_products (targetid,virtuemart_vendor_id,product_sku,product_weight,published)

VALUES ('$prid','1','$prcode','$prweight','1')";

$db->setQuery($query);

$db->query();



$db = JFactory :: getDBO();

$query = "INSERT INTO #__virtuemart_products_en_gb (targetid,product_s_desc,product_desc,product_name,slug)

VALUES ('$prid','$prdescription','$prextendeddescription','$prdescription','$prcode')";

$db->setQuery($query);

$db->query();





$db = JFactory :: getDBO();

$query = "SELECT * from #__virtuemart_products WHERE targetid = '$prid'";

$db->setQuery($query);

$result = $db->loadObjectList();

foreach($result as $row){

$vmproidd = $row->virtuemart_product_id;

}

echo $prid;

echo $vmproidd;





$query = "INSERT INTO #__virtuemart_product_categories (targetid,virtuemart_product_id,virtuemart_category_id)

VALUES ('$prid','$vmproidd','$vmparent')";

$db->setQuery($query);

$db->query();



$query = "INSERT INTO #__virtuemart_product_prices (targetid,virtuemart_product_id,product_price,product_currency)

VALUES ('$prid','$vmproidd','$newpricerounded','52')";

$db->setQuery($query);

$db->query();



$query = "INSERT INTO #__virtuemart_medias(targetid,file_title,file_mimetype,file_type,file_url,file_url_thumb,published)

VALUES ('$prid','$primg','image/jpeg','product','$primg','$prthum','1')";

$db->setQuery($query);

$db->query();



$query = "INSERT INTO #__virtuemart_product_medias (targetid,virtuemart_product_id,virtuemart_media_id)

VALUES ('$prid','$vmproidd','$prid')";

$db->setQuery($query);

$db->query();



}















}







//echo $tarcatid;



//echo $item->category;

/*

$db = JFactory :: getDBO();

$query = "SELECT * from #__virtuemart_categories WHERE targetid= '$tarcatid'";

$db->setQuery($query);

$result = $db->loadObjectList();

foreach($result as $row){

$vmcatiid = $row->virtuemart_category_id;

}

//echo '-';

//echo $vmcatiid;













// check if the produc cat exist in virue mart



$db = JFactory :: getDBO();

$query = "SELECT * from #__virtuemart_categories WHERE virtuemart_category_id = '$vmcatiid'";

$db->setQuery($query);

$result = $db->loadObjectList();

if($result){

//echo "cat exist in vm ad product to vm";



// check if the product exist and update first



$db = JFactory :: getDBO();

$query = "select * from #__virtuemart_products WHERE targetid = '$prid'";

$db->setQuery($query);

$result = $db->loadObjectList();

if($result){











}else{

echo "cat dont exist in vm";

}

*/



?>

</td>





<?php if (isset($this->items[0]->state)) { ?>

<td class="center">

<?php echo JHtml::_('jgrid.published', $item->state, $i, 'allproducts.', $canChange, 'cb'); ?>

</td>

<?php } ?>

<?php if (isset($this->items[0]->ordering)) { ?>

<td class="order">

<?php if ($canChange) : ?>

<?php if ($saveOrder) :?>

<?php if ($listDirn == 'asc') : ?>

<span><?php echo $this->pagination->orderUpIcon($i, true, 'allproducts.orderup', 'JLIB_HTML_MOVE_UP', $ordering); ?></span>

<span><?php echo $this->pagination->orderDownIcon($i, $this->pagination->total, true, 'allproducts.orderdown', 'JLIB_HTML_MOVE_DOWN', $ordering); ?></span>

<?php elseif ($listDirn == 'desc') : ?>

<span><?php echo $this->pagination->orderUpIcon($i, true, 'allproducts.orderdown', 'JLIB_HTML_MOVE_UP', $ordering); ?></span>

<span><?php echo $this->pagination->orderDownIcon($i, $this->pagination->total, true, 'allproducts.orderup', 'JLIB_HTML_MOVE_DOWN', $ordering); ?></span>

<?php endif; ?>

<?php endif; ?>

<?php $disabled = $saveOrder ? '' : 'disabled="disabled"'; ?>

<input type="text" name="order[]" size="5" value="<?php echo $item->ordering;?>" <?php echo $disabled ?> class="text-area-order" />

<?php else : ?>

<?php echo $item->ordering; ?>

<?php endif; ?>

</td>

<?php } ?>

<?php if (isset($this->items[0]->id)) { ?>

<td class="center">

<?php echo (int) $item->id; ?>

</td>

<?php } ?>

</tr>

<?php endforeach; ?>

</tbody>

</table>



<div>

<input type="hidden" name="task" value="" />

<input type="hidden" name="boxchecked" value="0" />

<input type="hidden" name="filter_order" value="<?php echo $listOrder; ?>" />

<input type="hidden" name="filter_order_Dir" value="<?php echo $listDirn; ?>" />

<?php echo JHtml::_('form.token'); ?>

</div>

</form>

Statistics: Posted by furiousit — Wed Sep 03, 2014 2:28 pm







via Joomla! http://ift.tt/1ttsOBx
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)