Jump to content

cmgmyr

Members
 View Profile  See their activity

  • Posts

    1,278

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by cmgmyr

    Force WWW on multiple sites

    in Apache HTTP Server

    Posted

    Hello everyone,

    I have a site where any number of other domains can point to it. Right now I just have:

    RewriteCond %{HTTP_HOST} ^domain.com [NC] 
RewriteRule ^(.*)$ http://www.domain.com/$1 [L,R=301]

    Which obviously just works for domain.com how can I adjust this so it forces the redirect for any domain that comes through?

     

    Thanks in advance,

    -Chris

    SaaS or Stand-Alone?

    in Application Design

    Posted

    I thought about your comment some more and yes, you are right. Right now it just comes down to a few things:

     

    money - why not get $3-$5K for a site plus future upgrades as opposed to $50-$100/mo?

    time - I only have so much time do do the development on the custom sites and the SaaS sites, to combine them I would need more time. I still need to stay on track with deadlines, so it's easier to keep them separate.

     

    So again, yes you are right about moving everything over to the SaaS system and I probably will be doing that in the not too far off future, right now it just doesn't make sense to.

    SaaS or Stand-Alone?

    in Application Design

    Posted

    No, unfortunately I don't have anything up live yet. I'm hoping to get the "main" company site up sometime this week. I will update this post again once it's up and running though.

     

    Thanks for your 2 cents. You are half right about that (IMO). There are a lot of clients/companies that want specialized features that others might not want, or would be hard to develop SaaS wise. If you are talking about e-commerce, some just have straight forward pricing, others have crazy price structures that need extra attention. For the purposes of this project I'm just going to offer very straight forward pricing and shipping options in order to keep the programming as simple as possible and to keep my development time to a minimum. In the future I can adjust it as I get more feedback about the system, I'm sure I could develop other module/plugins for these specific features (similar to magento). BUT, my business "plan", if you will, is similar to 37 signals which is keep it simple and easy so anyone can use your product. Magento is a great program but definitely bloated and very hard for un-tech savvy people to use right out of the box.

     

    I have a few people signed up for this service right now so I want to get it up and running asap, then I can develop more for it as it becomes larger (and I start making some $$$).

     

    I hope all of that made sense :)

    SaaS or Stand-Alone?

    in Application Design

    Posted

    Thanks for the feedback, that's what I ended up going with. I haven't gotten through all of the details yet but it's going well so far.

     

    Also, to take it a step further, once I'm finished with the programming I'm going to duplicate it, take out all of the SaaS features so it's a "one company" site, and use that as a base for my custom sites if someone wants some additional features. That will cut down about 80% of my time for my custom stuff, which is huge. So just like you said "money in the bank"!

    Database Design - Packages, Options, Users

    in Application Design

    Posted

    I would add some additional data to the tables

     

    packages (package_id, name, price, sort)

    options (option_id, name, price, base_package_id)

     

    First I would see which package they selected, on the next page list options that are above that "sort" value and attached to the "base_package_id". So at that point that package sequence is based on the "sort" since I could delete packages or add some, so after a while the ID's wouldn't have any importance (as far as sorting goes).

    Database Design - Packages, Options, Users

    in Application Design

    Posted

    Thanks for the feedback. Your assumptions for 2 & 3 were correct, but not #1. The package price will be set as the "base price" then additional options can be added. What about this for the structure:

     

    packages (package_id, name, price)

    options (option_id, name, price, base_package_id)

     

    The total at checkout will be the package price plus whatever all of the options add up to that are not in that base_package_id. Would that work better?

    Database Design - Packages, Options, Users

    in Application Design

    Posted

    Hey Everyone,

    I'm having a tough time putting everything together in an efficient way, so I figured I would throw it out there to get some opinions. I have some web software where users can signup for a package, and each package has different options available. Users will also have the ability to add on an option that's not in their current package (instead of upgrading to the next package with that option), in order to save them some money. I would also need a simple way to query these options to see what they have available to them to open up or deny options to them.

     

    One of my thoughts is to have all of the packages in a table and have each option set to "yes" or "no" depending on if that option is allowed. Obviously this isn't that efficient as far as adding new features in the future.

     

    The other thought would be to create multiple tables:

    packages - package_id, name, price

    options - option_id, name, price

    packages_option_map - map_id, package_id, option_id

    users_map - user_map_id, user_id, map_id

     

    Is this the best way to handle this? Am I missing something? Any other advise/insight would also be helpful.

     

    Thanks in advance,

    -Chris

    SaaS or Stand-Alone?

    in Application Design

    Posted

    Hey Everyone,

    It's been a long time that I haven't been on here but it's good to be back. It looks like things have been changing a lot!

     

    I've been working on a new application that I will be offering to my clients/possible clients. For all intensive purposes it's a website builder with a lot of options in different price plans per month. I've built this in the CodeIgniter framework and with programming that has been tested on a number of other sites for the past 2 years...so it's pretty solid.

     

    My initial idea was to have one website controlling all of the other ones and set up sub-domains for users that they can set up CNAME's to for their domain, this way their clients/customers don't know they they are using my site. The idea is to be able to push out updates, new features, and bug fixes regularly. This would obviously lean toward the SaaS option.

     

    My second idea is to just take this software and install it for each domain. This would be a little easier at the moment and would take less time since I have most of this already done. The problem would be with the future updates. If I have one site it's not too bad to update, 10 sites would be a pain, 100 sites would take forever.

     

    Since I already have a few businesses "signed up" for this new service I would like to get it up and running as soon as possible for them, but I want to minimize the amount of time I would have to put into each one in the future. I'm still leaning toward the SaaS option but this means that I have to add in a lot more programming/logic initially before anyone can start using it.

     

    Has anyone done anything like this before? Any advice or opinions about each option? Any insight or feedback would be greatly appreciated.

     

    Thanks!

    -Chris

    Friends list - need opinions.

    in PHP Coding Help

    Posted

    If you use this:

    $user_id = 1;
SELECT * FROM friends WHERE (user_a = '$user_id' OR user_b = '$user_id') AND confirmed = 1

     

    Then for each row you do something like this:

    if($user_id != $row['user_a']){
$friend = $row['user_a'];
}else{
$friend = $row['user_b'];
}

    Friends list - need opinions.

    in PHP Coding Help

    Posted

    I think you need to look at this a little differently. In my opinion a "buddy list" is a 1 way list, this means that I can have you on my list but you don't need to have me on your list (think of AIM). But a friend's list is a 2 way list where both people need to agree to be friends (think of MySpace). I have a friend's list on one of my sites and I have a table dedicated to it. It makes it very easy to search/sort through everything and match people up on either profile (friend 1 or friend 2).

     

    hope this helped,

    -Chris

    [SOLVED] Markup and Markdown functions

    in PHP Coding Help

    Posted

    Ok, so after a few hours I finally figured it out. Here is the final code. Hope it helps someone out.

     

    function priceMarkUp($price, $comp_data, $dir='up'){
	//$debug = TRUE;
	if($comp_data->kiosk->markup_cost1 > 0 && $comp_data->kiosk->markup_cost2 > 0){
		//see which markup it is
		if($price >= $comp_data->kiosk->markup_cost2){
			$markup = $comp_data->kiosk->markup_per3;
		}elseif($price <= $comp_data->kiosk->markup_cost1){
			$markup = $comp_data->kiosk->markup_per1;
		}else{
			$markup = $comp_data->kiosk->markup_per2;
		}

		if($debug) echo "<br />markup = $markup <br />";

		$mod = 10;

		if($dir == 'up'){
			if($markup > 0){
				$total = round((($markup/100) + 1) * $price);
				if($debug) echo "$total = round((($markup/100) + 1) * $price) <br />";
			}else{
				$total = $price;
			}

			$mod_total = $total % $mod;
			if($debug) echo "$mod_total = $total % $mod <br />";
			$add = $mod - $mod_total;
			if($debug) echo "$add = $mod - $mod_total <br />";
			if($add == $mod) $add = 0;

			$total += $add;
			if($debug) echo "$total += $add <br />";
		}else{
			if($markup > 0){
				$total = round($price/(($markup/100) + 1));
				if($debug) echo "$total = round($price/(($markup/100) + 1)) <br />";
			}else{
				$total = $price;
			}

			$mod_total = $total % $mod;
			if($debug) echo "$mod_total = $total % $mod <br />";
			$add = $mod_total;
			if($debug) echo "$add = $mod_total <br />";
			if($add == $mod) $add = 0;

			$total -= $add;
			if($debug) echo "$total -= $add <br />";
		}

		return $total;
	}else{
		return $price;
	}
}

    [SOLVED] Markup and Markdown functions

    in PHP Coding Help

    Posted

    Hey everyone,

    I'm having a little bit of trouble with a markup and markdown function.

     

    Here is the code:

    function priceMarkUp($price, $comp_data, $dir='up'){
	$debug = TRUE;
	if($comp_data->kiosk->markup_cost1 > 0 && $comp_data->kiosk->markup_cost2 > 0){
		//see which markup it is
		if($price >= $comp_data->kiosk->markup_cost2){
			$markup = $comp_data->kiosk->markup_per3;
		}elseif($price <= $comp_data->kiosk->markup_cost1){
			$markup = $comp_data->kiosk->markup_per1;
		}else{
			$markup = $comp_data->kiosk->markup_per2;
		}

		if($debug) echo "<br />markup = $markup <br />";

		$mod = 10;

		if($dir == 'up'){
			if($markup > 0){
				$total = round($price + ($price * ($markup / 100)));
				if($debug) echo "$total = round($price + ($price * ($markup / 100))) <br />";
			}else{
				$total = $price;
			}

			$mod_total = $total % $mod;
			if($debug) echo "$mod_total = $total % $mod <br />";
			$add = $mod - $mod_total;
			if($debug) echo "$add = $mod - $mod_total <br />";
			if($add == $mod) $add = 0;

			$total += $add;
			if($debug) echo "$total += $add <br />";
		}else{
			if($markup > 0){
				$total = round($price - ($price / ($markup / 100)));
				if($debug) echo "$total = round($price - ($price / ($markup / 100))) <br />";
			}else{
				$total = $price;
			}

			$mod_total = $total % $mod;
			if($debug) echo "$mod_total = $total % $mod <br />";
			$add = $mod_total;
			if($debug) echo "$add = $mod_total <br />";
			if($add == $mod) $add = 0;

			$total -= $add;
			if($debug) echo "$total -= $add <br />";
		}

		return $total;
	}else{
		return $price;
	}
}

    $comp_data is an array with different customer data in it. It has the start price and end price for different markups and the actual markups for those levels. Pretty much what I need help with is the actual formula for doing the markups or down. Let me know if you have any questions or if something doesn't make sense.

     

    Thanks in advance,

    -Chris

    PHP/MySQL Developer

    in Archived Job Offerings

    Posted

    I am looking for someone to help out with my web development/IT company. I have a lot of clients that I do many things for including programming, coding, design, flash, and other development. I’m looking for someone to help with these. I’m primarily looking for someone who is web savvy and has a strong grasp on PHP, MySQL, security, and other web technologies.

     

    I would like to get someone to abide by my coding and programming standards so that we can work flawlessly together. I am also very open to ways to improve the coding and programming. I would like to work with you to develop a stronger programming base. This is a great opportunity for anyone who likes doing this work.

     

    Languages/technologies required:

    PHP

    MySQL

     

    Additional languages/technologies:

    Flash

    JavaScript/ AJAX

     

    I would like to find someone in the Syracuse, NY/CNY area, but I am open to anyone in the US. English and strong communication is a MUST, and you must also be very detail oriented. I would also need you to be willing to work with a small development team.

     

    I have lots of clients and work waiting for the right person. Please respond with a resume and portfolio of live sites that you have built or worked on. Please also list your roles and responsibilities.

     

    Hourly rate is negotiable depending on experience. Please include what you charge in your reply. You need to have 3+ years experience.

     

    You can PM me or send me an email to chris [at] syracusecs {dot} com

    Tricky Query

    in MySQL Help

    Posted

    Well it kinda worked but it's not the results that I wanted. I want it to show the top level category, then the sub-cat (if available) then the sub-sub-cat (if available) in the same row.

    Tricky Query

    in MySQL Help

    Posted

    no, that wouldn't work. p.category could be t1.id, t2.id, or t3.id I'm looking for something like this:

    SELECT p.id, p.styleno, t1.name AS category1, t2.name as category2, t3.name as category3, p.description, p.price, p.sort 
		FROM 
			categories AS t1
		LEFT JOIN 
			categories AS t2 ON t2.parentid = t1.id
		LEFT JOIN 
			categories AS t3 ON t3.parentid = t2.id
		IF t3.id <> NULL INNER JOIN products AS p ON t3.id = p.category
		ELSE IF t2.id <> NULL INNER JOIN products AS p ON t2.id = p.category
		ELSE INNER JOIN products AS p ON t1.id = p.category

    which obviously that doesn't work...

    Tricky Query

    in MySQL Help

    Posted

    It's an export of a products table. I want it to show all of the data from the products table along with the names of the categories (and subs if available) instead of the category id.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.