how to change status more than one serial at once?

dado023
Topic Author
Offline

14 years 1 week ago #66101 by dado023

how to change status more than one serial at once? was created by dado023

I have imported few dozen serials, and they all have status Free to use, but i need them all to have status Unassigned.
How do i change status of all those keys at one go?

regards
Dan

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 1 week ago - 14 years 1 week ago #66140 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi Dan,

For the moment, the SQL request is the fastest way to update several serial at the same time.
I will include in the next release of HikaSerial a button which would allow you to modify several serials at the same time.
Is the status the only element that you wanted to update ?

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Last edit: 14 years 1 week ago by Jerome.

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago #66142 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

Hi Jerome,

thanks for the response.
Now when you are mentioning updates, i have few other requests.
In my case i use URLs in serials, those urls are link to pictures on dropbox. It would be great if those urls would be clickable in frontend customer view, so customer could click on it, instead of doing copy/paste to another browser window, or even better it would be best if just window popus up in a form of lightbox.

Do you have skype?

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago #66143 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

forgot to mention, i am not sure how SQL request looks like, nor how to use it in this case.
Please provide me instructions how to do that, because i have a lot of serials to import.

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 1 week ago - 14 years 1 week ago #66144 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi,

HikaSerial allow to override his views so you can override the way that your serial would be displayed in the front end.
You can modify the view for the "orderserial | show_order_front_show" or you can override the function "onDisplaySerials" (which is not quite documented yet).
The feature is already implemented. Using view override you can create the html you want, using the lightbox system that you need.

About the SQL request, you something like:

Code:

UPDATE #__hikaserial_serial SET serial_status = "unassigned" WHERE serial_status = "free" AND serial_id >= 50 AND serial_id <= 100;

You can use PhpMyAdmin or the special SQL task in the backend of HikaSerial ( index.php?option=com_hikaserial&ctrl=config&task=sql | SuperAdmin account required )

Regards,

Last edit: 14 years 1 week ago by Jerome.

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago - 14 years 1 week ago #66146 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

this is what i have in show_order_front_show :

Code:

<?php
/**
 * @package    HikaSerial for Joomla!
 * @version    1.4.0
 * @author     Obsidev S.A.R.L.
 * @copyright  (C) 2011-2012 OBSIDEV. All rights reserved.
 * @license    GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><fieldset>
  <legend><?php echo JText::_('HIKA_SERIALS')?></legend>
<?php 
if(!empty($this->data)) {
?>
  <table style="width:100%;cell-spacing:1px;">
    <thead>
      <tr>
        <th><?php echo JText::_('PACK_NAME');?></th>
        <th><?php echo JText::_('SERIAL_DATA');?></th>
        <th><?php echo JText::_('ASSIGN_DATE');?></th>
        <th><?php echo JText::_('ATTACHED_TO_PRODUCT');?></th>
      </tr>
    </thead>
    <tbody>
<?php
  foreach($this->data as $data) {
?>
    <tr>
      <td><?php echo $data->pack_name;?></td>
      <td><?php echo $data->serial_data; ?></td>
      <td><?php echo hikaserial::getDate($data->serial_assign_date);?>
      <td><?php echo $data->order_product_name; ?></td>
    </tr>
<?php
  }
?>
    </tbody>
  </table>
<?php
}
?>
</fieldset>

So where should i insert

Code:

<a </a>

Last edit: 14 years 1 week ago by dado023.

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago - 14 years 1 week ago #66149 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

ok, i think i have figured it out:

Code:

<td><a href="<?php echo $data->serial_data; ?>/"rel="width:480,height:240" class="ANYclassTHATgivesLightBOX"><img border="0" src="<?php echo $data->serial_data; ?>" alt="<?php echo $data->serial_data; ?>" width="256" height="128" /></a></td>

....it pops out in nice lightbox
Is it possible to make dimensions adjust to image size in light box, or it need to be fixed like in example above

Now my main question is, WILL THIS BE OVERWRITEN when next update of hikaserial is done?

Last edit: 14 years 1 week ago by dado023.

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago #66150 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

now i have a problem.
When it happens that i in Serial Data use plain ordinary text like 32fkm8s7z4, then it tries to display it in the front end as a picture/image.
Is it possible to somehow overcome this?

Thank you in advance
Dan

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 1 week ago #66165 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi,

You can base your display of your serial on the pack name, the pack id or the pack generator.

Code:

<td><?php
// The id of your pack with image links.
if($data->pack_id == 6) {
?>
  <a href="<?php echo $data->serial_data; ?>/"rel="width:480,height:240" class="ANYclassTHATgivesLightBOX"><img border="0" src="<?php echo $data->serial_data; ?>" alt="<?php echo $data->serial_data; ?>" width="256" height="128" /></a>
<?php
} else {
  echo $data->serial_data;
}
?></td>

Regards,

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago #66269 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

but can it be done "universal" not just for certain pack, beacuse often in packs will be mixed serials, sometimes urls(img) and sometimes plain text/numbers ?

regards
Dan

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 1 week ago #66272 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi,

You can check the content of the serial.

Code:

<td><?php
if(strpos($data->serial_data, 'http://') !== false) {
?>

Regards,

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 1 week ago - 14 years 1 week ago #66278 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

i have no clue or knowledge what so ever about coding, but this seems to be better solution for me.
Would you be so kind and give me complete code, that checks for .bmp .png .jpg. .jpeg and .gif content of serial, so if it doesnt find any of these, it should just display it as is text/numbers.

I hope i am not troubling you to much :blush:

thank you in advance

Last edit: 14 years 1 week ago by dado023.

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 6 days ago #66371 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

please let me know if this is doable, since i use mixed types of serials.

Thank you in advance
Dan

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 6 days ago #66377 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi,

This code will test if there is an extension (last characters of the serial data)

Code:

<td><?php
$ext = '';
if(strpos($data->serial_data, '.') !== false) {
  $ext = substr($data->serial_data, strrpos($data->serial_data));
  $ext = strtolower($ext);
}
if(!empty($ext) && in_array($ext, array('.bmp', '.jpg', '.jpeg', '.png', '.gif')) {
?>
  <a href="<?php echo $data->serial_data; ?>/"rel="width:480,height:240" class="ANYclassTHATgivesLightBOX"><img border="0" src="<?php echo $data->serial_data; ?>" alt="<?php echo $data->serial_data; ?>" width="256" height="128" /></a>
<?php
} else {
  echo $data->serial_data;
}
?></td>

Regards,

Please Log in or Create an account to join the conversation.

dado023
Topic Author
Offline

14 years 2 days ago #67048 by dado023

Replied by dado023 on topic Re: how to change status more than one serial at once?

i have tried that last code, but then order page doesnt display correctly......
would you be so kind and receck if you have missed somwhere with faulty code...pleaseee

tnx
Dan

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

14 years 2 days ago #67076 by Jerome

Replied by Jerome on topic Re: how to change status more than one serial at once?

Hi,

Maybe the missing space in the "<a>" tag, between the href and the rel.

Code:

<a href="<?php echo $data->serial_data; ?>" rel="width:480,height:240"

Regards,

Please Log in or Create an account to join the conversation.

Moderators: Obsidev

Time to create page: 0.406 seconds